You’re offline. This is a read only version of the page.
13
Hi,
I am creating Power app form in one of the SharePoint lists. When I try to run it, I get this error "The requested operation is invalid. Server Response: NSR Test failed: The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold. clientRequestId: d261735b-d54f-466a-8889-e7db8fd8f4 serviceRequestId: d261735b-d54f-466a-8889-e7db8fd8f4".
Can you please let me know any solution for this issue?
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.
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").
I think they up'ed the limit to 12 some time ago, but it has never been an issue for me as we rarely use any lookup columns in a list.
Yes, the default form in SharePoint will handle it fine, but a customized PowerApp form will only handle the 8 (or 12 as I believe you are correct) lookup columns in it.
Thanks for the reply @RandyHayes . I am creating custom form for adding a new record to a SharePoint list. It is working when adding new record with the default form. So, does that mean, if Power app has limitation of 8 lookups? I read in other posts that 12 is the limit.
Thanks,
Mahantesh
You can only have a max of 8 lookup columns in your list. This includes people columns.
I hope this is helpful for you.
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 (
