Update Excel table on SharePoint Online

(0) Share

Report

Posted on by Rodrigue

Hello,

I'm trying to create a flow to automatically update an Excel table stored in a library on SharePoint Online.

-Trigger : a recurrence

- Step 1 : Selecting SharePoint / Update a file / Adress site : ok / Identification of the file : ok / Content of the file : ~~ok.~~ The flow ask a dynamic content or a connector. I don't know what it mean and what i can do?

Thanks for your help.

Best regards.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

v-micsh-msft on at

Like (1)

Report

Hi @Rodrigue,

If you use the SharePoint Update file action, it is only available to seperate the Excel file with the Name and the File content part.

Here the File content is the whole file body, there is no way to get the data inside Excel in details.

Could you please explain a bit for what data you would like to update with the Excel Table?

If you would like to sync the Excel file, then first we need to get the same Excel from other data source, for example, OneDrive folder, with the OneDrive Get file or Get files action, then there would be dynamic content for File content that could be used to update the SharePoint Excel file.

If you would like to Update Data within the Excel table, then we need to connect with Excel Connector, which then would offer you Update Row action, and that allows to operate in the Excel table level.

But there is a limitation when using the Excel Connector, the fiel location is limitted currenlty. It is not available to get the Excel file stored in SharePoint Library. The available data source here is listed as below:

So if you would like to Update Excel file stored in SharePoint Library, a workaround here is:

1. Create a copy of the Excel file and store it under OneDrive or other available data sources,

2. Create a flow to operate under the Excel connector, once the file has been updated, use OneDrive Get file Action to Update the file content of the Excel stored under SharePoint Library.

Hope the information above is helpful.

Adding the Excel connector template for reference:

Excel

Further, if you would like the Excel connector to add support of the SharePoint library, please submit this as an idea under Flow idea forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards,

Michael

Was this reply helpful? Yes No
Rodrigue 2 on at

Like (0)

Report

Hi Michael,

I was on holiday, sorry to reply only now.

I have a central Excel file within there is a table who's build with copy/special paste (paste link) from a lot of others tables (differtents Excel files) with numbers. I must manualy open this central Excel for the update with the new numbers who's coming from the others Excel files.

I understand well that i must change the locality to OneDrive and create a flow to transfer this file to SharePoint after the update.

I stay with a question about the dynamic content. Must i change the table 's property to become a dynamic content?

Thanks.

Rodrigue

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Did you ever get an answer to this issue? Currently I have to sync my file to onedrive then copy it to the local drive then use excelrefresh.exe through powershell, and then finally copy the file back to a onedrive folder.

If I can do it all within sharepoint or using flow that would be much prefered.

Was this reply helpful? Yes No