Configure suggested values for a column

Every column input in a form can prompt the user with a list of suggested values. For example, a column Industry of type Text could have Tech, Media and Construction as suggested values. 

The list of suggested values is optionally defined by an expression in the column definition. The expression could be a constant (such as, LIST("Tech", "Media")) or a dynamic expression (such as, SELECT(LookupTable[Option], [Category] = [_THISROW].[Category]).

Note: The suggested values constraint is a "soft" constraint: the list is not meant to be exhaustive or constraining. The user will be able to enter any other value that conforms to the column type (and the Valid_If constraint if one has been defined).

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu
5726924594083865229
true
Search Help Center
true
true
true
false
false