I have a very simple flow that should send on a regular basis notifications to record owners in a sharepoint list. List with a lot of columns but few rows ...
I'm getting the error:
"The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator".
Knowing that I can not delete columns. Is there another way to get the flow working ?
How is your flow created? Are you using Filter query in your flow?
Per my research, it seems that by default the limit is 8 lookups per list.
Please check this thread at here:
I have reduced the flow to a simple Recurrence->Get items
I got the error
"message": "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.\r\nclientRequestId: ea84c772-f9ef-4067-9cfd-7b2a3db30177",
There is a filter on one status column "Program Status"
Note that the similar REST query on the same list doesn't returns error:
I have created simple flow , When item is created in list send me the email, But when item is created in the list, flow doesnt get triggerd , after digging i got error like "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column "
"message": "The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.\r\nclientRequestId: ,
Would be nice if the sharepoint get items allows to select only the fields required in the flow ... maybe a way to get rid of this error in the future ?
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!