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

PowerApps with Flow - A one stop-shop for social media communication

Introduction

 

This blog walks you through how you can use the two attached templates to build your own mobile PowerApp as a central place to post comments to Facebook, Slack, Twitter and Yammer. The three attachments include a MSAPP file for the PowerApp, zipped file for Flow and STP file for SharePoint. The 'SocialMedia.ZIP' file contains the MSAPP and STP files. Hence you will have to unzip that file. Leave the 'Socialmedia_20171213182703.zip' as it is and import it in Flow. The steps described in this article must be followed in the precise order to get the final app as desired.

 

Overview

 

This video demonstrates what the PowerApp and the Flow can do.

  

Step 1 - Connections  

THESE CONNECTIONS SHOULD BE MADE IN THE SAME ENVIRONMENT YOU PLAN TO BUILD THE APP!!

 

Confirm you have already made the following 5 connections:

 

  1. SharePoint
  2. Facebook
  3. Slack
  4. Twitter
  5. Yammer

 

To check or add your app, in either PowerApps or Flow, go to Connections.

 

Screen1.png 

 

 

 

Connections you will need:

Facebook.png

 

 

 

 

 

Slack.png 

 

 

 

twitter.png

 

 

 

 

 

Yammer.png

 

 

 

 

SharePoint.jpg

 

 

 

 

 

Step 2 - SharePoint List

 

Download a copy of the SocialMedia.zip file,  save it on your local machine and unzip it. Use theSocialMedia.STP file. You can either use the STP attachment or build it from scratch. Below is a screenshot for all the column names and types if you plan to build it from scratch. The list name is 'Scratch'

Pic 2.1.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

This video walks you through how you can import the STP file to your SharePoint Site Collection and create your list.

 

Step 3 - PowerApps

 

THE APP SHOULD BE MADE IN THE SAME ENVIRONMENT YOU HAVE THE CONNECTIONS!!

 

From the SocialMedia.zip file that you downloaded and unzipped, use the Social.MSAPP file and save it on your local machine. This video walks you through how you can use the MSAPP file, connect it to the SharePoint data connection and test and validate

 

Step 4 - Flow

 

THE FLOW SHOULD BE MADE IN THE SAME ENVIRONMENT YOU HAVE THE CONNECTIONS!!

 

Download a copy of the 'Socialmedia_20171213182703.zip' file AND save it to your local machine. This video walks you through how you can use the Zipped file, connect it to SharePoint, Facebook, Twitter, Slack and Yammer data connections and test and validate.

 

Step 5 - DLP

 

Data Loss Prevention or DLP does play a major role in the functionality of this app. If your Flow has a message stating 'Your flow was created, but is currently suspended since it uses a combination of services that conflict with the company data loss prevention policies' as shown below then go to your Admin Center.

 

  Screen3.png

 

 

 

 

 

 Screen4.png

 

 

 

 

 

 

 

 

 

 

 

 

Select Data Loss Prevention policies and see if you have any existing policies that prevent connectors from the "Business data only" and "No business data allowed" data groups.

 

 Screen5.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

For more information you can refer to the Data loss prevention (DLP) policies document

 

Conclusion

 

As mentioned in the video, it's best that you first use the existing SharePoint STP file to create your list, this way you have the correct column names. Once you have the app fully functional, you can add your own modifications or new features to it and hopefully share it with the community!

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/