Unanswered

Use Power Automate to refresh connections in Excel file stored in SharePoint

(0) Share

Report

Posted on by martatracik

297

Hi.
I hope that somebody is able to assist me with this.
I`m trying to find out if it`s possible to use Power Automate to "Automate" a refresh of connections in an Excel online file.
I am using Power Query to refresh data, i would like to write a code to refresh the data in the Excel document without having to open the document and manually hitting the Refresh All button.
Is there a way of doing this?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

srduval 1,796 Moderator on at

Like (0)

Report
Copy link

Link copied!

Not directly with power automate, but you might be able to find an office script function (the new macro) that can do this, then have power automate run that office script.

Was this reply helpful? Yes No
martatracik 297 on at

Like (0)

Report
Copy link

Link copied!

is office script complicated? i have never used it

Was this reply helpful? Yes No
srduval 1,796 Moderator on at

Like (0)

Report
Copy link

Link copied!

I've only used it once from something I pulled off a blog post. I haven't really searched for any learning resources for it yet to understand it. It's different language and syntax than the old macro VBA code.

Was this reply helpful? Yes No