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 ...
- 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.
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/12211
https://powerusers.microsoft.com/t5/General-Discussion/SharePoint-too-many-lookup-columns-cause-query-failure-PowerApps/td-p/12211
Thanks, 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.Thanks - I may have reached the end of the possibilities. I've searched high and low to try to find the similar feature as in flow to choose a view to avoid hitting the limit, but I'm coming up blank. Can't select a view and can't use a view in the URL.
My hope, is that since this is in flow, it will come to PowerApps for editing SharePoint list forms. Seems like a big miss without it.