{"id":109156,"date":"2017-02-23T07:25:42","date_gmt":"2017-02-23T15:25:42","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/"},"modified":"2025-06-11T08:15:39","modified_gmt":"2025-06-11T15:15:39","slug":"introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/","title":{"rendered":"Introducing Brian T Jackett: PowerApps and Microsoft Flow Social Media Sample"},"content":{"rendered":"<p>We are happy to introduce Mr. Brian T Jackett from <a href=\"https:\/\/briantjackett.com\">https:\/\/briantjackett.com<\/a>. Brian is a Senior Premier Field Engineer at Microsoft specializing in SharePoint development \/ administration and PowerShell for over 9 years. Brian enjoys giving back to the community through giving presentations, planning and volunteering at conferences, maintaining this SharePoint\/.Net centric blog, and contributing to the SharePoint Twitterverse. He also holds several Microsoft Certified Technology Specialist (MCTS) for SharePoint related technologies. He authored this blog to walk us through a scenario for gathering social media input and working with that data in various components. \u00a0This includes Azure SQL, Azure web apps, Azure API apps, and Custom APIs. \u00a0Content below provided by Brian Jackett for the PowerApps and Microsoft Flow Community:<\/p>\n<p>Here is a visual diagram of the high level process we will follow.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow0\" border=\"0\" height=\"273\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/df3429de-e78c-4454-9794-f8bfcbf324df.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow0\" width=\"610\"\/><\/p>\n<ul>\n<li>Flow \u2013 Capture tweets on Twitter with a specific hashtag and insert into Azure SQL DB<\/li>\n<li>Azure Web App \u2013 Entity Framework model used to display Azure SQL data<\/li>\n<li>Azure API App \u2013 Same Entity Frame model used to scaffold API Controller, add \u201cSwashbuckle\u201d NuGet package to add Swagger support<\/li>\n<li>Custom API \u2013 Generate PowerApps Custom API from Azure API App<\/li>\n<li>PowerApps \u2013 App displays data from Custom API<\/li>\n<\/ul>\n<p>All source code for this project is hosted on GitHub at for your reference at <a href=\"https:\/\/github.com\/BrianTJackett\/BTJ.PowerApps.AzureDBSample\" title=\"https:\/\/github.com\/BrianTJackett\/BTJ.PowerApps.AzureDBSample\">https:\/\/github.com\/BrianTJackett\/BTJ.PowerApps.AzureDBSample<\/a>.\u00a0 <em>Please note this is only for demonstration purposes and is not intended for production use.\u00a0 Code and related content is provided as-is with no warranty of any kind.<\/em>\u00a0 For additional information and a more guided walkthrough on the steps of creating a Custom API and the supporting Azure API app please see this <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/blog\/building-a-custom-api-for-powerapps-using-azure-app-service-web-apps\/\">blog post<\/a> from Carlos Aguilar and a <a href=\"https:\/\/blogs.msdn.microsoft.com\/carlosag\/2016\/06\/12\/video-building-a-custom-api-for-powerapps-using-azure-app-service-web-apps\/\">supporting video<\/a> that he created.<\/p>\n<h2>Step 0 &#8211; Create Azure SQL Database (pre-requisite)<\/h2>\n<p>The first step in our process will be capturing input from social media data connectors and inserting records into an Azure SQL database.\u00a0 Since we will need to have the database in order to insert records we will create the database first.\u00a0 We will be using Visual Studio (2015 in this example) with the latest Azure SDK (2.9.5 at the time of writing) but this Azure SQL Database and table schema could be deployed in multiple other ways (see here for more information on <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-get-started\">creating Azure SQL databases<\/a>).\u00a0 Our database is going to capture simple information such as the social media data source, text from the tweet, and user who posted the tweet.\u00a0 Here is a view of the database schema.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow1\" border=\"0\" height=\"577\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/7ccfe3f2-6a10-4715-b901-dd6be75e9260.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow1\" width=\"610\"\/><\/p>\n<table align=\"center\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width: 400px;\" width=\"400\">\n<tbody>\n<tr>\n<td style=\"width: 200px;\">\n<p>ID<\/p>\n<\/td>\n<td style=\"width: 200px;\">\n<p>int<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 200px;\">\n<p>Filename<\/p>\n<\/td>\n<td style=\"width: 200px;\">\n<p>nvarchar(150)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 200px;\">\n<p>Created<\/p>\n<\/td>\n<td style=\"width: 200px;\">\n<p>nvarchar(100)<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 200px;\">\n<p>CreatedBy<\/p>\n<\/td>\n<td style=\"width: 200px;\">\n<p>nvarchar(100)<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u00a0<\/p>\n<p>We will not go through the process of \u00a0deploying the database but an Azure Resource Group project that deploys a SQL Server instance is included in the reference source code.<\/p>\n<h2>Step 1 &#8211; Flow<\/h2>\n<p>Now that we have a database to store data we can create a flow to populate the database based on social media triggers. \u00a0In our example we\u2019ll use Twitter but similar data connectors such as Instagram, Facebook, etc. could be used. \u00a0This flow will consist of a trigger for Twitter to fire on any tweets with a specific hashtag. \u00a0In this example the hashtag is #BTJPADemo. \u00a0After the Twitter trigger add an action for Insert Row to Azure SQL. \u00a0Specify the database table previously created and fill in columns with metadata from Twitter such as \u201ctweet text\u201d, \u201ccreated at\u201d (date timestamp as a string), and \u201ctweeted by\u201d for the Twitter username. \u00a0See following screenshot for information.<\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow2\" border=\"0\" height=\"610\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/653e8a1d-26fc-46f3-b6d1-fa80f4b345a6.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow2\" width=\"444\"\/><\/p>\n<h2>Step 2 &#8211; Azure Web App<\/h2>\n<p>In order to better work with the database we will create a domain model. \u00a0In the sample code an object-relational mapper (ORM) called Entity Framework (EF) was used to add an ADO.Net Entity Data Model using the \u201cEF Designer from Database\u201d option. \u00a0Entity Framework can be added to a .Net project via NuGet (more info on how to get Entity Framework).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow3\" border=\"0\" height=\"161\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/983d2059-478d-49fb-a434-271e0b409c90.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow3\" width=\"610\"\/><\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow4\" border=\"0\" height=\"499\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/2cb3ab78-0ce1-4320-913b-a73f7f314bc4.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow4\" width=\"610\"\/><\/p>\n<p>Now that we have an entity data model we can create a scaffolded item for MVC 5 Controller using Entity Framework.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow5\" border=\"0\" height=\"244\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/db03c45c-92e1-4f93-a2cf-5aa0f47c4ecc.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow5\" width=\"610\"\/><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow6\" border=\"0\" height=\"417\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/8fe2165e-0a17-4984-b703-83577343146e.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow6\" width=\"610\"\/><\/p>\n<p>In order to view the new scaffolded controller you can include a link on the home view. \u00a0Inside of the Views \u2013&gt; Home folder you can modify the Index.cshtml file. \u00a0Insert the following after the \u2018&lt;div class=&#8221;\u201dJumbotron\u201d&#8221;&gt;\u2026&lt;\/div&gt;\u2019 section.<\/p>\n<p><code>&lt;div&gt; \u00a0 \u00a0 @Html.ActionLink(\"Link to new controller\", \"Index\", \"InstagramFiles\") &lt;\/div&gt;<\/code><\/p>\n<p>After building out the web app you can publish it to Azure. \u00a0The documentation on this article walks through the process (same will apply for the Azure API App in Step 3): <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/app-service-web\/web-sites-dotnet-get-started\">https:\/\/docs.microsoft.com\/en-us\/azure\/app-service-web\/web-sites-dotnet-get-started<\/a>.<\/p>\n<h2>Step 3 &#8211; Azure API App<\/h2>\n<p>The Azure API App will use the same entity data model as the Azure Web App. \u00a0This time though instead of creating an MVC controller we will create a Web API 2 Controller using Entity Framework.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow7\" border=\"0\" height=\"249\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/73f6b6db-87e9-4496-b350-546f258fa882.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow7\" width=\"610\"\/><\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow8\" border=\"0\" height=\"249\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/fda72b1a-4f44-4e53-b72c-89f48a2ca2fb.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow8\" width=\"610\"\/><\/p>\n<p>The last step for the Azure API App will be to enable SwaggerUI so that we can test the API in a browser. \u00a0Open the SwaggerConfig.cs file (usually under App_Start folder) and uncomment the line containing \u201c.EnableSwaggerUi(c =&gt;\u201d along with the line preceding and following it. \u00a0See the following screenshot for more details.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow9\" border=\"0\" height=\"140\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/470fe7fa-1931-431d-b1a8-0e1060e9249d.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow9\" width=\"610\"\/><\/p>\n<h2>Step 4 \u2013 Custom API<\/h2>\n<p>Creating a custom API is covered in good detail on the PowerApps blog on the Register Custom APIs in PowerApps tutorial. \u00a0For the purposes of generating the Swagger JSON document from our Azure API App we will need to navigate to the location that the API is hosted and append \u201c\/swagger\u201d. \u00a0This will take us to the SwaggerUI page that we enabled in the SwaggerConfig.cs file. \u00a0At the top of the page will be a box with the location of our hosted API appended with \u201c\/swagger\/docs\/v1\u201d. \u00a0Copy this entire URI and paste it into a browser tab. \u00a0Depending on the browser and your settings you will either be prompted to download the file or presented with the contents of the file in the browser window. \u00a0Save off this JSON document to then use it for registration in the PowerApps Custom API.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow10\" border=\"0\" height=\"153\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/80561747-822b-4c91-bd91-f044fd9784c4.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow10\" width=\"610\"\/><\/p>\n<h2>Step 5 \u2013 PowerApps<\/h2>\n<p>After the Custom API is created it is now possible to consume that API within a PowerApps app. \u00a0Start by adding a data source that is the Custom API we just created.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow11\" border=\"0\" height=\"467\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/d01c39c5-a891-4600-b437-f503925c68b5.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow11\" width=\"573\"\/><\/p>\n<p>Then insert a vertical text gallery and bind the Items property to the \u201cget all items\u201d method from our Azure API App.\u00a0 In our case\u00a0\u00a0 We can modify the field bindings to line up with the columns from database table that are most interesting.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow12\" border=\"0\" height=\"52\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/762d7d44-a66c-459e-9829-2030ad7bdcd3.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow12\" width=\"610\"\/><\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SocialMediaPowerAppsFlow13\" border=\"0\" height=\"381\" src=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/d50d25b2-863b-4a5b-a491-fa36855eee56.png\" style=\"margin: 0px auto; border: 0px currentColor; border-image: none; padding-top: 0px; padding-right: 0px; padding-left: 0px; float: none; display: block; background-image: none;\" title=\"SocialMediaPowerAppsFlow13\" width=\"610\"\/><\/p>\n<p>See the video below for walkthrough of Step 5.<\/p>\n<h2>Video demonstration<\/h2>\n<p>See the above components in action in the following video:<\/p>\n<p><iframe loading=\"lazy\" allowfullscreen=\"\" frameborder=\"0\" height=\"315\" src=\"https:\/\/www.youtube-nocookie.com\/embed\/zjGSdzDRwms\" width=\"560\"><\/iframe><\/p>\n<h2>Conclusion<\/h2>\n<p>This post showed a quick walk through of connecting together multiple services and components between Azure SQL, Azure Web Apps, PowerApps, Flow, Twitter, and more for a social media demo.\u00a0 Hopefully you\u2019ll take this as an opportunity to explore new areas of development and integration.\u00a0 Please share back any feedback you have.<\/p>\n<div style=\"clear: both;\">\u00a0<\/div>\n","protected":false},"excerpt":{"rendered":"<p>We are happy to introduce Mr. Brian T Jackett from https:\/\/briantjackett.com . Brian is a Senior Premier Field Engineer at Microsoft specializing in SharePoint development \/ administration and PowerShell for over 9 years. Brian enjoys giving back to the community through giving presentations, planning and volunteering at conferences, maintaining this SharePoint\/.Net centric blog, and contributing to the SharePoint Twitterverse. He also holds several Microsoft Certified Technology Specialist (MCTS) for SharePoint related technologies. He authored this blog to walk us through a scenario for gathering social media input and working with that data in various components.  This includes Azure SQL, Azure web apps, Azure API apps, and Custom APIs.<\/p>\n","protected":false},"author":106,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[],"job-role":[],"product":[3473],"property":[],"topic":[],"coauthors":[2058],"class_list":["post-109156","post","type-post","status-publish","format-standard","hentry","audience-it-professional","product-power-apps"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Introducing Brian T Jackett: PowerApps and Microsoft Flow Social Media Sample - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introducing Brian T Jackett: PowerApps and Microsoft Flow Social Media Sample - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"We are happy to introduce Mr. Brian T Jackett from https:\/\/briantjackett.com . Brian is a Senior Premier Field Engineer at Microsoft specializing in SharePoint development \/ administration and PowerShell for over 9 years. Brian enjoys giving back to the community through giving presentations, planning and volunteering at conferences, maintaining this SharePoint\/.Net centric blog, and contributing to the SharePoint Twitterverse. He also holds several Microsoft Certified Technology Specialist (MCTS) for SharePoint related technologies. He authored this blog to walk us through a scenario for gathering social media input and working with that data in various components. This includes Azure SQL, Azure web apps, Azure API apps, and Custom APIs.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-23T15:25:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:15:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/df3429de-e78c-4454-9794-f8bfcbf324df.png\" \/>\n<meta name=\"author\" content=\"Audrie Gordon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Audrie Gordon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/audrie-gordon\/\",\"@type\":\"Person\",\"@name\":\"Audrie Gordon\"}],\"headline\":\"Introducing Brian T Jackett: PowerApps and Microsoft Flow Social Media Sample\",\"datePublished\":\"2017-02-23T15:25:42+00:00\",\"dateModified\":\"2025-06-11T15:15:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/\"},\"wordCount\":1146,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/df3429de-e78c-4454-9794-f8bfcbf324df.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/\",\"name\":\"Introducing Brian T Jackett: PowerApps and Microsoft Flow Social Media Sample - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/df3429de-e78c-4454-9794-f8bfcbf324df.png\",\"datePublished\":\"2017-02-23T15:25:42+00:00\",\"dateModified\":\"2025-06-11T15:15:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#primaryimage\",\"url\":\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/df3429de-e78c-4454-9794-f8bfcbf324df.png\",\"contentUrl\":\"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/df3429de-e78c-4454-9794-f8bfcbf324df.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introducing Brian T Jackett: PowerApps and Microsoft Flow Social Media Sample\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/5622f11b1629eeff57465c794c80c936\",\"name\":\"Audrie Gordon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/8a060fc178064c33f81ec0c74cf167a845dc0a9f86c71fd9a276c1eae2d7ae30?s=96&d=mm&r=g84a7fd97215038815e0a810e606188f3\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8a060fc178064c33f81ec0c74cf167a845dc0a9f86c71fd9a276c1eae2d7ae30?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8a060fc178064c33f81ec0c74cf167a845dc0a9f86c71fd9a276c1eae2d7ae30?s=96&d=mm&r=g\",\"caption\":\"Audrie Gordon\"},\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/audrie\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introducing Brian T Jackett: PowerApps and Microsoft Flow Social Media Sample - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/","og_locale":"en_US","og_type":"article","og_title":"Introducing Brian T Jackett: PowerApps and Microsoft Flow Social Media Sample - Microsoft Power Platform Blog","og_description":"We are happy to introduce Mr. Brian T Jackett from https:\/\/briantjackett.com . Brian is a Senior Premier Field Engineer at Microsoft specializing in SharePoint development \/ administration and PowerShell for over 9 years. Brian enjoys giving back to the community through giving presentations, planning and volunteering at conferences, maintaining this SharePoint\/.Net centric blog, and contributing to the SharePoint Twitterverse. He also holds several Microsoft Certified Technology Specialist (MCTS) for SharePoint related technologies. He authored this blog to walk us through a scenario for gathering social media input and working with that data in various components. This includes Azure SQL, Azure web apps, Azure API apps, and Custom APIs.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2017-02-23T15:25:42+00:00","article_modified_time":"2025-06-11T15:15:39+00:00","og_image":[{"url":"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/df3429de-e78c-4454-9794-f8bfcbf324df.png","type":"","width":"","height":""}],"author":"Audrie Gordon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Audrie Gordon","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/audrie-gordon\/","@type":"Person","@name":"Audrie Gordon"}],"headline":"Introducing Brian T Jackett: PowerApps and Microsoft Flow Social Media Sample","datePublished":"2017-02-23T15:25:42+00:00","dateModified":"2025-06-11T15:15:39+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/"},"wordCount":1146,"commentCount":0,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#primaryimage"},"thumbnailUrl":"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/df3429de-e78c-4454-9794-f8bfcbf324df.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/","name":"Introducing Brian T Jackett: PowerApps and Microsoft Flow Social Media Sample - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#primaryimage"},"thumbnailUrl":"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/df3429de-e78c-4454-9794-f8bfcbf324df.png","datePublished":"2017-02-23T15:25:42+00:00","dateModified":"2025-06-11T15:15:39+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#primaryimage","url":"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/df3429de-e78c-4454-9794-f8bfcbf324df.png","contentUrl":"https:\/\/powerbicdn.azureedge.net\/mediahandler\/blog\/media\/PowerBI\/blog\/df3429de-e78c-4454-9794-f8bfcbf324df.png"},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/02\/23\/introducing-brian-t-jackett-powerapps-and-microsoft-flow-social-media-sample\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Introducing Brian T Jackett: PowerApps and Microsoft Flow Social Media Sample"}]},{"@type":"WebSite","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/5622f11b1629eeff57465c794c80c936","name":"Audrie Gordon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/8a060fc178064c33f81ec0c74cf167a845dc0a9f86c71fd9a276c1eae2d7ae30?s=96&d=mm&r=g84a7fd97215038815e0a810e606188f3","url":"https:\/\/secure.gravatar.com\/avatar\/8a060fc178064c33f81ec0c74cf167a845dc0a9f86c71fd9a276c1eae2d7ae30?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a060fc178064c33f81ec0c74cf167a845dc0a9f86c71fd9a276c1eae2d7ae30?s=96&d=mm&r=g","caption":"Audrie Gordon"},"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/audrie\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/109156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/106"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=109156"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/109156\/revisions"}],"predecessor-version":[{"id":131338,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/109156\/revisions\/131338"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=109156"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=109156"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=109156"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=109156"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=109156"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=109156"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=109156"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=109156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}