{"id":121,"date":"2018-01-31T04:57:12","date_gmt":"2018-01-31T12:57:12","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/using-sql-server-views-in-powerapps\/"},"modified":"2025-06-11T08:10:00","modified_gmt":"2025-06-11T15:10:00","slug":"using-sql-server-views-in-powerapps","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/using-sql-server-views-in-powerapps\/","title":{"rendered":"Using SQL Server Views in PowerApps"},"content":{"rendered":"<p>\u00a0<\/p>\n<p>We are very pleased to announce today that SQL views from the SQL Server connector available at the end of the week in PowerApps. Leveraging SQL Views will allow you to combine data in SQL Server prior to bring that data into PowerApps. This can allow for better performance in PowerApps without having to load sets of data and mashing it up later, explained in Mehdi\u2019s blog post here (<a href=\"https:\/\/powerapps.microsoft.com\/en-us\/blog\/performance-considerations-with-powerapps\/\">https:\/\/powerapps.microsoft.com\/en-us\/blog\/performance-considerations-with-powerapps\/<\/a> ).<\/p>\n<p>A common scenario for makers is to have a single table (Product Category) with lookups to another table (Products) which contain data points like the product number, name and price. In the past you would need to bring in both tables into PowerApps, create a gallery of categories, then lookup the detail information for the product\u2019s information. If this was done incorrectly, you could experience performance issues due to the amount of data calls to your SQL Server.<\/p>\n<p>Another scenario this addresses is the need to aggregate (group and sum) data prior to bringing it into PowerApps. Rather than bring all of the records into PowerApps and using the Sum feature, for example, you can do all of that advanced processing in SQL Server.<\/p>\n<p>Let\u2019s look at the correct way to do this now:<\/p>\n<p>Start in SQL Server by creating a SQL View to mash up your two tables:<\/p>\n<ol>\n<li>Log into SQL Server Management Studio (<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms\">https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms<\/a> ) or your tool of choice to access SQL Server<\/li>\n<li>Expand Databases and go to Views<\/li>\n<li>Right click on Views to create a new View<\/li>\n<li>Use the designer to create your view or write it using T-SQL<\/li>\n<\/ol>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b1d56678-c1ac-429c-9446-a9a8c63f829f.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"table\" border=\"0\" height=\"578\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b1d56678-c1ac-429c-9446-a9a8c63f829f.png\" style=\"display: inline; background-image: none;\" title=\"table\" width=\"881\"\/><\/a><\/p>\n<p>\u00a0\u00a0\u00a0 5. Click Save and name your view (I called mine VW_ProdCat_W_ProdDetails)<\/p>\n<p>\u00a0\u00a0\u00a0 6. Run your view to make sure you are getting the results you expect<\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/24a05ae4-683a-4d72-a9dd-913f3c251845.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"data\" border=\"0\" height=\"173\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/24a05ae4-683a-4d72-a9dd-913f3c251845.png\" style=\"display: inline; background-image: none;\" title=\"data\" width=\"582\"\/><\/a><\/p>\n<p>Next, we move to PowerApps:<\/p>\n<ol>\n<li>Open PowerApps in your environment that has a connection to the SQL Database that has the view you just created<\/li>\n<li>Open Data Sources and select your SQL Connection<\/li>\n<li>Now you will see your new view in the list (or if you have many tables and views it might not show by default, use the search feature to search for your view)<\/li>\n<\/ol>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/3ca367ff-e301-4601-82c5-bbbc5ce63519.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"viewshow\" border=\"0\" height=\"326\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/3ca367ff-e301-4601-82c5-bbbc5ce63519.png\" style=\"display: inline; background-image: none;\" title=\"viewshow\" width=\"330\"\/><\/a><\/p>\n<p>\u00a0\u00a0\u00a0 4. Check the box next to your new view then click the Connect button<\/p>\n<p>\u00a0\u00a0\u00a0 5. Add a Gallery to the canvas and select your view as the data source<\/p>\n<p>Now you will see your mashed-up data in the gallery with out having to make multiple calls to the database to get that data together.<\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/73edad03-cbdb-443f-9c6d-f782dd03ba66.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"gallery\" border=\"0\" height=\"301\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/73edad03-cbdb-443f-9c6d-f782dd03ba66.png\" style=\"display: inline; background-image: none;\" title=\"gallery\" width=\"404\"\/><\/a><\/p>\n<p>\u00a0<\/p>\n<p>There are a few features to keep in mind when using SQL Views:<\/p>\n<ul>\n<li>At this time, SQL Views are read-only in PowerApps<\/li>\n<li>You cannot update or create records through a view, but you can perform these operations directly on a SQL Table.<\/li>\n<li>You <u>will<\/u> be able to use key columns from the view to update \/create rows in other tables.\u00a0\u00a0You will need to update the individual tables that fed into the view.\u00a0 Be sure to include in the view primary keys for any lookups so you can easily interact with the base tables.<\/li>\n<li>If you would like to call Stored Procedures, you will need to use Microsoft Flow at this time (<a href=\"https:\/\/docs.microsoft.com\/en-us\/connectors\/sql\/\" title=\"https:\/\/docs.microsoft.com\/en-us\/connectors\/sql\/\">https:\/\/docs.microsoft.com\/en-us\/connectors\/sql\/<\/a>)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>We are very pleased to announce today that SQL views from the SQL Server connector available at the end of the week in PowerApps.<\/p>\n","protected":false},"author":87,"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":[3424],"job-role":[],"product":[3473],"property":[],"topic":[],"coauthors":[2135],"class_list":["post-121","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-news","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>Using SQL Server Views in PowerApps - 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\/2018\/01\/31\/using-sql-server-views-in-powerapps\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using SQL Server Views in PowerApps - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"We are very pleased to announce today that SQL views from the SQL Server connector available at the end of the week in PowerApps.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/using-sql-server-views-in-powerapps\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-31T12:57:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:10:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b1d56678-c1ac-429c-9446-a9a8c63f829f.png\" \/>\n<meta name=\"author\" content=\"Evan Chaki\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Evan Chaki\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 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\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/evan-chaki\/\",\"@type\":\"Person\",\"@name\":\"Evan Chaki\"}],\"headline\":\"Using SQL Server Views in PowerApps\",\"datePublished\":\"2018-01-31T12:57:12+00:00\",\"dateModified\":\"2025-06-11T15:10:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/\"},\"wordCount\":547,\"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\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b1d56678-c1ac-429c-9446-a9a8c63f829f.png\",\"keywords\":[\"Connectors\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/\",\"name\":\"Using SQL Server Views in PowerApps - 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\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b1d56678-c1ac-429c-9446-a9a8c63f829f.png\",\"datePublished\":\"2018-01-31T12:57:12+00:00\",\"dateModified\":\"2025-06-11T15:10:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#primaryimage\",\"url\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b1d56678-c1ac-429c-9446-a9a8c63f829f.png\",\"contentUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b1d56678-c1ac-429c-9446-a9a8c63f829f.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using SQL Server Views in PowerApps\"}]},{\"@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\/98aacde8099b676ab8c7d46a5f2793bb\",\"name\":\"Evan Chaki\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/c7b4f1ac40e2b80cc4069d38791ead340f454cfc6c78cc15793ca9d6301de400?s=96&d=mm&r=g8090c1afb2732c0e5cf53ed5da525495\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c7b4f1ac40e2b80cc4069d38791ead340f454cfc6c78cc15793ca9d6301de400?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c7b4f1ac40e2b80cc4069d38791ead340f454cfc6c78cc15793ca9d6301de400?s=96&d=mm&r=g\",\"caption\":\"Evan Chaki\"},\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/evchaki\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using SQL Server Views in PowerApps - 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\/2018\/01\/31\/using-sql-server-views-in-powerapps\/","og_locale":"en_US","og_type":"article","og_title":"Using SQL Server Views in PowerApps - Microsoft Power Platform Blog","og_description":"We are very pleased to announce today that SQL views from the SQL Server connector available at the end of the week in PowerApps.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/using-sql-server-views-in-powerapps\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2018-01-31T12:57:12+00:00","article_modified_time":"2025-06-11T15:10:00+00:00","og_image":[{"url":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b1d56678-c1ac-429c-9446-a9a8c63f829f.png","type":"","width":"","height":""}],"author":"Evan Chaki","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Evan Chaki","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/evan-chaki\/","@type":"Person","@name":"Evan Chaki"}],"headline":"Using SQL Server Views in PowerApps","datePublished":"2018-01-31T12:57:12+00:00","dateModified":"2025-06-11T15:10:00+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/"},"wordCount":547,"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\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#primaryimage"},"thumbnailUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b1d56678-c1ac-429c-9446-a9a8c63f829f.png","keywords":["Connectors"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/","name":"Using SQL Server Views in PowerApps - 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\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#primaryimage"},"thumbnailUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b1d56678-c1ac-429c-9446-a9a8c63f829f.png","datePublished":"2018-01-31T12:57:12+00:00","dateModified":"2025-06-11T15:10:00+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#primaryimage","url":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b1d56678-c1ac-429c-9446-a9a8c63f829f.png","contentUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/b1d56678-c1ac-429c-9446-a9a8c63f829f.png"},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2018\/01\/31\/using-sql-server-views-in-powerapps\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Using SQL Server Views in PowerApps"}]},{"@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\/98aacde8099b676ab8c7d46a5f2793bb","name":"Evan Chaki","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c7b4f1ac40e2b80cc4069d38791ead340f454cfc6c78cc15793ca9d6301de400?s=96&d=mm&r=g8090c1afb2732c0e5cf53ed5da525495","url":"https:\/\/secure.gravatar.com\/avatar\/c7b4f1ac40e2b80cc4069d38791ead340f454cfc6c78cc15793ca9d6301de400?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c7b4f1ac40e2b80cc4069d38791ead340f454cfc6c78cc15793ca9d6301de400?s=96&d=mm&r=g","caption":"Evan Chaki"},"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/evchaki\/"}]}},"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\/121","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\/87"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=121"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/121\/revisions"}],"predecessor-version":[{"id":131121,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/121\/revisions\/131121"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=121"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=121"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=121"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=121"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=121"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=121"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=121"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}