Answered

SharePoint Excel File to Network Drive

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am trying to get the excel file, which is saved on SharePoint and which gets modified/overwrite on daily basis. As the file size is big I am trying to get just two specific worksheets or specific columns (whichever is easier) from existing saved excel file (having already 5k+ rows data) on SharePoint to network drive -

Intent is to copy all existing data i.e. 5k+ rows which reflect or overwrite the changes in excel file on network drive if new data gets added to the excel file which is on SharePoint.

I searched that i can select the position of the worksheet also but struggling to understand fully.

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Verified answer

srduval 1,796 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Before you can work with excel in flow/power automate online, the data must be formatted as a dedicated table, it can't just be a spreadsheet with rows and columns filled in. Once you have a table, you can use a list rows in table action. to get the rows. However I don't believe there is a "new" rows or when a new row is added ability with excel. So you'll have to have some other unique identifier in the table if you want to filter for rows that don't exist in the other file.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, and if I just need to copy the excel file from SharePoint to network drive. How can I approach this?

Purely transfer the file as it is.

Under File System, which action should I select Create File?
srduval 1,796 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I believe you'll have to delete the file first. Create file might have a replace if existing but I don't recall off the top of my head