cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Magpie_Rob
Frequent Visitor

Move specific files that have been downloaded

Hi I'm in the process of building a flow that downloads multiple files from and web portal (the portal doesn't have an API), for the most part, the flow works fine, but I'm trying to refine it. 

there are a couple of steps in the flow, 1 is to click download on each file and then the file appears in the computer's c:\Downloads from then I'm using get files in a folder and move to a SharePoint. 

 

I'm trying to extract the file names from the portal and only select those files from the download folder. but this is throwing an error. I have a screenshot of what the filenames is returning. 

Magpie_Rob_0-1628077009713.png

 

after reading the hints in the get files from folder step it says I need to separate the files by semicolon, 

Magpie_Rob_1-1628077171667.png

 

Not sure if this is something I can do or if anyone has any suggestions it would be greatly appreciated! 

Thanks 

Rob

 

1 ACCEPTED SOLUTION

Accepted Solutions
tkuehara
Solution Specialist
Solution Specialist

Hi @Magpie_Rob 

 

You could try the following:

  1. Retrieve data table column into list
  2. Join text

tkuehara_0-1628088354061.pngtkuehara_1-1628088379970.pngtkuehara_2-1628088404668.png

 

View solution in original post

5 REPLIES 5
tkuehara
Solution Specialist
Solution Specialist

Hi @Magpie_Rob 

 

You could try the following:

  1. Retrieve data table column into list
  2. Join text

tkuehara_0-1628088354061.pngtkuehara_1-1628088379970.pngtkuehara_2-1628088404668.png

 

MichaelAnnis
Super User
Super User

This might seem cumbersome, but I believe the "File Filter" parameter can only be 1 expression without listing out all the Filename[#s] separately with semicolons inbetween.

 

Instead, I would do a Loop from %LoopIndex% 0 to %JSResult% increment of 1:

In the loop, you could say Get Files -> File Filter: %Filename[%LoopIndex%]% to %File%

Then, also in the loop; use "Add item to List" and Add %File% to %Files%

 

Best of luck.

 

Hi @tkuehara, thanks for getting back to me! did you notice your JS scrip in the screenshot 🙈

 

thanks for all your help this worked a treat! 

 

Kudos and accepted as solution incoming! 

Hi @MichaelAnnis thanks for getting back to me! I did wonder if it was possible, lucky for me tkuehara's method worked! turns out your File Filter parameter can read from a list! 

Thanks 

Rob
 

Hahahaa I didn't lol

 

Happy to help and thanks for kudos & solution!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,242)