About SharePoint Lookup Columns - Power Platform Community

Skip to main content

In the setting of the SharePoint list, creating 11 or more columns of User or Group causes an error and does not work properly.

As we may use more than 11 columns in the "Users or Groups" column, please improve the function.

Status:

Comments

see also the common and very annoying issue: query can not be completed because number of lookup fields is 12. Apparently there is a sharepoint list limit of 12 lookups. If you use person/lookup fields in lists (which is very common in sharepoint lists) powerapps/flow throws this error.
: https://powerusers.microsoft.com/t5/General-Discussion/Error-The-query-cannot-be-completed-because-t...

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment