Network error when using Patch function: The requested operation is invalid.

(0) Share

Report

Posted on by RS-15041344-0

"Hi,

This is not a regular patch function error as this flow was working up until today and it has since ceased to function correctly. No changes have been made to the settings of the flow and when looking at the flow diagram I see this error:

The query cannot be completed because the number of lookup columns it contains exceeds the lookup column threshold.
clientRequestId: e7479963-89d8-4be1-b478-e6f9bd978d26
serviceRequestId: 44390aa2-0002-0001-b2dd-9fed9e68a3f1

This comes under the heading of "Action 'update_id_pending' failed"

There is only one input to this flow where it fails and it is looking at a sharepoint site

Update - if it helps

Will an app show these errors if it is no longer associated with its flow? Does the flow need to be associated with an app to work? - Yes it does and it didn't work

Categories:

Error handling

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Sunil Kumar Pashikanti 1,628 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @RS-15041344-0,

If a previously working Power Apps Patch or Flow suddenly starts failing with a generic “Network error”, and you haven’t changed any code, the issue is almost certainly a SharePoint lookup column threshold.

What’s happening
SharePoint Online has a hard limit of 12 lookup‑type columns per update/query. Lookup‑type columns include:

Lookup columns
Person or Group columns
Managed Metadata
Calculated columns that reference any of the above

Even if your app or flow updates only a text field, SharePoint evaluates all lookup‑type columns on the list. If the total exceeds 12, the update fails with:

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

Why it worked before
Someone likely added a new Lookup or Person column, or modified a calculated column. No app or flow changes are required for this error to suddenly appear.
How to fix it

Audit the SharePoint list and count lookup‑type columns

Reduce the total to 12 or fewer, or

Split data into related lists / replace unnecessary lookups with text

What won’t fix it

Rewriting the Patch

Reconnecting the Flow

Refreshing the data source

Adding indexes (indexes only affect the 5,000‑item limit)

Bottom line
This is a SharePoint schema limitation, not a Power Apps or Flow bug. If a Patch suddenly breaks without code changes, always check the list’s lookup columns first.

https://benprins.net/2019/01/15/flow-working-around-the-lookup-column-threshold/

https://support.microsoft.com/en-us/office/working-with-the-list-view-threshold-limit-for-all-versions-of-sharepoint-4a40bbdc-c5f8-4bbd-b9b6-745daf71c132

https://community.powerplatform.com/forums/thread/details/?threadid=f32af1fe-5d8c-4d80-ac39-3c901653d741

✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,753 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @RS-15041344-0

Can you please share me your current query ?

Was this reply helpful? Yes No