Scheduled Flow to send email with Folder's updates

[AgainOpen]

Hi.

I want to create a flow to send a daily email to users, if new files were added to the group folder.

I don't want an email to be triggered for every file added/updated, but to check the folder and recognize what is new or what has been updated, put it all in one email and send it out.

Is that possible?

Thank you

[VictorIvanidze]

Yes that's possible.

[Rhiassuring · Accepted solution]

Hi @AgainOpen 

Yes, all you need to do is the following:

1) Create a schedule flow to run nightly.

2) Use a "Get Files (Properties Only)" and Filter Created gt (and use an expression to addDays(utcNow(),-1)'

3) Use the action "Create an HTML" table, using the outputs from the Get Files. 

4) Use an email action, and embed the HTML table into the body of your email.

As a bonus, you can always do a length() on your output from Get Files -- and if it's less than 0, you can just not send an email at all. (Use a condition and tell it if length = less than 1, then, end WF.)