cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kamacete
Helper IV
Helper IV

Update Excel in a LocalMachine with data from an Excel stored in a sharepoint

Hi,

I have an excel file stored in SharePoint when I put a lot of data during the day, and I have an excel file stored in a local machine where I update all the new info on the end of the day to be used by power BI. The excel I have in the local Machine have more than one sheet (information from different raw data).

 

Can I create a flow to validate one sheet on the Sharepoint Excel and update the correspondent sheet on the local machine excel?

 

thank you 

1 ACCEPTED SOLUTION

Accepted Solutions
v-zhos-msft
Solution Sage
Solution Sage

Hi @Kamacete ,

It seems you want to update the local machine excel from the SPO at the end of everyday.

As you have said, the local machine excel have more than one sheet.

However there is no action to select a specific sheet In flow.

So I am afraid you need to set the structure of the local machine excel file to correspond the file in the SHO.

I have made a test on my side, please take a try with the following workaround:

Here I use the File system connector to connect to the local machine.

Capture2.PNG

Before update:

Capture4.PNG

After update:

Capture3.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-zhos-msft
Solution Sage
Solution Sage

Hi @Kamacete ,

It seems you want to update the local machine excel from the SPO at the end of everyday.

As you have said, the local machine excel have more than one sheet.

However there is no action to select a specific sheet In flow.

So I am afraid you need to set the structure of the local machine excel file to correspond the file in the SHO.

I have made a test on my side, please take a try with the following workaround:

Here I use the File system connector to connect to the local machine.

Capture2.PNG

Before update:

Capture4.PNG

After update:

Capture3.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

First of all, thank you for your support.

 

I tried your suggestion and the field are totally updates (all sheets).

😞

 

can I select just a new content of a sheet to update?

 

e.g.:

 

Before the update:

image.png

 

At the time selected the flow, verify the source / sheet an update just the rows needed the other file (with just 1 sheet). for me it will work.

🙂

 

after update:

image.png

 

image.png

 

thank you again for your support

Hi @Kamacete ,

I am afraid there is no way to update a specific sheet via flow currently.

There is no action for you to select a specific sheet.

Tere is a similar idea you can vote with:

https://powerusers.microsoft.com/t5/Flow-Ideas/Triggers-for-Excel-Sheets/idi-p/78301?advanced=false&...

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,529)