Power Automate

My flow fails to update a row, but after resubmit works fine usuallly

(0) Share

Report

Posted on by Flowss

Hello guys,

I couldn't find solution for my flow.

Basically what it does:

The flow runs daily(scheduled), retrieves records from a database, and processes them in a loop. For each item, it checks and updates related SharePoint list entries, then attempts to synchronize IDs between SharePoint and the database.

The flow consistently fails at the action:

Where I need to update a row and set id for SharePoint. the error is 400, specified item is not found. But the main thing is that usually it goes ok for 100-150 items. Then fails to update for 30-60 items. And goes ok until the end for rest 300-500 items.

I tried to put delay before update, also I tried to do Concurrency control to 1 for the apply to each.

Categories:

Building flows

Using connectors

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Based on what you describe, there are items in the database that are not in the SharePoint list. When the flow runs and the flow cannot find the matching item, it fails.

You could add a Get items action before the update item action. In the Get items action use a filter query to find the item you are about to update. Use a condition with a length() expression to determine how many items the Get items action found and that it is greater than or equal to 1. Then move the update item action to the yes side of the condition with nothing on the no side. This way the missing items will be skipped.

A better and more robust solution would be to use a tool such as Layer2 Cloud Connector. It is designed specifically for keeping data sources in sync with SharePoint. With that tool, it could either skip the missing items or delete them depending on how you configure the sync. See Layer2 Cloud Connector ► integrate and sync data for information on this tool.

Was this reply helpful? Yes No
Flowss 4 on at

Like
a
(0)

Report
Copy link

Link copied!

It doesn't find the table inside the database instead of items.

Error code is 400

Was this reply helpful? Yes No
Suggested answer

ninihen 153 on at

Like
a
(1)

Report
Copy link

Link copied!

Not sure if I read it correctly but if you loop every item in a single for each, that probably can be improved.

Assuming you are calling Update on items that don't exist in the SP list like @David_MA said, the failing items are likely DB records that should be Created in SP, not Updated.

So instead of loop DB records and update each, classify them first.

1. Get items from the DB (you already have it)
2. Get items from SP (all of them at once)
3. Build three arrays via Filter array:
a. Update = items present in both, where something changed
b. Delete = items in SP bit no longer in DB
c. Insert = items in DB but not yet in SP
4. 3 independent Apply to each loop, one per array. So if nothing changed, no need to loop & process.

Was this reply helpful? Yes No
Flowss 4 on at

Like
a
(0)

Report
Copy link

Link copied!

So basically:

1) I take data from database get rows.

2) I check if my some of my SharePoint lists have already that value or not.

3) And then I upload that SharePoint list ID to database items.

P.S this flow is not made by me, got it to service. So some things might be unclear.

My biggest guess is that the flow fails because of database connection loss.

Was this reply helpful? Yes No