Unanswered

PAD updating Excel file with Data Refresh All including Power Query items.

(0) Share

Report

Posted on by mdfreeman

What is the right way to have Power Automate Desktop "End" after it has done the expected steps?
I have PAD opening an Excel file on SharePoint and starting a macro.

The macro is running successfully but it takes time to complete.

After that PAD doesn't need to do anything more.

I would like PAD to recognize it's work is done and not have to set a WAIT time.

There appear to be no way for PAD to recognized when the macro has been completed (and/or the data refresh has completed.

Flow:

Macro in Excel

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,255 Moderator on at

Like (1)

Report
Copy link

Link copied!
@mdfreeman

I believe it's getting failed during execution of macro function.
Try to use below highlighted toggle enabled while you launch you excel and execute the macro action.

And another workaround is , As @Agnius mentioned in the below post

Use Launch Excel making the instance visible, and then use Press button in window or Click UI element in window to click on the Enable button in Excel to enable macros.
Use scripting (Run PowerShell script or Run VBscript) to run Excel with macros enabled (passing that as the parameter of the script) and then use Attach to running Excel to attach to it.
Excel Macros will not run when opened with PAD onl... - Power Platform Community (microsoft.com)

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
mdfreeman 13 on at

Like (1)

Report
Copy link

Link copied!

Thank you for the suggestion.

The macro was completing but I believe that PAD was timing out since it could not recognize if the macro was still running.

Solutions:
Made a few changes to both PAD flow and the macro in Excel.
I added the "Automation - Wait for Image" step based on suggestion by @Benny_1857 in this thread Solved: Re: Using Power Automate Desktop to refresh Excel ... - Power Platform Community (microsoft.com)

The two to other waits are to give Excel a change to get the macro moving.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,255 Moderator on at

Like (0)

Report
Copy link

Link copied!

@mdfreeman

Thank you for sharing your insights and tips on how you're addressing your reported issues. Please mark your above answer as the solution for this topic.

Was this reply helpful? Yes No