web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate PAD to refresh Power Q...

Power Automate

Answered

PAD to refresh Power Query (aka Data/RefreshAll) via Send Keys

(0) Share

Report

Report

Posted on by Brent Pearce

59

I have had limited success in using PAD to open an Excel file and perform a Data/RefreshAll function. It seems trivial, but has been problematic for me.

My current approach is to use PAD's "Click UI element" function to select "Data" from the Excel Ribbon, then "RefreshAll". For some reason, PAD cannot consistently do this. My flows can go for days just fine (100% success rate) then start failing (less than 50% success rate). After trying many "fixes" I am now looking for an alternative approach.

Instead I would like to try the hot-key for Data/RefreshAll which I understand to be <Ctrl><Alt><F5>. I believe the Send Key sequence should be coded as:

If you can't read the image, the Text to Send value is: {Control}({Alt}({F5}))

This Send Key sequence is ignored when the flow executes. I have tried both "hardware key" options.

I also tried recording a macro which determined the Text to Send value should be: {LControlKey}({LMenu}({F5}))

This was ignored also.

Appreciate any guidance.

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

FEDE1 2 on at

Like (0)

Report
Copy link

Link copied!

You can try adding a step that executes a macro in the workbook and you create this macro that refreshes all the data. To be able to do this, you will need to save the workbook as XLSM.

Sub RefrescarConsulta()
ActiveWorkbook.RefreshAll
End Sub

Was this reply helpful? Yes No
Verified answer

kinuasa 799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
I suggest to set the book path to a variable(%WorkbookPath%) in the "Set variable" action and execute the following code in the "Run VBScript" action.

GetObject("%WorkbookPath%").RefreshAll

Was this reply helpful? Yes No

Join the conversation