Hi all.
I am working a spreadhseet that needs to automatically updated each morning with no manual intervention.
Through resarch (the al mighty google) I have found a power automate process. It says it runs sucsessfully but the actual spreadsheet does not update. I am wondering if it is because the script it is using has no save function?
I am using the below script which is being called by power automate.
Any Ideas?
I am working a spreadhseet that needs to automatically updated each morning with no manual intervention.
Through resarch (the al mighty google) I have found a power automate process. It says it runs sucsessfully but the actual spreadsheet does not update. I am wondering if it is because the script it is using has no save function?
I am using the below script which is being called by power automate.
Code:
function main(workbook: ExcelScript.Workbook) {
// Refresh all data connections
workbook.refreshAllDataConnections();
}
Any Ideas?