Power Platform Community Forum Thread Details

I am trying to grab values (total number of members) from a Dynamics Real Time Segment

I have an Excel spreadsheet with a link to the Datverse table

I have a Type Script that updates the data connection, finds the values I want and copies them to another table.

All of this works fine if I run the script from within the app.

I have a flow that runs the script.

If I run the script from the flow, the script runs fine, no errors. All the other steps in the script work as expected.

But the refresh statement doesn't do anything.

Any suggestions? Thank you for your help. Guy

Categories:

Building flows

Hi @Guy Boswell,

Please check the following:

Troubleshoot Office Scripts running in Power Automate - Office Scripts | Microsoft Learn

Refresh not fully supported in Power Automate

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.