refresh and save an excel spreadsheet on SharePoint online

(1) Share

Report

Posted on by jbrines

1,151

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)

Sort by

Craig Stewart ABZ 959 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

"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,151 on at

Like (1)

Report
Copy link

Link copied!

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 4,140 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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,151 on at

Like (1)

Report
Copy link

Link copied!

Hi @Tomac

Yes.

Was this reply helpful? Yes No
Verified answer

Tomac 4,140 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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,151 on at

Like (0)

Report
Copy link

Link copied!

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 4,140 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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,151 on at

Like (0)

Report
Copy link

Link copied!

Hi @Tomac ,

No one has open when I am currently testing it

Was this reply helpful? Yes No