web
Youโ€™re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : F7HIz8AM5Aex4mf0Y1mDhe
Power Automate - Building Flows
Answered

Refresh data in excel

Like (0) ShareShare
ReportReport
Posted on 3 Feb 2024 14:53:27 by 165

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.

  • Verified answer
    New-AzGuru Profile Picture
    177 on 04 Feb 2024 at 12:17:26
    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

  • slvedva Profile Picture
    165 on 04 Feb 2024 at 07:25:35
    Re: Refresh data in excel

    Hi @New-AzGuru 

     

    Here:

    slvedva_0-1707031274305.png

    slvedva_1-1707031440536.png

    After this nothing happens.

  • New-AzGuru Profile Picture
    177 on 03 Feb 2024 at 19:15:29
    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:

    NewAzGuru_0-1706987421565.png

    NewAzGuru_1-1706987690519.png

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful forโ€ฆ

Paul Stork โ€“ Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Communityโ€ฆ

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete