If you have ever tried updating a SharePoint list via MS Flow that contains more than 12 lookup fields (these include people picker and workflow status fields) then you will have run in to the error message below:

The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold enforced by the administrator.

This can be extremely frustrating when you need to apply an update to a list item in part of your Flow but it just won’t work! So what can you do to fix this?

Read on to find out

As we mentioned above this error occurs because there is an inherit limit on querying trables that have more than 12 lookup columns (4 default like modified by and created by fields and 8 custom fields), so to skirt around this issue we can use a little hack that sends the data requ