Only trigger flow if folder has files

[DavyNix]

Hi All,

Have written a flow which reads file names in a folder, adds them to a HTML table, which it embeds into a nicely formatted Email and then finally moves the files on to another folder.

Problem is, the flow runs when there are no files, sending a blank Email, which I know wont be an acceptable solution.

What can I add to the start of the flow so that the above only runs if the there are 1 or more files in the folder?  

P.s. the flow is triggered by a schedule.

Still very new to automate so all help appreciated.

Thanks - David.

[happyume]

Most likely you are listing files in a folder and then using Apply to Each to go through each file and get the filename.

Under such scenario (or if you have used a different method), all the files in a folder must be coming to you as an ARRAY.

You can use length(ARRAY_NAME) to get the number of files. At this point, use a Condition if length(ARRAY_NAME) > 0 then send email else don't send email

[DavyNix]

Hi there,

Thanks for your reply....

So the condition would sit between list filter and filter array?

Could you give me a clue as to how this might look?  The learning curve for me is understanding the syntax for the expressions.

Many Thanks...

[happyume · Accepted solution]

After your List Folder action, add a Condition, on the left part put expression:

length(outputs('List_folder')?['body'])

Your Filter Array and other actions for Sending Email will come under the Yes branch.

[DavyNix]

 @happyume  - Perfect!  Thanks 🙂

[DavyNix · Accepted solution]

For anybody reading this  - remember that you must also tell your flow not to count folders:

[DavyNix]

@happyume  - I may have spoken too early!  All working well except the flow now sends an Email for each file in the folder.  The reason for building this flow was so that one summary Email (summarising the contents of the folder) was sent per day.  Is it "Apply to each 3" which is now causing this to send one Email per file?  If yes, do you have any ideas to stop it.  So close!

Thanks - David