Unanswered

Update ALL rows including duplicates from Lists data

(0) Share

Report

Posted on by JB111

Hello everyone,

I made a simple flow that has worked great, it updates rows in excel where the ID matches a SharePoint ID(Sharepoint is master data only flows from sharepoint to excel).

Get items>For each>update a row. It's very simple but it works

There is a separate flow to compare the ID's and add any missing ones to excel on a schedule.

Well now I'd like to have duplicate rows in excel but the trouble I'm having is I can only get it to update the first unique ID it comes to and the rest(duplications) will be skipped. I'm manually entering the ID number for duplicates, I run the flow and it will update the first instance but none there after.

For example, lets say I have table rows with ID's 63,63,63,63,64. I want the all rows with ID of 63 to have duplicated data, what it is doing however is updating the first row of ID 63, skipping the rest and then it will update row ID 64 or any row there after which is not duplicated. It's indiscriminate to the order of the ID's it just won't handle duplicated ID's

It sounds simple in principle and hopefully it is as I've spent a lot of time and have been unable to get it to work, any advise would be greatly appreciated, thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

creativeopinion

10,502 Super User 2025 Season 2 on at

Like (0)

Report

@JB111 In order to update a row in Excel. The Update a Row action requires a unique ID. It needs to know which row (based on the ID) to update. You will need different column in your Excel table to store a unique ID. You can use a Filter Query or Filter Array action to find all rows that contain the ID 63, however, you will still need a unique identifier to update those rows.

In the meantime, you might find this YT Tutorial helpful: Are you using the Microsoft Power Automate Filter Array Action wrong?

In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.

1️⃣ Cross-Referencing Data

2️⃣ Filtering by Key

3️⃣ Substring Matching

Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

IN THIS VIDEO:

✅ 3 Ways to Use the Filter Array Action

✅ How to use the Scope Action to Group Actions

✅ How to Check the Number of Items returned from a Filter Array Action

✅ How to Cross-Reference Data in Excel with a SharePoint List

✅ How the Filter Array Action Works

✅ How to Access the Dynamic Content from a Filter Array Action

✅ How to Filter Items by a Key

✅ How to Filter Items by Matching a Substring

✅ How to Use Multiple Conditions in a Filter Array Action

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No

JB111 4 on at

Like (0)

Report

Hello, thank you for your reply. It was a great video you helped further my understanding more than anyone else has, I'll be sure to check out your other work.

Hasn't directly solved my problem, I made another 'sacrificial' column with the same dataset in, as it updates each row it overwrites the data with utcNow(). Kind of worked but was incredibly slow to update so still looking for an improved solution.

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@JB111 If you aren't setting any variables in the Apply to Each action, you can turn on the concurrency control in that action.

Was this reply helpful? Yes No
JB111 4 on at

Like (0)

Report

@creativeopinion Thank you, I've enabled concurrency control and dropped both 'Apply to each' loops (Excel loop inside SharePoint apply to each.) down to 1 concurrent.
The good news is It now works... somewhat. It updated the unique values fast as expected, the duplicates took a couple of minutes and then it just hung for another 10 so I manually stopped it. I'm guessing it's trying to loop back through the data which has been changed to utcNow() so it can't find any matches

Was this reply helpful? Yes No