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

Re: Refresh data in excel

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

Re: Refresh data in excel

Hi @New-AzGuru

Here:
After this nothing happens.

Was this reply helpful? Yes No
Verified answer

New-AzGuru 179 on at

Like (0)

Report

Re: Refresh data in excel

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