PowerApps - The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold

1
votes

I am working on PowerApp, I got the below error when i added few columns in the sharepoint list.

The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold

enter image description here

I have read some article those says that sharepoint online 2013 supports only 12 lookup columns Here the link.

My List contains almost 15 People picker fields which causes this issue. How should I removed this error. Any solution will be appreciated.

1
sharepointsharepoint-2013powerapps

1 Answers

-2
votes

You can consider reworking this solution. Could you lower the number of people pickers - maybe make some of them multi people pickers. You could also split the list into two lists of data.