
Announcements
Hello
I'm trying to build a Canvas powerapp form for a list which has about 100 fields. Straightaway it throws validation the list contains exceed lookup column threshold. List has 10 date and 10 person fields.What would be best way to go about this I don't have CDS in my tenant.
Thanks
Naveen
Hi @Anonymous ,
Currently, I could not come up with other solution to resolve the Lookup column threshold Error in PowerApps.
If you want to fix this issue in PowerApps directly, I afraid that there is no way to achieve your needs, since it is a known limitation from SharePoint. Reference: https://docs.microsoft.com/en-us/archive/blogs/spses/sharepoint-20102013-list-view-lookup-threshold-uncovered
You could consider take a try to reduce the number of LookUp columns in your SP list, or replace the LookUp column with other columns (e.g. Choice, Single line of text, etc) to fix this issue.
Sik