Unanswered

Refreshing a SharePoint excel file with power automate

(2) Share

Report

Posted on by mayankgoyal

Hi, We have a SharePoint excel file in which some new data goes each day in Sheet1. In Sheet2 of same file, we have a pivot which I want to refresh.

Is there a way to automate 'Refresh all' with Power Automate on excel placed in a SharePoint folder.

If not power automate any other idea to refresh the pivot so it starts reflecting the updated data. Data in sheet1 is present as Table so we are good with reference data range of Pivot as rows increases.

Categories:

General topics

I have the same question (2)

All responses (3)

Answers (0)

Sort by

Gopala_Krishna 1,495 on at

Like
a
(0)

Report
Copy link

Link copied!

@mayankgoyal

Unfortunately, as far as I know there is no such feature available in Power Automate that can enable you to do this task. But can try configuring auto refresh directly from the excel file in many different ways.

Here's a link to the document that explains more - https://www.techrepublic.com/article/4-tips-for-refreshing-excel-pivottable-objects/

You can also upvote the idea for adding an auto refresh option for excel files from Power automate here - https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Add-in-Excel-Flow-the-ability-to-refresh-all-pivottables-and/idi-p/392897/page/2

------------------------------------------------------------------------------------------------------------------------------

If the information shared helps you, please consider giving a thumbs up and mark solution as resolved

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mayankgoyal

Consider writing an OfficeScript within excel online and then calling it from Power Automate
https://docs.microsoft.com/en-us/office/dev/scripts/tutorials/excel-power-automate-trigger
You wont need all of the code from the above link.

Recording capabilities of Office Scripts are shown here.

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mayankgoyal
While you take a look at the two links in my post above, I found a post that has an OfficeScript to refresh all pivot tables.
Check the post from @paulburnett224 that has 6 points here.
The code is in point #4.

Was this reply helpful? Yes No