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.
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.
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