cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cisco_Dave
Level: Power Up

Automated Email Flow

Hi guys. Sorry, new to Flows and could do with some pointers.

Essentially my team send a handover via Outlook that is edited twice daily to a group of people.

What would be the easiest way to incorporate this email into Sharepoint 365, available for editing through the day, where the latest version is then automatically sent at the predefined times to a group of people?

Think it should be straightforward but this is eluding me, can't seem to find a template out there that fits this process, thanks.
4 REPLIES 4
Super User
Super User

Re: Automated Email Flow

Hi @Cisco_Dave, one way to do this is to have a SharePoint list with just 1 item in it which is the handover information. You would edit it when you needed to, then your flow is as follows with an image further down:

  1.  the trigger is a recurrence schedule set to 1 day with the hours and minutes selected that you want it to run.
  2. You then add a SharePoint Get items action and select your site and the list.
  3. Add a Send an email action. It will automatically wrap itself in an Apply to each as it doesn't know that there is only 1 item to bring back from the list. Add in the email addresses and subject and then add in the fields from the dynamic content list which appears on tn the right when you click in the Body box. My example is very basic and I haven't styled the email; you could put it in a table for example with colored background, add other text, a logo etc.

Hopefully that's enough to get you going.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

0-SP-list.png0-Trigger.png1-FlowA.pngEmail.png

Cisco_Dave
Level: Power Up

Re: Automated Email Flow

Thanks for the response but seems a little complex. Just wanted to add one item into the list, whether it be an Outlook Message to edit or Word Document whose contents need inserting into the email and then send it out. This seems to need the whole handover creating from scratch with crop operations to move all the information into there? Thanks
Super User
Super User

Re: Automated Email Flow

Not complicated at all and I used that example because of that. But there are alternatives, for example using a "When a new email arrives" with a Subject filter of "handover" then upload the attachment to SharePoint. But you'd still need another flow with the recurrence to get the contents. Seems more fiddly to me but others might step in with different advice.

Rob
Los Gallardos
 

Cisco_Dave
Level: Power Up

Re: Automated Email Flow

Yeah that's the opposite of what's required but appreciate the pointers 😉

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,012)