cancel
Showing results for 
Search instead for 
Did you mean: 
MGLovesFlow

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!!
About the Author
  • 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.
  • I am a Microsoft Business Applications MVP and a Senior Manager at EY. I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness. I am a leader of the Houston Power Platform User Group and Power Automate community superuser. I love traveling , exploring new places, and meeting people from different cultures.
  • Read more about me and my achievements at: https://ganeshsanapblogs.wordpress.com/about MCT | SharePoint, Microsoft 365 and Power Platform Consultant | Contributor on SharePoint StackExchange, MSFT Techcommunity
  • Encodian Owner / Founder - Ex Microsoft Consulting Services - Architect / Developer - 20 years in SharePoint - PowerPlatform Fan
  • Founder of SKILLFUL SARDINE, a company focused on productivity and the Power Platform. You can find me on LinkedIn: https://linkedin.com/in/manueltgomes and twitter http://twitter.com/manueltgomes. I also write at https://www.manueltgomes.com, so if you want some Power Automate, SharePoint or Power Apps content I'm your guy 🙂
  • I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 15 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.
  • Big fan of Power Platform technologies and implemented many solutions.
  • Passionate #Programmer #SharePoint #SPFx #M365 #Power Platform| Microsoft MVP | SharePoint StackOverflow, Github, PnP contributor
  • Web site – https://kamdaryash.wordpress.com Youtube channel - https://www.youtube.com/channel/UCM149rFkLNgerSvgDVeYTZQ/