how to set new file name when continuously download multiple files from website?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

when click download button on the website, a window will pump up to set the file name and save location,

Does any one know how to set a file name using the name of ' current item' in a For each loop to save a renamed file?

(the screen shot below is a attempt by me but it does not work...)

Thanks in advance!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

did you meant you want to extract the file name from dialog box and use that in file path right ?

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

What is %CurrentItem%? Is it a path, or a folder?

Just remember, you can navigate to folders vua that SendKeys item. So, whatever folder you want to save it in put in %Folder%{Enter} and then do another send keys for %Name%,ext{Enter} and that should do it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Sorry for confusion, I have two problems here. First, My currentitem is an ID（loop for an ID list），but i want use the ID＇s name for file name when download.
For example, using name of ABC company.csv instead of 100254785.csv.
I have a list containing ID column and their actual supplier name in another column, but I do not know how to match ID（my currentitem in the loop）to supperlier name and then use supplier name as my download file name.

My second problem is I do not know how to change name when download file from web site...

Was this reply helpful? Yes No
L10 6 on at

Like (0)

Report
Copy link

Link copied!

Hi, could you open up the "Populate text field in window" action and send a screenshot please?

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

So, there is no "lookup" command native to PAD. What I recommend is putting your datatable (col A = ID, col B = Name) in Excel.

Input Cell = D1

Formula in E1: =VLOOKUP(D1,$A:$B,2,FALSE)

Bot does this:

Attach to Excel

Write %CurrentItem% to D1
Read as Text from E1 to %BusinessName%
Rename File [old filepath and old filename] to [new filename with %BusinessName% wherever it needs to be.

Good luck!

Was this reply helpful? Yes No