cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AgainOpen
Helper I
Helper I

Scheduled Flow to send email with Folder's updates

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

1 ACCEPTED SOLUTION

Accepted Solutions
Rhiassuring
Super User
Super User

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.)

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



View solution in original post

2 REPLIES 2
VictorIvanidze
Community Champion
Community Champion

Yes that's possible.

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.
Rhiassuring
Super User
Super User

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.)

______________________________________________________________


Did this answer your question? Please mark it as the solution.
Did it contribute positively towards finding the final solution? Please give it a thumbs up.

I answer questions on the forum for 2-3 hours every Thursday!



Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,715)