You’re offline. This is a read only version of the page.
78
Hi there. I have a large SharePoint list, and in order to simplify entry across my company, I'm customizing the form. Great. However - I'm getting the issue below:
"The requested operation is invalid. Server Response: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator"
As I understand it, the limit is 12. Interesting, the root sharepoint list has 14 lookup columns (both Lookups and People/Groups included). But, two of those are Created by and Modified by, and since those don't show up on the Default SharePoint form, the form works. Similarly, all of the SharePoint views we use don't reference all 14 so those work too.
But - here we get to PowerApps. My custom for is only using about 6 of those 14. I could delete some of the other ones, but that would remove those entries in past records. Not ideal.
Is there a work-around? Any ideas? I'm | | this close with the form but I'm stuck...
Thank you!
Jill
If I have 10 lookup / person fields - NO issues.
After adding the 11th lookup / person field - there are issues with getting data in Power Apps.
With in the SharePoint list - NO issues, working fine having ALL the fields in any Views.
NOTE (as I understood): The limit is 12 like lookup / person fields (10 + 2 system ones - "Created by", "Modified by")
=================
Found - "Another option is to use indexed columns and filtering to keep the view size for the list to 5,000 items or less."
If you have MORE then 12 like lookup / person fields (10 + 2 system ones - "Created by", "Modified by"), INDEXING doesn't help ! - verified.
==================
SO, the only way to avoid errors in Power platform - to have LESS than 12 like lookup / person fields (10 + 2 system ones - "Created by", "Modified by").
Hi @RezaDorrani How to handle this in PowerApps?
In my requirement I cannot delete any column and facing same issue?
In sharepoint view i removed the column but in PowerApps gallery how to control that?
Thanks Vishal
Hi @JillH
PowerApps loads all the columns from the data source (no View based loading)
The limit is 12 lookups
This includes all person or group fields and date fields
Created By, Modified By, Created, Modified and 4 basic fields in every list/library
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
