Error Message: "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"
Upon searching the above error message in this community forum you get about 5 posts for people looking for help on the topic. The solution options from those posts using Power Apps are disappointing where the best solution is to use another product, Power Automate, to build up a collection of SharePoint data to use. A helpful blog post, however this adds needless complexity.
How to Get Filtered Items from SharePoint List to PowerApps using Microsoft Flow
https://www.netwoven.com/2018/12/11/how-to-get-filtered-items-from-sharepoint-list-to-powerapps-using-microsoft-flow/
By Sukanta Saha
Upon searching the ideas forums, you will find no less than 4 posts asking for a fix which Power Automate has already developed; "Point at a SharePoint VIEW with less lookup columns"
Power App Idea Posts
View in PowerApps based on sharepoint list view 143
SharePoint list View as DataSource 8
Connect to SharePoint Views in PowerApps 58
Ability to Point a Gallery at a SharePoint View 0
Total Votes 209
@microsoft Can we not share this code across platforms and get a quick win?
