Announcements
Hi @Anonymous,
Could you please share mode details about the error message within your app?
How many Lookup columns created within your SP list?
The user @Rfla has faced same issue with you, please check the response within the following thread:
https://powerusers.microsoft.com/t5/General-Discussion/SharePoint-too-many-lookup-columns-cause-query-failure-PowerApps/td-p/12211
There is a threshold limit in the amount of the Lookup columns within SP list, the Lookup columns threshold within SP list is 12 currently.
Note: The List view Lookup Threshold has been revised to Default of 12 in SharePoint 2013 , after applying the June 2013 CU update . http://support.microsoft.com/kb/2817414
If the amount of Lookup columns that you want to use within your app is more than 12, the error would show up.
More details about the SP list Lookup column threshold, please check the following blog:
https://blogs.msdn.microsoft.com/spses/2013/12/02/sharepoint-20102013-list-view-lookup-threshold-uncovered/
Best regards,
Kris
thanks you i knew there are issues with too many lookup, i just need to find a solution 🙂
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 395 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 260 Most Valuable Professional
