Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
Can anyone comment whether this issue persists still in Nov 2026?
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
Can anyone comment whether this issue persists still in Nov 2026?
Same issue happens again in 2025. Looking for solutions...It's was working fine before
but now workbook.refreshAllDataConnections() did not refresh at all.