{"id":25080,"date":"2023-06-06T18:21:13","date_gmt":"2023-06-07T01:21:13","guid":{"rendered":""},"modified":"2025-06-11T07:45:16","modified_gmt":"2025-06-11T14:45:16","slug":"delegation-improvements-async-updateif-and-miscellaneous-functions","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-improvements-async-updateif-and-miscellaneous-functions\/","title":{"rendered":"Delegation improvements &#8211; Async, UpdateIf, and miscellaneous functions"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">We are excited to announce that several key delegation improvements will roll out this month that should improve your app&#8217;s performance and correctness and significantly reduce formula authoring confusion. <\/p>\n\n\n<p class=\"wp-block-paragraph\">Today, when you author a Power Fx query expression to get data, for instance a Filter, Power Apps will show a double blue underline to indicate when an expression cannot be run (or &#8220;delegated&#8221;) to the data source&#8217;s server.  Rather than return no data Power Apps will fetch the first 500\/2000 unfiltered records and finish the query operation with the data it can retrieve. While this can be super helpful at times, it can lead to wrong results if you are not careful.  And your app will likely be slower if you use workarounds to overcome these limitations or if you bring back more data than you need to.  These new delegation features significantly reduce the number of scenarios where the Power Fx query expression is not delegated to the data source server. <\/p>\n\n\n<p class=\"wp-block-paragraph\">First, Power Fx expressions that require asynchronous evaluation will now be delegated.  This means you do not have to divide up the parts of an expression into separate formulas for it to be correctly delegated.  The parts of the expression that require separate evaluation will automatically be ordered and evaluated independently for you.  Named formulas depend on this feature.  <\/p>\n\n\n<p class=\"wp-block-paragraph\">Secondly, the list of functions listed below will no longer break delegation.  They will be evaluated on the client and evaluated for a delegated expression. <\/p>\n\n\n<ul class=\"wp-block-list\"><li>GUID<\/li><li>IsToday<\/li><li>Now<\/li><li>Rand<\/li><li>RandBetween<\/li><li>Today<\/li><\/ul>\n\n\n<p class=\"wp-block-paragraph\">These first two features roll out starting June 12th and will be in all commercial regions by June 26. <\/p>\n\n\n<p class=\"wp-block-paragraph\">Finally, we are also excited to announce the experimental preview of UpdateIf.  UpdateIf will request the set of records that meet the If criteria and then also expands delegation range to be the greater of the (500\/2000) row limit or the page size limit.  Additionally, it will fully delegate to the back-end data source when it is supported.<\/p>\n\n\n<p class=\"wp-block-paragraph\">RemoveIf will follow under this same feature flag.  Both features delegate by identifying individual records and send the update\/removes to the server.<\/p>\n\n\n<p class=\"wp-block-paragraph\">The UpdateIf feature has started rolling out in some regions and will be in all commercial regions by June 21.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to announce that several key delegation improvements will roll out this month that should improve your app&#8217;s performance and correctness and significantly reduce formula authoring confusion.<\/p>\n","protected":false},"author":105,"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":[3421],"coauthors":[2056],"class_list":["post-25080","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-news","product-power-apps","topic-application-modernization"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Delegation improvements - Async, UpdateIf, and miscellaneous functions - 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\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Delegation improvements - Async, UpdateIf, and miscellaneous functions - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"We are excited to announce that several key delegation improvements will roll out this month that should improve your app&#8217;s performance and correctness and significantly reduce formula authoring confusion.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-improvements-async-updateif-and-miscellaneous-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-07T01:21:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T14:45:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2023\/12\/Microsoft-logo_rgb_c-gray_950-1.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"950\" \/>\n\t<meta property=\"og:image:height\" content=\"413\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Lance Delano\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Lance Delano\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lance-delano\/\",\"@type\":\"Person\",\"@name\":\"Lance Delano\"}],\"headline\":\"Delegation improvements &#8211; Async, UpdateIf, and miscellaneous functions\",\"datePublished\":\"2023-06-07T01:21:13+00:00\",\"dateModified\":\"2025-06-11T14:45:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/\"},\"wordCount\":378,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"keywords\":[\"Canvas Apps\",\"Power Fx\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/\",\"name\":\"Delegation improvements - Async, UpdateIf, and miscellaneous functions - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"datePublished\":\"2023-06-07T01:21:13+00:00\",\"dateModified\":\"2025-06-11T14:45:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Delegation improvements &#8211; Async, UpdateIf, and miscellaneous functions\"}]},{\"@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\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/3190911147b72493d0668bd37a01e9e7\",\"name\":\"Lance Delano\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=gb821537d0bc9cf865938c8648693fa53\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=g\",\"caption\":\"Lance Delano\"},\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lanced\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Delegation improvements - Async, UpdateIf, and miscellaneous functions - 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\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/","og_locale":"en_US","og_type":"article","og_title":"Delegation improvements - Async, UpdateIf, and miscellaneous functions - Microsoft Power Platform Blog","og_description":"We are excited to announce that several key delegation improvements will roll out this month that should improve your app&#8217;s performance and correctness and significantly reduce formula authoring confusion.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/delegation-improvements-async-updateif-and-miscellaneous-functions\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2023-06-07T01:21:13+00:00","article_modified_time":"2025-06-11T14:45:16+00:00","og_image":[{"width":950,"height":413,"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2023\/12\/Microsoft-logo_rgb_c-gray_950-1.webp","type":"image\/png"}],"author":"Lance Delano","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Lance Delano","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lance-delano\/","@type":"Person","@name":"Lance Delano"}],"headline":"Delegation improvements &#8211; Async, UpdateIf, and miscellaneous functions","datePublished":"2023-06-07T01:21:13+00:00","dateModified":"2025-06-11T14:45:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/"},"wordCount":378,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"keywords":["Canvas Apps","Power Fx"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/","name":"Delegation improvements - Async, UpdateIf, and miscellaneous functions - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"datePublished":"2023-06-07T01:21:13+00:00","dateModified":"2025-06-11T14:45:16+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2023\/06\/06\/delegation-improvements-async-updateif-and-miscellaneous-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Delegation improvements &#8211; Async, UpdateIf, and miscellaneous functions"}]},{"@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\/"}},{"@type":"Person","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/3190911147b72493d0668bd37a01e9e7","name":"Lance Delano","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=gb821537d0bc9cf865938c8648693fa53","url":"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0f6ea411fb7942a5194735a5c3de7bd16e6f4e03284653afdd08d85c85edbd7b?s=96&d=mm&r=g","caption":"Lance Delano"},"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/lanced\/"}]}},"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:\/\/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\/posts\/25080","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/105"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=25080"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/25080\/revisions"}],"predecessor-version":[{"id":129934,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/25080\/revisions\/129934"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=25080"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=25080"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=25080"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=25080"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=25080"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=25080"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=25080"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=25080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}