You’re offline. This is a read only version of the page.
Announcements
9
Dear all,
A- Target
The goal is to trigger an office script using power automate to refresh a querry in excel.
B- Component
1- We have an excel file that can be sourced from another excel file with Power Query
2 - We have an Office script that updates the querry
3- We have created a power automate flow that launches the script
C- Problem
When I execute the script manually, everything works correctly.
But when I run it with Power Automate nothing happens. The data doesn't refresh. (The flow is a success)
I tried with the excel workbook open and with the workbook closed.
I'm posting this here to thank you for taking the time to understand my problem.
If you think you can help me please don't hesitate.
Have a great day,
Best Regards,
Hi @Lonelyx ,
It looks like this is a limitation from Power Automate. According to the Official Docs, it is not possible to refresh most part of the data sources with Office Scripts via Power Automate:
Let me know if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/
Share
Report
All responses (
Answers (
