refresh and save an excel spreadsheet on SharePoint online

(1) Share

Report

Posted on by jbrines

1,121

Hi All,

I have created the following flow to refresh a spreadsheet using Run Script but it isn't updating it, when I test it using the test option it work but the recurrence isn't saving it. What am I missing?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Craig Stewart ABZ 959 Super User 2024 Season 1 on at

Like (0)

Report

"the recurrence isn't saving it. What am I missing?"

Do you mean your recurrence isn't saving the settings you are configuring?
What is your recurrence schedule?

Was this reply helpful? Yes No
jbrines 1,121 on at

Like (1)

Report

Hi @Craig Stewart ABZ ,

Sorry I meant that it seems to refresh the excel file but the refresh isn't updating and saving the excel file.

It still shows the modified date was a few days ago.

Was this reply helpful? Yes No
Tomac 3,966 Moderator on at

Like (0)

Report

@jbrines Do you see the successful runs listed in your flow details page?

If you click on one of the timestamps that says Succeeded (not test succeeded) and expand the Run Script action, does it say in the Outputs that the script was successful?

Was this reply helpful? Yes No
Suggested answer

jbrines 1,121 on at

Like (1)

Report

Hi @Tomac

Yes.

Was this reply helpful? Yes No
Verified answer

Tomac 3,966 Moderator on at

Like (0)

Report

@jbrines

Thanks for coming back so quickly with that. It looks like your flow is operating correctly, so the issue will be with the script. You can find the correct forum for Office Script questions here.

1 people found this reply helpful.

Was this reply helpful? Yes No
jbrines 1,121 on at

Like (0)

Report

Hi @Tomac the thing is is that if I run the script with excel open it work, if I run the flow in test mode it works. It only doesn't work when it is scheduled to run.

Was this reply helpful? Yes No
Tomac 3,966 Moderator on at

Like (0)

Report

@jbrines Does a user have this excel file open during the scheduled run time? If so, Power Automate won't be able to lock the file for editing and the script won't be able to make changes.

1 people found this reply helpful.

Was this reply helpful? Yes No
jbrines 1,121 on at

Like (0)

Report

Hi @Tomac ,

No one has open when I am currently testing it

Was this reply helpful? Yes No