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 ?
Look out for new contribution recognition badges coming SOON!
Join us for the first ever Power Platform Online Conference!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!