My Guelph Site

Search This Blog

Welcome

May 26, 2017

Get link
Facebook
X
Pinterest
Email
Other Apps

My Guelph Site welcomes everyone.

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

SharePoint: Not all column types can be used in Calculated or Lookup columns

A recent question in the MSDN forums got me to looking again at the limitations on the use of certain column types in calculations or lookups. The list of column types that can be used in lookups is quite limited, but with a trick using a calculated column we can add four more to the list. For my test I added all of the following columns to a custom list. These include the basic columns plus a few variations of options including each type of calculated column. Types that work for a Calculated column I then added a Calculated column. This is the list of fields offered for use in a calculation: Not included in this list were these columns: Types that work for Lookups I then added a lookup column to another list to see which column types could be used for lookups. Here’s what shows up: The only column types available for lookups are: And when a lookup has been selected, here is the list...

Powered by Blogger

Welcome

Comments

Post a Comment