Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

SharePoint Online with too many lookup columns cause query to fail


I have SharePoint Online list where I have over 18 Lookup columns and some columns bring additional columns from lookup list. After adding those lookup columns, my powerApp started failing due to the number of lookup columns. I understand that SharePoint online has a limitiation of 12 Lookup columns.

Is it possible in PowerApps to eliminate to query those lookup columns? My app does not use all the lookup columns of the list but I still need those columns for business logic in the SharePoint list.


Please let me know.

Community Support
Community Support

Re: SharePoint Online with too many lookup columns cause query to fail

Hi Daleritf,


I have seen two similar threads about this issue, please refer to the threads for more details:


It seems that it is not possible to query the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!


Community Highlights

Check out whats happening in Power Apps


Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,804)