cancel
Showing results for 
Search instead for 
Did you mean: 

About SharePoint Lookup Columns

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: New
Comments
Level: Powered On

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...