Skip to main content

Notifications

Power Automate - General Discussion
Answered

Getting data from an excell file after update row senteces

(0) ShareShare
ReportReport
Posted on by 4

Hi,


I am working on a flow that extracts data from a Power Bi dataset and fills an Excel tempalte file with statements of the "update row" type. Up to this point everything works fine. When I open the excel file the new data seems to be loaded into the tables.
The excel template also has a graph that depends on the updated tables and the graph can also be displayed correctly.
The problem comes when I try to execute a "run script" statement on Excel to create a PNG image that contains the graph (as explained by the youtuber Excell Off The Grid" in his video "Email or save Excel images with Power Automate | Excel Off The Grid. The PNG image created corresponds to the data before doing the "update row" sentences.


How can I force a data refresh before using "run script"?

 

Thanks, in advance.

  • jomarte Profile Picture
    jomarte 4 on at
    Re: Getting data from an excell file after update row senteces

    Thankyo very much Manish for your response.

     

    "Delay" action solves de problem.

     

    In my case, I have to process several files in an "apply each" loop, which means having to save several variables, etc.
    Instead I have chosen to make two separate flows. In one I create the new Excel tables and in another I generate the images.

    That's how it works perfectly.

  • Verified answer
    ManishSolanki Profile Picture
    ManishSolanki 15,075 on at
    Re: Getting data from an excell file after update row senteces

    Hi @jomarte 

     

    Using "Delay" action, pls pause the flow execution for 10 mins after "Update a row" action to wait for pushing the updates in the excel file.

    ManishSolanki_0-1694419891323.png

    After delay action you can execute the office script.

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard