When a row in an Excel sheet is changed, the specific row should be updated in a SharePoint list as well. How?

(0) Share

Report

Posted on by blinabj

159

Hi,

I have a flow that runs every time my Excel file is changed.

When the Excel table (stored in SharePoint) is changed I want to update a SharePoint list with only the rows that are changed. Is this possible?

I have a unique identifier on each row in both the list and in the Excel table called ID_Number if that helps.

So, lets say the Excel table looks like this:

And the SharePoint list like this:

And then, I add some information for ID 5 like this:

Then I want my SharePoint list to look like this:

I only want to change Tom's row in the SharePoint list.

Really appreciate the help!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

kgohar 41 on at

Like (0)

Report
Copy link

Link copied!

This tutorial might help you

https://www.youtube.com/watch?v=uEZI_b1Gs-k

Was this reply helpful? Yes No
Verified answer

Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @blinabj ,
I have crated Sample for you.
1. Use One When an item or a file is modified Action and Select Folder Where Your Excel File Present.

2. Then Use List rows present in a table Action and pass Identifer which return by trigger action and pass Table name manually.

Add Filter Query
Modified eq 'Yes'

3. Using one Apply to each then get column value as your requirement in my case name.
items('Apply_to_each')?['Name']

4. then Using one another apply to each update a row to of Modified Column select NO.

Complete Flow

Create One Extra Column in Excel File Name Modified You can use list data validation for this column for option yes and no then whenever you try to modify your column also select Modified Column NO for All of the Which of the rows you want to be modified.

-------------------------------------------------------------------------
If I have answered your question, please mark post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
blinabj 159 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much @Amit_Sharma !

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (1)

Report
Copy link

Link copied!

Here is a much more efficient template that allows you to trigger actions when something changes in an Excel table:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/When-an-Excel-row-is-created-modified-or-deleted/td-p/2264670

Was this reply helpful? Yes No