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
Super User
Super User

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
Super User
Super User

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 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 (3,394)