Forum Discussion
Solved
list column view threshold / SharePoint list Edit form
Is there a way in PowerApps, similar to flow, to select a SharePoint list view to avoid this 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
I've made it all the way through configuring a new list, adding flows and working out the list column view threshold deal there... and on to editing the new/view/edit forms... and now I can't pass go. I hope I'm missing something obvious?
- 1. What classifies as Lookup columns: Standard lookup columns, single-value managed metadata, multiple-value managed metadata, single-value people and group columns, and multiple-value people and group columns , Workflow Status , Created by , Modified by ( people ) are obviously counted as lookup columns .
2. Additionally following columns shows on list view also work as lookup columns , Name ( linked to Document) , Link (Edit to edit item) , Name ( linked to Document with edit menu), type ( icon linked to document)
I think if you limit your powerapp columns it pulls into the data source it might be a way past it, but it might just pull all the raw columns out, so I think number 2. might be irrelevant when it comes to powerapps.
4 Replies
- You are limited to 12 Lookup field types. SharePoint has 4 by default (created/by,mod/by columns). There are some basic field types that count as well. Check this article for more information, but seems to be a pretty hard limit. I like using SQL for my Powerapps, less restrictions :P.
https://powerusers.microsoft.com/t5/General-Discussion/SharePoint-too-many-lookup-columns-cause-query-failure-PowerApps/td-p/12211Thanks, ChrisWebbTech. Trying to find a definitive list of what counts as a lookup column... People/choice/managedMetaData/calculated?
- 1. What classifies as Lookup columns: Standard lookup columns, single-value managed metadata, multiple-value managed metadata, single-value people and group columns, and multiple-value people and group columns , Workflow Status , Created by , Modified by ( people ) are obviously counted as lookup columns .
2. Additionally following columns shows on list view also work as lookup columns , Name ( linked to Document) , Link (Edit to edit item) , Name ( linked to Document with edit menu), type ( icon linked to document)
I think if you limit your powerapp columns it pulls into the data source it might be a way past it, but it might just pull all the raw columns out, so I think number 2. might be irrelevant when it comes to powerapps.
