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!
Solved! Go to Solution.
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!
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.