Move specific files that have been downloaded

[Magpie_Rob]

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. 

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

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

Thanks 

Rob

[tkuehara · Accepted solution]

Hi @Magpie_Rob 

You could try the following:

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

[MichaelAnnis]

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.

[Magpie_Rob]

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! 

[Magpie_Rob]

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
 

[tkuehara]

Hahahaa I didn't lol

Happy to help and thanks for kudos & solution!