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 ?
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Explore the latest tools,training sessions,technical expertise, networking and more.