cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cisco_Dave
New Member

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
RobElliott
Super User
Super User

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

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

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
 

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

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (2,711)