cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LHole
Regular Visitor

Wait for file - wildcard?

Ì have a folder where XML-files with unknown name will be written to.
It would be perfect if you could add a "Wait for file" and set the path with a wildcard - e.g. C:\Temp\*.xml but this doesn't seem to work.

This would be in a while loop - and the flow would wait for a file to appear and then do certain operations.

I could use a "Get files in folder" in a loop with a for each - but that doesn't seem effective.

Is there any other way to solve this?

5 REPLIES 5
PierrePetrucci
New Member

+1 I also need to use the same in my organisation if someone know how to do it ...
Thks

fraenK
Super User
Super User

PAD has no local triggers. So you can only check the files in a folder within a loop and filter by new files with the extension xml. Or schedule the run through a cloud flow.

LucianoGomesBR
Frequent Visitor

Hi @LHole ,
I was looking for the same information but I did not find it.
So I created a manual checker as you can see below

LucianoGomesBR_0-1637953785641.png

Get files in folder allows you to use wildcard *.
I hope this helps.

Highboy
Responsive Resident
Responsive Resident

The wildcard option may have worked in versions prior to 2.14.
As of 2.14 the wildcard stopped working in file operations.
But Microsoft will have a new version ready mid-dec. that should fix all the 2.14 bugs. or so they say.

MichaelAnnis
Memorable Member
Memorable Member

How often do you plan to run this?  Like one user said, there is no trigger, you still have to start the process manually. 

if you could record somewhere the last time the bot was ran (ex. Environment variable or in Excel, etc), then you could say:

 

Get files (*.xml) in folder - sort by date last modified descending

for each file in files

if date last modified is before %lastrun% (the date/time of the last run)

     End flow

endif

‘Do something with file

End (for each)

 

this will process them in order of most current to least current and will stop on the file last modified before the last run. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,553)