{"id":175,"date":"2017-08-16T07:47:38","date_gmt":"2017-08-16T14:47:38","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/"},"modified":"2025-06-11T08:12:25","modified_gmt":"2025-06-11T15:12:25","slug":"latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/","title":{"rendered":"Delegation for Sum, Average, Min, and Max functions on SQL Server"},"content":{"rendered":"<p>The newest update for PowerApps (version 680) includes an important new capability: the delegation of aggregate functions!<\/p>\n<p><a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/delegation-overview\/\">Delegation<\/a> refers to pushing a data operation to the source.\u00a0 PowerApps is capable of many operations on data, but first the data must be downloaded to the device or browser.\u00a0 Let\u2019s say you need to work with 1 million records.\u00a0 Downloading all that data in order to search, sort, and calculate across it would take prohibitively long, especially over a cellular network.\u00a0 It is far more efficient to push the work to the cloud or on-premise server that can much more easily work with all that data.<\/p>\n<p>In this release you can now delegate <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/function-aggregates\/\"><strong>Sum<\/strong>, <strong>Average<\/strong>, <strong>Min<\/strong>, and <strong>Max<\/strong> functions<\/a> to SQL Server.<\/p>\n<p>Want to see it in action?\u00a0 Connect to your favorite SQL Server and run the following script.\u00a0 Do you remember the old adage: start with a penny, double it every day, and within a month you will be a millionaire?\u00a0 This script does just that: repeatedly doubles a table 20 times until it contains 2<sup>20 <\/sup>rows or 1,048,576 rows.\u00a0 The <em>LongNumber<\/em> column increments with each row giving us something to aggregate.\u00a0 This script takes about 5 minutes to run on a modest SQL Azure instance.<\/p>\n<p style=\"margin-left: 40px\">CREATE TABLE LongTable ( LongNumber BIGINT IDENTITY (1,1) PRIMARY KEY, ShortNumber BIGINT );<\/p>\n<p style=\"margin-left: 40px\">INSERT INTO LongTable ( ShortNumber ) VALUES ( 1 );<\/p>\n<p style=\"margin-left: 40px\">DECLARE @i INT; SET @i = 1; WHILE @i &lt;= 20<br \/>\nBEGIN<br \/>\n\u00a0\u00a0 INSERT INTO LongTable SELECT LongNumber AS ShortNumber FROM LongTable<br \/>\n\u00a0\u00a0 SET @i = @i + 1<br \/>\nEND;<\/p>\n<p>Connect to this table with PowerApps and add a Label control with a Text property set to:<\/p>\n<p><strong>Sum( \u2018[dbo].[LongTable]\u2019, LongNumber )<\/strong><\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/4ac8f1bd-9aa0-4d7a-a338-b02e48d572cc.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"275\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/4ac8f1bd-9aa0-4d7a-a338-b02e48d572cc.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=\"1185\"\/><\/a><\/p>\n<p>After a few seconds of watching ants race across the top of the screen the answer appears in our label: 549,756,338,176.\u00a0 We know the sum of the numbers from <strong>1<\/strong> to <em><strong>n<\/strong><\/em> is <em><a href=\"https:\/\/en.wikipedia.org\/wiki\/1_%2B_2_%2B_3_%2B_4_%2B_%E2%8B%AF\"><strong>n(n+1)\/2<\/strong><\/a><\/em> and sure enough that checks out.<\/p>\n<p>Aggregate functions aren\u2019t limited to just whole tables.\u00a0 We can compose <strong>Sum <\/strong>with <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/function-filter-lookup\/\"><strong>Filter<\/strong><\/a> to operate over a selected portion of the table.\u00a0 For example, let\u2019s change our app to skip the first 100,000 rows:<\/p>\n<p><strong>Sum( Filter( &#8216;[dbo].[LongTable]&#8217;, LongNumber &gt; 100000 ), LongNumber )<\/strong><\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/cb0a799b-11c5-4f70-9510-b8b61a9d16a2.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"295\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/cb0a799b-11c5-4f70-9510-b8b61a9d16a2.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=\"1191\"\/><\/a><\/p>\n<p>Based on our math formula, the sum of numbers to 100,000 is 5,000,050,000.\u00a0 Sure enough, if we subtract this from our previous result we match the correct answer shown in the label: 544,756,288,176.\u00a0 All within a few blinks of an eye.<\/p>\n<p>Ok that\u2019s swell, math is always fun, but what about a practical use?<\/p>\n<p>Let\u2019s take an example from the <a href=\"https:\/\/blogs.msdn.microsoft.com\/kaevans\/2015\/03\/06\/adventure-works-for-azure-sql-database\/\">trusty Adventure Works sample database<\/a>.\u00a0 We\u2019ll look at two tables:<\/p>\n<ul>\n<li><strong>SalesOrderHeader<\/strong> contains all the details about an order in a single row and includes a primary key field <em>SalesOrderID<\/em>.<\/li>\n<li><strong>SalesOrderDetail <\/strong>contains all the line items for a particular order.\u00a0 A set of these are associated with a SalesOrderHeader through a 1-many relationship, using a foreign key field <em>SalesOrderID<\/em>.\u00a0 For example, if an order contains an Orange, an Apple, and a Pear, then there would be 3 SalesOrderDetail rows associated with the order.<\/li>\n<\/ul>\n<p>In our app, we\u2019d like to display a list of orders and with each the total of the detail records for each order.\u00a0 The first part is familiar: create a new app, connect to the SQL database, add a Gallery control to a screen to display the <em>SalesOrderID<\/em> field:<\/p>\n<p><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/394045bc-4e8b-4d56-a9b7-d3dc42d9aa12.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"599\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/394045bc-4e8b-4d56-a9b7-d3dc42d9aa12.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=\"1184\"\/><\/a><\/p>\n<p>This next part is new.\u00a0 For the Subtitle1 field of the Gallery, we will use a combination of the <strong>Filter<\/strong> and <strong>Sum<\/strong> functions.\u00a0 The filter will limit our summation to just the detail records for this order, by matching the foreign key of SalesOrderDetail (<em>SalesOrderID<\/em> in the formula, part of the filter\u2019s record context) with the primary key of SalesOrder (<em>ThisItem.SalesOrderID<\/em> in the formula).\u00a0 The filtered result is then added up and the result shown in our gallery:<\/p>\n<p><a href=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/051be515-19af-4aee-9957-ecbbffc264ff.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"599\" src=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/051be515-19af-4aee-9957-ecbbffc264ff.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=\"1180\"\/><\/a><\/p>\n<p>And just like that we are preforming a grouped sum on a related table.<\/p>\n<p>You will notice that no <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/delegation-overview\/#blue-dot-suggestions\">blue dots<\/a> appeared in this article.\u00a0 The examples given here are only limited in scale by what SQL Server supports and that is very large.\u00a0 But unfortunately, that doesn\u2019t mean there aren\u2019t any blue dots left to be found.\u00a0 Not to worry, we are far from done, more delegation is on the way.<\/p>\n<p>Al always, the <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/release-notes\/\"><u>What\u2019s New<\/u><\/a> page chronicles what has been added with each PowerApps release. Have feedback for us? We would love to hear from you &#8211; please post in our <a href=\"https:\/\/powerusers.microsoft.com\/t5\/PowerApps-Forum\/bd-p\/PowerAppsForum1\"><u>forums<\/u><\/a>! We are always actively listening, learning, and responding to your comments and questions. If there\u2019s a feature you\u2019d like to see in an upcoming release, please <a href=\"https:\/\/powerusers.microsoft.com\/t5\/PowerApps-Ideas\/idb-p\/PowerAppsIdeas\"><u>submit your idea<\/u><\/a> to us!<\/p>\n<p>Happy delegating!<\/p>\n<p>-PowerApps Team<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The newest update for PowerApps (version 680) can delegate the Sum, Average, Min, and Max functions to SQL Server.  We provide an example of summing a million records in a few seconds and show how it can be used to provide the grouped sum of order line items in an order entry system.<\/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-175","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>Delegation for Sum, Average, Min, and Max functions on SQL Server - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Delegation for Sum, Average, Min, and Max functions on SQL Server - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"The newest update for PowerApps (version 680) can delegate the Sum, Average, Min, and Max functions to SQL Server. We provide an example of summing a million records in a few seconds and show how it can be used to provide the grouped sum of order line items in an order entry system.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-16T14:47:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:12:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/4ac8f1bd-9aa0-4d7a-a338-b02e48d572cc.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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/greg-lindhorst\/\",\"@type\":\"Person\",\"@name\":\"Greg Lindhorst\"}],\"headline\":\"Delegation for Sum, Average, Min, and Max functions on SQL Server\",\"datePublished\":\"2017-08-16T14:47:38+00:00\",\"dateModified\":\"2025-06-11T15:12:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/\"},\"wordCount\":766,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/4ac8f1bd-9aa0-4d7a-a338-b02e48d572cc.png\",\"keywords\":[\"Formulas\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/\",\"name\":\"Delegation for Sum, Average, Min, and Max functions on SQL Server - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/4ac8f1bd-9aa0-4d7a-a338-b02e48d572cc.png\",\"datePublished\":\"2017-08-16T14:47:38+00:00\",\"dateModified\":\"2025-06-11T15:12:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#primaryimage\",\"url\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/4ac8f1bd-9aa0-4d7a-a338-b02e48d572cc.png\",\"contentUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/4ac8f1bd-9aa0-4d7a-a338-b02e48d572cc.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Delegation for Sum, Average, Min, and Max functions on SQL Server\"}]},{\"@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":"Delegation for Sum, Average, Min, and Max functions on SQL Server - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Delegation for Sum, Average, Min, and Max functions on SQL Server - Microsoft Power Platform Blog","og_description":"The newest update for PowerApps (version 680) can delegate the Sum, Average, Min, and Max functions to SQL Server. We provide an example of summing a million records in a few seconds and show how it can be used to provide the grouped sum of order line items in an order entry system.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2017-08-16T14:47:38+00:00","article_modified_time":"2025-06-11T15:12:25+00:00","og_image":[{"url":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/4ac8f1bd-9aa0-4d7a-a338-b02e48d572cc.png","type":"","width":"","height":""}],"author":"Greg Lindhorst","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greg Lindhorst","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/greg-lindhorst\/","@type":"Person","@name":"Greg Lindhorst"}],"headline":"Delegation for Sum, Average, Min, and Max functions on SQL Server","datePublished":"2017-08-16T14:47:38+00:00","dateModified":"2025-06-11T15:12:25+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/"},"wordCount":766,"commentCount":0,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/4ac8f1bd-9aa0-4d7a-a338-b02e48d572cc.png","keywords":["Formulas"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/","name":"Delegation for Sum, Average, Min, and Max functions on SQL Server - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/4ac8f1bd-9aa0-4d7a-a338-b02e48d572cc.png","datePublished":"2017-08-16T14:47:38+00:00","dateModified":"2025-06-11T15:12:25+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#primaryimage","url":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/4ac8f1bd-9aa0-4d7a-a338-b02e48d572cc.png","contentUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/4ac8f1bd-9aa0-4d7a-a338-b02e48d572cc.png"},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/08\/16\/latest-powerapps-update-adds-delegation-for-sum-average-min-and-max-functions-on-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Delegation for Sum, Average, Min, and Max functions on SQL Server"}]},{"@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\/175","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=175"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/175\/revisions"}],"predecessor-version":[{"id":131208,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/175\/revisions\/131208"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=175"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=175"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=175"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=175"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=175"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=175"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=175"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}