Unanswered

Update SharePoint List when a change in Excel is made

(0) Share

Report

Posted on by SewNinja5

Good Afternoon,

I have written a flow to create the database (SharePoint list) uploading from and Excel file. The excel file is in a SharePoint location.

I am now wanting a flow to update the sharepoint list when changes are made in the excel table.

Unfortunatley this is not working. Also the below highlighted green row, is a number field and it is not showing any Dynamic content to map in to it.

Any help and guidance would be appreciated. I've tried many combinations and I am now going round in circles.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Srini007 3,471 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @SewNinja5,

Since your requirement is to update the SharePoint list whenever changes are made in the Excel file stored in SharePoint, you need to use an automated flow rather than a manual trigger. In an automated flow, you can choose the trigger "When a file is created or modified" in SharePoint. This will show for SharePoint, OneDrive, and other sources, but since your file is in SharePoint, you should select that option. This ensures that the flow will trigger every time the file is modified. Screenshot for your reference

Also, if the dynamic content is not appearing, could you provide more details about the issue? Typically, dynamic content should show up, so any additional information you can give will help in troubleshooting the problem.

(If you got your solution you can mark as solution and give it a Like)

Regards,

Srini

Was this reply helpful? Yes No
SewNinja5 14 on at

Like (0)

Report
Copy link

Link copied!

Thank you Srini. I have changed my flow to the below. It triggers correctly when i edit the the Excel. But it is not updating the SharePoint list.

In the below - Update Item, the column for Site is a Choice column in SharePoint and a Data Validation in the excel file. This is a common structure in the files.

Any advice on why it is not updating? As it it a choice column, do i need to initiatiate and set an variable for each choice column in excel?

Thank you! im a bit stuck.

Lynsey

Was this reply helpful? Yes No
Srini007 3,471 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @SewNinja5,

As you are passing variable to the choice column, then you need be more careful that the string you are passing exactly the same which the option you have in the choice column. you are passing through excel so there are high chances of having some white spaces, check that. To ensure you are passing correct option you can use Compose action and check the parameters you are passing.

(If you got your solution you can mark as solution and give it a Like)

Regards,

Srini

Was this reply helpful? Yes No