400 Error: The query cannot be completed because the number of lookup columns it contains exceeds

[DarenD]

I'm currently working on a recurring notice for a large application and I've run into the following error message when trying to run the FLOW:

{

  "status": 400,

  "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: xxxxxx\r\nserviceRequestId: xxxxx"

}

Is there a way to either change the setting (unlikely as its O365) or filter the GetData to only pull specific fields?  Or heck, any other way to make this work? 🙂

[Charles_John · Accepted solution]

Hi @DarenD,

Have you expanded the advanced setting of the Sharepoint get rows Action? You can specify a view to only return a limited number of columns.

If a view doesn't exist, go to Sharepoint and create a custom view with only the columns you need.

[DarenD · Accepted solution]

Thanks @Charles_John that worked like a charm!  I just didn't know that option was available!

D