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

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
Level 10

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

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
Level 10

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

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

Kamacete
Level: Powered On

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

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

v-zhos-msft
Level 10

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

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users Online
Currently online: 154 members 5,322 guests
Please welcome our newest community members: