Alert when a folder is not updated

[Dybarna]

Hello all.

I have a simple flow that adds a file (create) when an email with an attachment arrives to my inbox.

This emails are sent daily, so every attachment has a new name, since the date is added to the file name.

What I need is to set an alarm or notification if the folder is not updated, meaning the email failed to arrive with the attachment.

Any ideas??

thx!!!

[Pstork1]

AS long as you know what the base of the file name is you could do this by creating a Flow triggered by a daily recurrence.  Then build the name of the file in a variable and try to retrieve the properties of the file.  If it is successsful then the file arrived.  If not, (Status code = 404) then you can send your alert.

[Dybarna]

Thanks!

I am pretty new on this. I got stuck here.

Where can build the variable with file name? 

[RezaDorrani]

Hi @Dybarna 

You can also check on a scheduled flow which runs daily to check if any file has been created in last 24 hours

If no file created -> no attachment was added

and you can notify yourself

odata query

Created ge 'addDays(utcNow(),-1)'

where addDays(utcNow(),-1) is an expression

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Pstork1]

For the file name you can build using an Initialize Variable action and a formula that concatentates the basefilename with a custom formatted date using Now().

[v-bacao-msft · Accepted solution]

Hi @Dybarna ,

If the files in the specified folder will contain the date of the day, please refer to the following method to achieve your needs.

• Use List folder action to get the files in the specified folder.
• Use Filter array to filter files with the current date in the file name.
• Use length() function to determine if such a file exists, and if it does not exist, send a notification.

Image reference:

Hope it helps.

Best Regards,

[Dybarna]

Thanks! it worked, but how do I do to stop the "Apply to each". since it sending me and email for each of the old files in the folder. 

[Gordon]

am using the below to check if a file has been created in a folder. If it hasn't been done someone's forgotten and we need an alert. Listing the folder, and the two filters give the results I'd expect. The FilterTimes uses Addhours/UTCNow(-ve) so only files newer than the threshold make it through.

However, if there are no new files, the output of the last filter is Body[] as expected, but when this get passed to the condition, I'm just getting the input of that being { "expressionResult": false}

I think I'm getting my brackets and commas wrong in the condition, or have I named the array incorrectly?