Showing results for 
Search instead for 
Did you mean: 

Automate Mass Company Communications with Page Approval Flow in SharePoint Online Part 2

Picking up right where we left off in Part 1, lets get in and edit this Flow to add new connections! We will start with adding an action Yammer Post Message and add a Flow post to All company group. In the message text, we will add Title and Description from the SharePoint dynamic content.
 Next we will add Microsoft Teams action to Post a Message and send it to the general channel with the Title and submission announcement in the message.  This can also be done if the page was rejected to let your communication or marketing department know the page approval status. 
teams.PNGAnother popular communication vehicle for companies is email.  Lets create the email connector by adding the O365 email action to Send an Email.  Depending on your permissions, you can send to all company and send on behalf of a mailbox like Marketing.  You can also design the email to have the title in the subject and description in the body of the email.
Here is the final approval Flow.  Condition Request is equal to Approve, if yes, update the SharePoint column status to Approved, post to Yammer, post a message in Microsoft Teams, Send an email to all company and Send an email to the requestor to inform them of the status of the request. Click Save your Flow.
Let's test the Flow.  Visit the Company Intranet in SharePoint Online.
Create your News post.  Name your post, add an image and add a text webpart. Click Submit for approval button.
Confirm the connectors and select Continue.
Add your message and click Submit.
The approval like before, will be on the slide-out panel in SharePoint Online, in email and in the Flow Approval panel for the approver to take action.  In this case we use the Flow Approver panel in Flow, click approve and type in the comments. Select the Confirm button to approve the News item.
Once approved, the News item is automatically published to the SharePoint Online Intranet like before.
The News item is also posted to the All Company group in Yammer.
The News item is also sent with a message to the Microsoft Teams channel to let the group know the article has been posted.
And finally the News post is sent via email. 
The Page Approval Flow can be invaluable as you try to connect to all the locations where your employees prefer to consume and digest company information.  Automate your communication with Microsoft Flow and make your work more efficient and productive.
Thanks for Reading!!
Meet Our Blog Authors
  • Experienced Consultant with a demonstrated history of working in the information technology and services industry. Skilled in Office 365, Azure, SharePoint Online, PowerShell, Nintex, K2, SharePoint Designer workflow automation, PowerApps, Microsoft Flow, PowerShell, Active Directory, Operating Systems, Networking, and JavaScript. Strong consulting professional with a Bachelor of Engineering (B.E.) focused in Information Technology from Mumbai University.
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • Cambridge UK Power Platform User Group Leader, Technical evangelist and speaker. Always says yes to coffee! #LetsGetCoffee
  • Passionate #Programmer #SharePoint #SPFx #Office365 #MSFlow | C-sharpCorner MVP | SharePoint StackOverflow, Github, PnP contributor
  • I am building business processes and applications that are easy for users' to stick to, so they can follow and understand them. In overall I transform processes to be more reliable and effortless. I am a proud co-organizer of SharePoint Saturday Warsaw and active community member, blogger and international speaker.