{"id":289,"date":"2016-10-21T03:03:41","date_gmt":"2016-10-21T10:03:41","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/performance-refresh-forall-multiple-field-lookups-531\/"},"modified":"2025-06-11T08:17:06","modified_gmt":"2025-06-11T15:17:06","slug":"performance-refresh-forall-multiple-field-lookups-531","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/performance-refresh-forall-multiple-field-lookups-531\/","title":{"rendered":"Performance, Refresh button, ForAll, and multiple field lookups"},"content":{"rendered":"<p>Earlier this week, we shipped release 2.0.531, which is bursting at the seams with fresh improvements and new functionality.\u00a0 We\u2019ll cover a few of the bigger items here, with the full list on the <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/release-notes\/\">What\u2019s New<\/a> page.<\/p>\n<h2>Performance improvements<\/h2>\n<p>We\u2019ve heard from you, often, that performance is a top concern.\u00a0 We agree, and performance has been and will continue to be one of our top priorities.\u00a0<\/p>\n<p>In this release, we have improved the performance of:<\/p>\n<ul>\n<li>The various player apps load faster.<\/li>\n<li>Your apps within the player will load much faster.\u00a0<\/li>\n<li>Apps will load much faster in the studio for authoring.<\/li>\n<li>And in many other areas too.<\/li>\n<\/ul>\n<h2>Refresh button<\/h2>\n<p>For apps that are created from data, we now include a Refresh button in the title bar of the browse screen:<\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/59ce8750-55ad-4cc7-8744-7274c293d303.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"557\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/59ce8750-55ad-4cc7-8744-7274c293d303.png\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" title=\"image\" width=\"320\"\/><\/a><\/p>\n<p>With this button, users can refresh the data on this screen without needing to close and reopen the app.<\/p>\n<h2>ForAll and multiple record Patch<\/h2>\n<p>In our July user survey, you identified the lack of iteration as a limiting factor for using PowerApps.\u00a0 To fill this gap we have added a new function: <strong><a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/function-forall\/\">ForAll<\/a>.\u00a0 <\/strong><\/p>\n<p><strong>ForAll<\/strong>( <em>Table<\/em>, <em>Formula<\/em> ) evaluates <em>Formula<\/em> across all of the records of <em>Table<\/em>.\u00a0 The formula could perform a calculation or perform a series of actions, using the <strong><a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/operators\/\">; operator<\/a><\/strong>.\u00a0\u00a0 The function returns a table of the results from each formula evaluation, in the same order as the input table.\u00a0<\/p>\n<p>Let\u2019s look at a very simple example. Imagine you have a table of Values in a collection named <strong>Squares<\/strong>:<\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/76c43278-7dbb-49e8-9f5a-9ef5c3def71f.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"squares\" border=\"0\" height=\"111\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/76c43278-7dbb-49e8-9f5a-9ef5c3def71f.png\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" title=\"squares\" width=\"62\"\/><\/a><\/p>\n<p>We can call the <strong><a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/function-numericals\/\">Sqrt<\/a><\/strong> function for each of the records of this table with:<\/p>\n<ul>\n<li><strong>ForAll( Squares, Sqrt( Value ) ) <\/strong><\/li>\n<\/ul>\n<p><strong>Sqrt <\/strong>is called for each record of the table, and is passed the contents of the Value field.\u00a0 This formula returns the table:<\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/11c4bba0-b4dc-419c-b665-5501424474a7.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"sqrt\" border=\"0\" height=\"111\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/11c4bba0-b4dc-419c-b665-5501424474a7.png\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" title=\"sqrt\" width=\"62\"\/><\/a><\/p>\n<p>Let\u2019s take a slightly more complex example.\u00a0 Imagine you have a collection named <strong>Sayings:<\/strong><\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/8a2f72a3-d19d-490e-851d-e32c548261cc.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"translate\" border=\"0\" height=\"137\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/8a2f72a3-d19d-490e-851d-e32c548261cc.png\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" title=\"translate\" width=\"131\"\/><\/a><\/p>\n<p>We can call the <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/connection-microsoft-translator\/\">Microsoft Translator<\/a> service to translate each of these into Spanish with:<\/p>\n<ul>\n<li><strong>ForAll( Sayings, MicrosoftTranslator.Translate( Value, &#8220;es&#8221; ) )<\/strong><\/li>\n<\/ul>\n<p>which returns the table:<\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/327acf43-8b62-4615-9bc2-0487e7bd3e19.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"translate-es\" border=\"0\" height=\"137\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/327acf43-8b62-4615-9bc2-0487e7bd3e19.png\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" title=\"translate-es\" width=\"112\"\/><\/a><\/p>\n<p>You may ask why we named our new function <strong>ForAll<\/strong> instead of <em>For <\/em>or <em>ForEach<\/em> as many other languages do.\u00a0\u00a0 That\u2019s because our system is designed for asynchronous and parallel operations.\u00a0 The formula for one record may be paused waiting on a data operation, and while we wait, we may start evaluating the formula for another record.\u00a0\u00a0 The best way to think about it is that we could be evaluating the formula for<em> all<\/em><em> <\/em>the records at the same time, with the implication that we can\u2019t guarantee the order in which the formula for each record will be evaluated.\u00a0 For most functions and services that are stateless and do not have side effects, including those used above, this is perfectly fine and allows us to optimize performance.\u00a0 We are hoping that the <strong>All<\/strong> in the function name will differentiate it from other <em>For<\/em> constructs that imply an order.<\/p>\n<p>That doesn\u2019t mean you can\u2019t use functions with side effects.\u00a0 In fact, we believe a major use for <strong>ForAll <\/strong>may be moving data from one place to another, and you can use <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/function-clear-collect-clearcollect\/\">Collect<\/a>, <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/function-update-updateif\/\">Update<\/a>, and <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/function-patch\/\">Patch<\/a> within it.\u00a0 For example, imagine a collection of <strong>Products<\/strong>, some of which need to be ordered:<\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/d22487e1-6095-4cd0-aaa4-e641108fc85d.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"prod\" border=\"0\" height=\"136\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/d22487e1-6095-4cd0-aaa4-e641108fc85d.png\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" title=\"prod\" width=\"416\"\/><\/a><\/p>\n<p>We\u2019d like to create a new collection, with just the items that need to be reordered (for which <strong>Quantity Requested<\/strong> is greater than <strong>Quantity Available<\/strong>).\u00a0 We can do this easily with <strong>ForAll:<\/strong><\/p>\n<ul>\n<li><strong>Clear( NewOrder ); ForAll( Products, If( &#8216;Quantity Requested&#8217; &gt; &#8216;Quantity Available&#8217;, Collect( NewOrder, { Product: Product, &#8216;Quantity To Order&#8217;: &#8216;Quantity Requested&#8217; &#8211; &#8216;Quantity Available&#8217; } ) )<\/strong><\/li>\n<\/ul>\n<p>which results in the <strong>NewOrder <\/strong>collection being filled with:<\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/88711da7-599f-40c4-89ee-d088dc9e352f.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"prod-order\" border=\"0\" height=\"85\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/88711da7-599f-40c4-89ee-d088dc9e352f.png\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" title=\"prod-order\" width=\"250\"\/><\/a><\/p>\n<p>In PowerApps, there are many ways to accomplish the above task.\u00a0 The documentation for <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/function-forall\/\">ForAll<\/a> gives more examples and a fuller explanation.<\/p>\n<p>Finally, one of the reasons you gave us for needing iteration was the bulk update of data.\u00a0 And <strong>ForAll <\/strong>can be used for that.\u00a0 But as we think it may be common, we also added the ability to use the <strong>Patch<\/strong> function on a set of records instead of just modifying one record at a time.<\/p>\n<h2>Multiple fields in Lookups<\/h2>\n<p>With this release, we are introducing support for showing multiple fields from your lookup data source.<\/p>\n<p>For example, let\u2019s assume your data source contains a lookup field to your employee list, and in your company there are multiple people with the same first and last name.\u00a0 So that users of your app can properly distinguish between \u201cAnne Smith\u201d from accounting and \u201cAnne Smith\u201d from engineering you can configure your lookup to show more than one field.<\/p>\n<p>To do so, when working with a <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/control-form-detail\/\">Edit form<\/a> control,\u00a0 expand the menu from the right side pane and change display fields from 1 to 2:<\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/cc07df9e-083d-4d67-9054-f65743dda4a2.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"3\" border=\"0\" height=\"591\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/cc07df9e-083d-4d67-9054-f65743dda4a2.png\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" title=\"3\" width=\"775\"\/><\/a><\/p>\n<p>Next, change <strong>Value2<\/strong> to Department, Job title, or another field and see how these choices are reflected in the dropdown:<\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/51baf1e9-6587-444c-a331-6b1c76965ecf.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"459\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/51baf1e9-6587-444c-a331-6b1c76965ecf.png\" style=\"border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; display: inline; padding-right: 0px\" title=\"image\" width=\"780\"\/><\/a><\/p>\n<p>Multiple field support is available for both SharePoint and Microsoft Common Data Model today with more connector support on the way.<\/p>\n<h2>And so much more\u2026<\/h2>\n<p>Check out the <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/release-notes\/\">What\u2019s New<\/a> page for more details on:<\/p>\n<ul>\n<li>Available in several new languages with more on the way.<\/li>\n<li>Select and rename controls more easily.<\/li>\n<li>Find options in the toolbar more easily.<\/li>\n<li>Show the Advanced view with a single click.<\/li>\n<li>Better sorting and filtering across sessions and devices.<\/li>\n<li>Improved feedback mechanism where you can track the progress of a ticket.<\/li>\n<li>Raise numbers to new heights with the <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/function-numericals\/\">Power<\/a> function.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Release 2.0.531 is bursting at the seams with fresh improvements and new functionality.&nbsp; We\u2019ll cover a few of the bigger items here, with the full list on the What\u2019s New page.<\/p>\n","protected":false},"author":86,"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":[2104],"class_list":["post-289","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>Performance, Refresh button, ForAll, and multiple field lookups - 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\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Performance, Refresh button, ForAll, and multiple field lookups - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Release 2.0.531 is bursting at the seams with fresh improvements and new functionality.&nbsp; We\u2019ll cover a few of the bigger items here, with the full list on the What\u2019s New page.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/performance-refresh-forall-multiple-field-lookups-531\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-21T10:03:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:17:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/59ce8750-55ad-4cc7-8744-7274c293d303.png\" \/>\n<meta name=\"author\" content=\"Greg Lindhorst\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greg Lindhorst\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/greg-lindhorst\/\",\"@type\":\"Person\",\"@name\":\"Greg Lindhorst\"}],\"headline\":\"Performance, Refresh button, ForAll, and multiple field lookups\",\"datePublished\":\"2016-10-21T10:03:41+00:00\",\"dateModified\":\"2025-06-11T15:17:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/\"},\"wordCount\":908,\"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\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/59ce8750-55ad-4cc7-8744-7274c293d303.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/\",\"name\":\"Performance, Refresh button, ForAll, and multiple field lookups - 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\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/59ce8750-55ad-4cc7-8744-7274c293d303.png\",\"datePublished\":\"2016-10-21T10:03:41+00:00\",\"dateModified\":\"2025-06-11T15:17:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#primaryimage\",\"url\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/59ce8750-55ad-4cc7-8744-7274c293d303.png\",\"contentUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/59ce8750-55ad-4cc7-8744-7274c293d303.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Performance, Refresh button, ForAll, and multiple field lookups\"}]},{\"@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\/dbd4cb8af4503e696f240353831f05d4\",\"name\":\"Greg Lindhorst\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g0133d144d5ed416197bd3b29ccd9a59c\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g\",\"caption\":\"Greg Lindhorst\"},\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/gregli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Performance, Refresh button, ForAll, and multiple field lookups - 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\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/","og_locale":"en_US","og_type":"article","og_title":"Performance, Refresh button, ForAll, and multiple field lookups - Microsoft Power Platform Blog","og_description":"Release 2.0.531 is bursting at the seams with fresh improvements and new functionality.&nbsp; We\u2019ll cover a few of the bigger items here, with the full list on the What\u2019s New page.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/performance-refresh-forall-multiple-field-lookups-531\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2016-10-21T10:03:41+00:00","article_modified_time":"2025-06-11T15:17:06+00:00","og_image":[{"url":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/59ce8750-55ad-4cc7-8744-7274c293d303.png","type":"","width":"","height":""}],"author":"Greg Lindhorst","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greg Lindhorst","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/greg-lindhorst\/","@type":"Person","@name":"Greg Lindhorst"}],"headline":"Performance, Refresh button, ForAll, and multiple field lookups","datePublished":"2016-10-21T10:03:41+00:00","dateModified":"2025-06-11T15:17:06+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/"},"wordCount":908,"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\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#primaryimage"},"thumbnailUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/59ce8750-55ad-4cc7-8744-7274c293d303.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/","name":"Performance, Refresh button, ForAll, and multiple field lookups - 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\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#primaryimage"},"thumbnailUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/59ce8750-55ad-4cc7-8744-7274c293d303.png","datePublished":"2016-10-21T10:03:41+00:00","dateModified":"2025-06-11T15:17:06+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#primaryimage","url":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/59ce8750-55ad-4cc7-8744-7274c293d303.png","contentUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/59ce8750-55ad-4cc7-8744-7274c293d303.png"},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2016\/10\/21\/performance-refresh-forall-multiple-field-lookups-531\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Performance, Refresh button, ForAll, and multiple field lookups"}]},{"@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\/dbd4cb8af4503e696f240353831f05d4","name":"Greg Lindhorst","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g0133d144d5ed416197bd3b29ccd9a59c","url":"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d2e26bc357423265c4eeeb6a4ed51bd71fb29b8eced3e31f4bc1ccd5bedaf80f?s=96&d=mm&r=g","caption":"Greg Lindhorst"},"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/gregli\/"}]}},"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\/289","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\/86"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=289"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/289\/revisions"}],"predecessor-version":[{"id":131404,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/289\/revisions\/131404"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=289"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=289"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=289"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=289"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=289"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=289"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=289"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}