cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stiabhna
Regular Visitor

Operate "Save As" dialog box with Power Automate Desktop

Hi everyone,

 

Please excuse my newbie question!
I'm attempting to use PAD to automate some steps in a web-based project management system we have.
In one of steps, I would like to select a list of projects and use the built-in button on the web interface to download the list to an Excel file.

The problem is that a Windows "Save As" dialog box then appears and I can't seem to select anything on it (for example, to enter a file name or click "Save".

 

Any help would be much appreciated.

 

Many thanks in advance and best wishes,
Stephen

12 REPLIES 12
Expiscornovus
Super User
Super User

Hi @Stiabhna,

 

I would use actions from the UI Automation category for this. You can probably use a Click UI element in window for this. Try and track the UI element and use it in that action.

https://docs.microsoft.com/en-gb/power-automate/desktop-flows/actions-reference/uiautomation#click

 

pad_window_actions.png

 

The problem is you cannot capture the UI element.

And therefore not click it.

I have the same problem in any other popup in Edge (Log-in forms fx)

Expiscornovus
Super User
Super User

Hi @lema7913,

 

It should be possible to find these UI elements with the Add UI element control. For example Window 'Open' in my earlier example is a file explorer dialog box. This can be found via this selector

 

 > window[Class="#32770"]

 

 

https://docs.microsoft.com/en-us/windows/win32/winmsg/about-window-classes#types-of-window-classes

 

 

lema7913
Advocate I
Advocate I

I agree - withe windows controls.
The problem is that it doesn't seem to work with Microsoft Edge

Expiscornovus
Super User
Super User

Hi @lema7913,

 

What is the selector of your group, where the UI element is listed under? In my example the group is using selector with a specific filter for msedge process:

 

:desktop > window[Process="msedge"]

 

 

Sometimes it helps to be more specific and add additional criteria like the name to the selector.

MichaelAnnis
Super User
Super User

Use focus window, use the select window feature once you have manually opened the save window dialog box. When the red square shows up around the right window hold Control + Left click to capture the window element. 

The file name field should already have the cursor in it. If not, you can populate text field (you have to capture the element using the same process as select window.  If the cursor is already there, just use send keys. Both should work.  For send keys:

 

send keys %filepath%
wait 1

send keys {Enter}
wait 1

send keys %filename%
wait 1

send keys {Enter}

Sending the file path and pressing enter will take you to the file path. 

lema7913
Advocate I
Advocate I

The problem starts earlyer. I can not capture the element.

To replicate the problem: Start Edge, Open Downloads (Ctrl+J), try to grab the elements in that list (I can capture the window itself, but not the elements)

> pane > pane > pane > pane > pane[Class="DialogClientView"] (the Downloads window in Edge)

The problem is that I need to go a step deeper to get the "Save as" button

KirilOkun
New Member

Hello,
did you ever find a solution for this.  I'm having the same problem.  UI element capture only highlights the container pane but not the "Save as" button in it.

lema7913
Advocate I
Advocate I

No. As a (temporary?) solution i had to go back to Internet Explorer 😞

I'm waiting for Microsoft to fix their shortcommings.

(If Microsoft Power Automate can't work with Microsoft Edge, then Microsoft has a problem they should focus on, and fix ASAP)

Very unfortunate.  
The strange thing was that i was able to capture the inner elements of the downloads popup a week ago.  (See below)  and my automation was working.  But yesterday I updated Edge to the latest version and it stopped working.   



---------------------
> pane[Class="Chrome_WidgetWin_1"] > pane[Class="RootView"][Name="Downloads"] > pane[Class="NonClientView"] > pane[Class="BubbleFrameView"] > pane[Class="DialogClientView"] > pane[Class="BubbleDialogDelegateView"] > document > list[Class="c0190"][Id="list-focus-container"]

KirilOkun
New Member

One more update.
Since previously i was able to capture the inner Recent Downloads list and the first Save As button as a UI element i was able to run the automation in Edge Version 97.0.1072.69.   And it worked sometimes, but not reliably.  Other times it would throw the "Could not find UI element"  error.    With this version of Edge PAD's UI element capture no longer works on the Recent Downloads popup and thus prevents any file saving automation.   I was forced to switch to Chrome, which does not have that intermediate dialog and opens the standard Save As dialog right away.  With only minor modifications it worked in Chrome.   So this is the solution for now.

Interestingly the same script ran much faster with Chrome than with Edge. 

It is rather unfortunate that MS felt in necessary to add more UI interaction to the standard file download use case in Edge. Since the user already must go to the browser settings to enable "Ask me for location"   setting for file downloads there's absolutely no value in having that extra popup that list recent downloads and requires me to click Save As one more time. The user already decided that they want to specify file destination on every download.   Less is more, as always. 


Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Top Solution Authors
Top Kudoed Authors
Users online (4,005)