Power Platform Community Forum Thread Details

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.

Categories:

Using connectors