Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Error: Bad gateway - number of lookup columns it contains exceeds the lookup column threshold



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 ?




Community Support
Community Support



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:


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yamao-msft


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:'5a9d976f-dae9-4f25-b7ef-b239e3e8072e')/it...

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 "




  "error": {
    "code": 502,
    "source": "",
    "clientRequestId": "07afc03e-9ca3-4bff-94a7-02e7a5855b2e",
    "message": "BadGateway",
    "innerError": {
      "status": 502,
      "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: ,
      "source": "../_api/SP.APIHubConnector.GetNewListItems",
      "errors": [

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 ?

Helpful resources

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (7,560)