You’re offline. This is a read only version of the page.
Announcements
Hello,
We are working on Excel OfficeScript with Power automate flow. We need to refresh the Excel (.xlsx) OR (.Xlsm) file without opening the same. In this file, some online formulas are there. Hence, we have chosen OfficeScript. Now, if we are running the below Run script directly from Excel then it is working fine. However, if we are trying to refresh the file from Power Automate, it is not working. I have also put the power automate action to create another sheet in the same Excel file, which is working fine. So, assuming this could be an issue to run the refresh script only in Power automate action.
Please see the below image for further reference.
Can anyone help us to achieve the same via run script + Power automate? OR Is there any other way to either run the script from Power Automate OR altogether a different approach to achieve the file refresh functionality?
Any help would much be appreciated.
Hi,
Hehe trust me i've been there, but you did not share the flow (so we can see exactly what your doing) and you didn't share any error.
hehe there isn't much for me to do for you but if you share that stuff I'll happily help.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Share
Report
All responses (
Answers (
53,433
