Power Platform Community Forum Thread Details

Hi all,

I'm using Power Automate to run a workflow that opens an Excel workbook stored in OneDrive/SharePoint, executes a Power Query (to refresh data), and then runs an Office Script to perform some updates. The flow works as expected, but the changes seem to be kept in memory and are not saved to the actual file - meaning the workbook doesn't reflect the changes until someone manually opens the workbook.

Is there a reliable way to force the workbook to save changes after running Power Query and Office Script via Power Automate?

Thanks in advance!

Categories:

Using flows

Hi @AR-23050658-0

Can u try this office script ?

function main(workbook: ExcelScript.Workbook) {
// Access the active worksheet
const sheet = workbook.getActiveWorksheet();

// Define the target cell (e.g., cell A1)
const targetCell = sheet.getRange("A1");

// Write a value to the cell
targetCell.setValue("Temporary Data");

// Force a full calculation to ensure the change is registered
workbook.getApplication().calculate(ExcelScript.CalculationType.full);

// Clear the content of the cell
targetCell.clear(ExcelScript.ClearApplyTo.contents);
}

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!