cancel
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.
add-yammer.PNG
 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.
send-email.PNG
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.
final-approve-flow.PNG
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.
flow-of-week-article.PNG
Confirm the connectors and select Continue.
flow-of-week-article-submit.PNG
Add your message and click Submit.
flow-of-week-article-submit-complete.PNG
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.
flow-of-week-article-approved.PNG
Once approved, the News item is automatically published to the SharePoint Online Intranet like before.
flow-of-week-intranet.PNG
The News item is also posted to the All Company group in Yammer.
flow-of-week-yammer.PNG
The News item is also sent with a message to the Microsoft Teams channel to let the group know the article has been posted.
flow-of-week-teams.PNG
And finally the News post is sent via email. 
flow-of-week-email.PNG
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.
Resources:
Documentation:
 
Thanks for Reading!!
Meet Our Blog Authors
  • Working daily with Microsoft Cloud to deliver the needs of my company, my customers and various Microsoft communities and forums. | Office 365 | Flow | PowerShell | PowerApps | SharePoint |
  • Co-founder of https://plumsail.com, Office 365 and SharePoint expert. Passionate about design and development of easy to use, convenient and flexible products.
  • Microsoft Business Apps MVP. Owner of ThriveFast, an Office 365 consulting company.
  • 7x Microsoft Business Solutions MVP (CRM)
  • I'm keen in MS technologies, SharePoint, Office 365 and development for them
  • Daniel is a Business Productivity Consultant & Microsoft Business Solutions MVP who is very enthusiastic about all things Office 365, Microsoft Flow, PowerApps, Azure & SharePoint (Online). Since the preview, Daniel has been working with Microsoft Flow and later on with Microsoft PowerApps. That led to him being awarded an MVP Award for Business Solutions. He loves to blog, present and evangelize about improving productivity in the modern workspace with these amazing tools!
  • Michelle is an Office 365 solution architect in Twin Cities, MN. She has been delivering business collaboration solutions for years with her focus on SharePoint and Office 365. Michelle is a recent board member of the Minnesota Office 365 User Group and has been a member of the SharePoint community since 2009. She is a frequent speaker at MNSPUG and SharePoint Saturday and co-chaired the Legal SharePoint User Group for 4 years. Her most frequent projects have involved rolling out a large deployment of Office 365, SharePoint Online intranet, build of a "CHAMPS" Office 365 user adoption program and most recently, SharePoint On-Premise to Online Migration. Michelle is very excited about cloud technology as it is shifting her IT Pro focus to collaboration strategy and technical adoption.
  • I'm a Microsoft Office Servers and Services MVP with a special interest in SharePoint, Office 365, Microsoft Flow, Microsoft Teams and PowerApps. I work at Triad Group Plc ( https://triad.co.uk)
  • Passionate #Programmer #SharePoint #SPFx #Office365 #MSFlow | C-sharpCorner MVP | SharePoint StackOverflow, Github, PnP contributor