
Office Scripts can't refresh most data when run in Power Automate. Most refresh methods, such as PivotTable.refresh, do nothing when called in a flow. Workbook.refreshAllDataConnections only refreshes when PowerBI is the source. Additionally, Power Automate doesn't trigger a data refresh for formulas that use workbook links.
The following methods do nothing in a script when called through Power Automate. They still return successfully and don't throw any errors.
| Class | Method |
|---|---|
| PivotTable | refresh |
| Workbook | refreshAllPivotTables |
| Worksheet | refreshAllPivotTables |
The following methods act differently in Power Automate flows than they do when run through Excel.