Update a SharePoint Excel Spreadsheet when a SharePoint List is updated

[kaylee]

Hello,

I am looking to see if what I want to accomplish is possible to do through Power Automate. I have explained what I want below:

I have an Excel Spreadsheet inside SharePoint with specific clients on it (not all clients) based on deadlines some have. I have a SharePoint List with all of our clients on it. 

What I am looking for is if a client's email is updated in the Client List, I would like power automate to look at the spreadsheet and update the client email there aswell. As mentioned above, the spreadsheet only lists some clients, not all of our clients like the sharepoint list does. Would Power Automate be able to check the contact list against the spreadsheet and be able to tell if it's a client on both the spreadsheet and the list and update it?

Thanks in advance

[v-chengfen-msft · Accepted solution]

Hi @kaylee ,

I made a template for your reference

Here is sharepoint list:

Here is excel

Here is flow:

Triggered when you modify the list

Then compare with excel

If there is, the length of value >, and finally update excel

Here is result:

Best Regards

Cheng Feng

[kaylee]

This worked!! Thank you so much!!! I have one other question. I have multiple tables in the excel spreadsheet that I need the contact list to check against. How do I make it check all tables? The way it is set now from above is it will only check the 1 table that we told it to check but if the client is on a different table in the spreadsheet I want to make sure it doesn't get missed.

[v-chengfen-msft · Accepted solution]

Hi @kaylee ,

I made a template for your reference:

[Get tables] ：Get all tables in excel

[Apply to each] traverse [Get tables]

Dynamically enter the table name, and then retrieve the corresponding value

The same way: dynamically fill in the table name, and then update

Here is a link on how to dynamically update for your reference：

Solved: PROVIDE ITEM PROPERTIES IN EXCEL ONLINE - Power Platform Community (microsoft.com)

Best Regards

Cheng Feng

[kaylee]

Thank you so much!! This is exactly what I needed!