cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
victor_lion
Helper II
Helper II

Updating rows in excel table

Hello everybody! How can I update several rows with the same content that I was searching? 

 

I tried using ODATA to filter only the rows I want 

victor_lion_0-1644524520108.png

And then I have an Apply to Each

victor_lion_1-1644524558604.png

But it only updates the first row, do you guys have an idea on how to solve it?

 

Also worth mention that if I don't have an ODATA filter the flow updates every row on the table.

1 REPLY 1
DamoBird365
Microsoft
Microsoft

Hi @victor_lion 

 

Update a row requires that that key value is unque.  I suspect you are using the same key value and this is why only the first instance updates.  Try adding a unique ID into your table and supply that from your list rows.  Alternatively, you can create an office script to perform your requirements.

 

I've a few office script demos on my YT.

 

Please consider accepting my answer as a solution if it helps to solve your problem.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,417)