Unanswered

Flow to Refresh OneDrive excel file

(0) Share

Report

Posted on by mohashinBhyian

I want to create a power automate Web (not desktop version) for the below steps. Please help.

1. What I did: I am following the below Flow to download an excel file from the link of the mail body and save it into my OneDrive.

2. What I Need: Now this downloaded excel file is linked with Power Query of an excel file. I want to refresh this power query/excel file. How can I refresh this excel file of oneDrive?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Unknown geen idee 1,757 on at

Like (0)

Report

Dear mohashinBhyian,

To execute activities within excel, can I suggest you look in 'office scripts'?
These scripts execute within Excel, making use of excel-functionality, but can be called from Power Automate.
More information:
https://learn.microsoft.com/en-us/office/dev/scripts/develop/power-automate-integration
https://www.youtube.com/watch?v=p26sL3qHmfs

Happy flowing,
Koen

Was this reply helpful? Yes No
mohashinBhyian 90 on at

Like (0)

Report

@Koen5 Thanks. I can run the office script. But I think to refresh excel file, Code will not work. I am using below script. But not working. Please advise if you have any other option to refresh power query connection.

Was this reply helpful? Yes No