{"id":109223,"date":"2019-04-05T07:00:32","date_gmt":"2019-04-05T14:00:32","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/"},"modified":"2024-06-12T18:49:49","modified_gmt":"2024-06-13T01:49:49","slug":"delegation-enhancements-for-lookups-today-now-and-addcolumns","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/","title":{"rendered":"Delegation enhancements for lookups, Today\/Now, and AddColumns"},"content":{"rendered":"<p>I&#8217;m happy to announce we&#8217;ve made another batch of delegation enhancements for Canvas apps.<\/p>\n<p>Delegation refers to an app&#8217;s ability to &#8220;delegate&#8221; work to the data source instead of doing it locally, resulting in more scalable and higher performance apps.\u00a0 In short, Delegation = Good.\u00a0 For more details see\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/delegation-overview\">Understand delegation in a canvas app<\/a>.<\/p>\n<p>We are far from done with delegation.\u00a0 If you have suggestions on which queries and operations we should improve next please leave a comment or use the <a href=\"https:\/\/powerusers.microsoft.com\/t5\/PowerApps-Community\/ct-p\/PowerApps1\">community forum<\/a>.<\/p>\n<h2>Filter on lookup non-primary key fields<\/h2>\n<p>This one is specific to the Common Data Service.\u00a0 Until now we have only supported filtering an entity based on the primary key of a Many-to-One lookup.\u00a0 We can now filter based on other fields in the related entity, dramatically expanding the possibilities when working with lookups.<\/p>\n<p>For example, consider the following screen, built on top of the standard Accounts and Contacts entities:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2617\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/03\/2019-03-31_17h36_48.png\" alt=\"\" width=\"1206\" height=\"506\" \/><\/p>\n<p>Note that there are no blue wavy lines or warning symbols &#8211; this formula is fully delagable.\u00a0 Let&#8217;s type a value in the text input box to perform our filtering:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2618\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/03\/2019-03-31_17h38_15.png\" alt=\"\" width=\"1206\" height=\"506\" \/><\/p>\n<p>If we watch the network traffic from our app, and URL decode the query,\u00a0we see:<\/p>\n<pre>$filter=(primarycontactid\/address1_city eq 'Issaquah')&amp;$expand=primarycontactid<\/pre>\n<p>This is <a href=\"https:\/\/www.odata.org\/\">OData<\/a> speak for the formula we wrote with &#8220;primarycontactid&#8221; and &#8220;address1_city&#8221; being the logical names for our entity and column references in the formula.\u00a0 The <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-isblank-isempty\"><strong>IsBlank<\/strong><\/a> test does not appear here because it does not depend on data in the records being filtered and was handled before talking with the data source.<\/p>\n<p>We can also delegate the <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-startswith\"><strong>StartsWith<\/strong>\u00a0and <strong>EndsWith<\/strong><\/a> functions for our search:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2680\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/04\/2019-04-04_17h03_11.png\" alt=\"\" width=\"1277\" height=\"642\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-04_17h03_11.webp 1277w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-04_17h03_11-300x151.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-04_17h03_11-1024x515.webp 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-04_17h03_11-768x386.webp 768w\" sizes=\"auto, (max-width: 1277px) 100vw, 1277px\" \/><\/p>\n<p>But we can&#8217;t yet delegate the\u00a0<strong>in<\/strong> operator, it is on our to-do list.\u00a0 Although definitely not the same, <strong>StartsWith<\/strong> can be used for many scenarios until we can delegate\u00a0<strong>in<\/strong>.<\/p>\n<p>Because these <strong>Filter<\/strong> calls can now be delegated, we can now search through millions of records and return the first page of results quickly with the ability to go back for more as the user scrolls through them in the gallery.<\/p>\n<h2>Today and Now<\/h2>\n<p>In the lookup filter example above, the <strong>IsBlank<\/strong> test didn&#8217;t need to be delegated because it could be evaluated locally before going to the data source.\u00a0 We will be doing more of these optimizations over time.<\/p>\n<p>Case in point: we just added the <strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-now-today-istoday\">Today<\/a><\/strong> and <strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-now-today-istoday\">Now<\/a><\/strong> functions to the list of things we can do locally.\u00a0 For example, this filter of the Accounts entity:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2646\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/04\/2019-04-01_09h38_29.png\" alt=\"\" width=\"860\" height=\"214\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-01_09h38_29.webp 860w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-01_09h38_29-300x75.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-01_09h38_29-768x191.webp 768w\" sizes=\"auto, (max-width: 860px) 100vw, 860px\" \/><\/p>\n<p>expands the Today function call into a constant to send to the data source:<\/p>\n<pre>$filter=createdon ge 2019-04-01T16:16:03.013Z<\/pre>\n<p>Similarly, we already supported delegation for the <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-date-time\">Date<\/a> function:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2647\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/04\/2019-04-01_09h38_47.png\" alt=\"\" width=\"860\" height=\"214\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-01_09h38_47.webp 860w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-01_09h38_47-300x75.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-01_09h38_47-768x191.webp 768w\" sizes=\"auto, (max-width: 860px) 100vw, 860px\" \/><\/p>\n<p>But, we don&#8217;t yet support constant folding with the <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-dateadd-datediff\">DateAdd<\/a> function:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2645\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/04\/2019-04-01_09h37_55.png\" alt=\"\" width=\"860\" height=\"214\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-01_09h37_55.webp 860w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-01_09h37_55-300x75.webp 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2019\/04\/2019-04-01_09h37_55-768x191.webp 768w\" sizes=\"auto, (max-width: 860px) 100vw, 860px\" \/><\/p>\n<p>We&#8217;re on it.<\/p>\n<h2>AddColumns<\/h2>\n<p>Lots of people use the <strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-table-shaping\">AddColumns<\/a><\/strong> function to bring in data from across data source, effectively performing heterogeneous joins.<\/p>\n<p>For example, imagine that you have a list of real estate agents in SharePoint and a table of home listings in SQL Server that contains tens of thousands of rows. You could combine this information with <strong>AddColumns<\/strong>:<\/p>\n<pre>AddColumns( RealEstateAgents, \"Listings\",  Filter(  '[dbo].[AllListings]', ListingAgentName = AgentName ) )<\/pre>\n<p>Until now, <strong>AddColumns<\/strong> would not delegate the <strong>Filter<\/strong> call to SQL Server in the third argument and thus only the first 500 listings would have been searched.\u00a0 No longer, we can now delegate all the arguments of the\u00a0<strong>AddColumns <\/strong>function.<\/p>\n<p>But we aren&#8217;t done here yet. What we haven&#8217;t done is make the <em>outside<\/em> of the <strong>AddColumns<\/strong>\u00a0delegable and pageable, the output\u00a0is still limited by the non-delegation limit.\u00a0 If for example you attach the result to a Gallery control through its Items property, it will be limited to 500 records.\u00a0 Something for our next installment.<\/p>\n<p>A word of caution on using\u00a0<strong>AddColumns<\/strong> in this manner.\u00a0 Each <strong>Filter<\/strong> call above is another round trip to the data source.\u00a0 \u00a0If performance is an issue, check the network activity in your browser to understand what is happening behind the scenes.\u00a0 If the number of related rows is small enough, you may want to bring them into a collection and do the filtering locally.\u00a0 You may also want to restructure your app to only grab the related records when a user specifically asks for them.\u00a0 \u00a0We can and will make this better in time, for example we could batch these calls for multiple rows to make this more efficient.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;m happy to announce we&#8217;ve made another batch of delegation enhancements for Canvas apps. Delegation refers to an app&#8217;s ability to &#8220;delegate&#8221; work to the data source instead of doing it locally, resulting in more scalable and higher performance apps.\u00a0 In short, Delegation = Good.\u00a0 For more details see\u00a0Understand delegation in a canvas app. We<\/p>\n","protected":false},"author":86,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","power-apps-category":[1591,1617,1664],"power-apps-tag":[],"coauthors":[2332],"class_list":["post-109223","power-apps","type-power-apps","status-publish","hentry","power-apps-category-dataverse","power-apps-category-formulas","power-apps-category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Delegation enhancements for lookups, Today\/Now, and AddColumns - 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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Delegation enhancements for lookups, Today\/Now, and AddColumns - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"I&#8217;m happy to announce we&#8217;ve made another batch of delegation enhancements for Canvas apps. Delegation refers to an app&#8217;s ability to &#8220;delegate&#8221; work to the data source instead of doing it locally, resulting in more scalable and higher performance apps.\u00a0 In short, Delegation = Good.\u00a0 For more details see\u00a0Understand delegation in a canvas app. We\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-13T01:49:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/03\/2019-03-31_17h36_48.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Greg Lindhorst\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/\",\"name\":\"Delegation enhancements for lookups, Today\/Now, and AddColumns - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/03\/2019-03-31_17h36_48.png\",\"datePublished\":\"2019-04-05T14:00:32+00:00\",\"dateModified\":\"2024-06-13T01:49:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/#primaryimage\",\"url\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/03\/2019-03-31_17h36_48.png\",\"contentUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/03\/2019-03-31_17h36_48.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Apps\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Delegation enhancements for lookups, Today\/Now, and AddColumns\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Delegation enhancements for lookups, Today\/Now, and AddColumns - 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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/","og_locale":"en_US","og_type":"article","og_title":"Delegation enhancements for lookups, Today\/Now, and AddColumns - Microsoft Power Platform Blog","og_description":"I&#8217;m happy to announce we&#8217;ve made another batch of delegation enhancements for Canvas apps. Delegation refers to an app&#8217;s ability to &#8220;delegate&#8221; work to the data source instead of doing it locally, resulting in more scalable and higher performance apps.\u00a0 In short, Delegation = Good.\u00a0 For more details see\u00a0Understand delegation in a canvas app. We","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/","og_site_name":"Microsoft Power Platform Blog","article_modified_time":"2024-06-13T01:49:49+00:00","og_image":[{"url":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/03\/2019-03-31_17h36_48.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 min read","Written by":"Greg Lindhorst"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/","name":"Delegation enhancements for lookups, Today\/Now, and AddColumns - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/#primaryimage"},"thumbnailUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/03\/2019-03-31_17h36_48.png","datePublished":"2019-04-05T14:00:32+00:00","dateModified":"2024-06-13T01:49:49+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/#primaryimage","url":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/03\/2019-03-31_17h36_48.png","contentUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/03\/2019-03-31_17h36_48.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-enhancements-for-lookups-today-now-and-addcolumns\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Apps","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/"},{"@type":"ListItem","position":3,"name":"Delegation enhancements for lookups, Today\/Now, and AddColumns"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"msxcm_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:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/109223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-apps"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/86"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=109223"}],"version-history":[{"count":2,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/109223\/revisions"}],"predecessor-version":[{"id":109371,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/109223\/revisions\/109371"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=109223"}],"wp:term":[{"taxonomy":"power-apps-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-category?post=109223"},{"taxonomy":"power-apps-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-tag?post=109223"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=109223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}