SharePoint Online with too many lookup columns cause query to fail

[daleritf]

Hi,

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.

[v-yamao-msft]

Hi Daleritf,

I have seen two similar threads about this issue, please refer to the threads for more details:
https://powerusers.microsoft.com/t5/PowerApps-Forum/SharePoint-too-many-lookup-columns-cause-query-f...
https://powerusers.microsoft.com/t5/Community-Feedback/SharePoint-too-many-lookup-columns-cause-quer...

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