cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ling
Level: Powered On

Update Sharepoint list with excel data - how to specify field to compare

I'm trying to create a flow that updates SP list when my Excel file is updated.

Some list item detail are added directly in SP by colleagues, so I can't just delete all items and create them again.

 

There is a column "RowID" that identifies unique record in Excel, which is also in SP.

 

The logic is simple :

 

MyFlow.jpg

 

For the Updating bit, I followed instruction from this thread, but I might be missing a step, because the flow took a long time to execute, and even though data is updated correctly in the end, the flow results in a fail.

 

The part I'm not sure is how to tell flow to compare RowID in SP list and Excel.

 

Thanks in advance.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,457)