Refresh data in excel

(0) Share

Report

Posted on by slvedva

176

Hi,

I created scheduled flow, which run excel script, in excel script I put refresh excel data (Ctrl+Alt+F5), but it's don't work 😞

I have excel file, which stored in SharePoint and I want, that power automate open this excel file and refresh all data, how to create this flow? I mean refresh the data with Ctrl+Alt+F5 or from excel Data tab -> Refresh All. When I run manually this process, refresh process take ~2-3 minutes.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

New-AzGuru 179 on at

Like (0)

Report
Copy link

Link copied!

Can you show us what your script looks like? Without seeing it, it's hard to determine what's wrong.

But this is how I would set mine up:

Was this reply helpful? Yes No
slvedva 176 on at

Like (0)

Report
Copy link

Link copied!

Hi @New-AzGuru

Here:
After this nothing happens.

Was this reply helpful? Yes No
Verified answer

New-AzGuru 179 on at

Like (0)

Report
Copy link

Link copied!

Well that looks correct so I did some digging and apparently this isn't fully supported yet. Sorry about that!

https://learn.microsoft.com/en-us/office/dev/scripts/testing/power-automate-troubleshooting#refresh-not-fully-supported-in-power-automate

Was this reply helpful? Yes No