Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
Hi , still happening in November 2025, any news?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Dear all,
I have an excel sheet with an active connection which I am able to refresh to get the newest data.
Now I've got another PowerAutomate Flow which is working fine with a script inside this Sheet to send me via Teams numbers which I want to be notified about.
Unfortunately it only works if I am updating the workbook manually via Data-Refresh all, or if I am executing the script inside The workbook via automate this code line works:
"workbook.refreshAllDataConnections();"
It is now also possible to test the flow in Powerautomate and get all data (without the refresh code line).
With the refresh Code line I get this error message:
We were unable to run the script. Please try again.
Runtime error: Line 7: Workbook.refreshAllDataConnections() is not supported in Power Automate.
clientRequestId: 0b8eaf2a-1429-430a-8ae6-21fcf4330213
How can I refresh the workbook via Power Automate?
Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi , still happening in November 2025, any news?
Can anyone comment whether this issue persists still in Nov 2026?