cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rfla
Kudo Kingpin
Kudo Kingpin

SharePoint too many lookup columns cause query failure PowerApps

Hi, I understand that the below link is related to flow. I am having a similar issue for PowerApps when connection to a SP online list.

 

https://powerusers.microsoft.com/t5/Community-Feedback/SharePoint-too-many-lookup-columns-cause-quer...

 

@carlosag replied in that tread this:

 

Based on the information here:
By default the limit is 8 lookups per list.  As you have seen this limit does not apply to farm admins.  You can change the limit for other users in the Resource Throttling settings of the web application in Central Administration.  But making changes to the resource limit can seriously impact performance.

Now I am wondering if the suggestion above also is related to SP Online?

14 REPLIES 14
Anonymous
Not applicable

Yes, my next intuitive line of thinking was to create a backdoor Odata connection into CDS using their new Custom Entity options. However, running into problems there as well- I'm currently interfacing with the development team so hopefully I can gain some traction there.

OstingButikol
New Member

And where's the solution? Of course the above is not a solution. 

I agree. There is still no solution for this lookup column threshold issue. The objective of SharePoint is to manage data using the 'one point of truch' approach. Many people that use SharePoint have BIG lists, with MANY lookups, and have also historically used SPD. This approach means having to rebuild all the lists and convert all workflows to Microsft Flow to enable use of PowerApps. This does not seem feasable at all! I dont think MS is listening to the user base here. There are so many complaints about this issue.

Complex column types

by default the 

Created, CreatedBy

Modified, ModifiedBy 

count toward the total.

 

Dates, Choice, Boolean etc

Anything that has multiple data values for a single record

i.e

Person{DisplayName, Emai)l

ITem{Title, Discription}

Choice{Choice1,Choice2,Choice3}

 

Note that Flow now has a View limter which is good.

Himanshu_2909
New Member

Hi Everyone, 

 

This solution does not work for Sharepoint online. Can we make similar changes in sharepoint online ? 

If yes then please share a guide. 

 


@Rfla wrote:

Hi, I understand that the below link is related to flow. I am having a similar issue for PowerApps when connection to a SP online list.

 

https://powerusers.microsoft.com/t5/Community-Feedback/SharePoint-too-many-lookup-columns-cause-quer...

 

@carlosag replied in that tread this:

 

Based on the information here:
By default the limit is 8 lookups per list.  As you have seen this limit does not apply to farm admins.  You can change the limit for other users in the Resource Throttling settings of the web application in Central Administration.  But making changes to the resource limit can seriously impact performance.

Now I am wondering if the suggestion above also is related to SP Online?


 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,500)