Answered

Getting data from an excell file after update row senteces

(0) Share

Report

Posted on by jomarte

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.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Manish Solanki 15,109 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

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

Was this reply helpful? Yes No
jomarte 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No