{"id":314,"date":"2016-06-28T09:25:17","date_gmt":"2016-06-28T16:25:17","guid":{"rendered":""},"modified":"2025-06-11T08:18:16","modified_gmt":"2025-06-11T15:18:16","slug":"no-record-limit-with-sql-azure-and-salesforce","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/no-record-limit-with-sql-azure-and-salesforce\/","title":{"rendered":"No record limit with SQL Azure and Salesforce"},"content":{"rendered":"<p>We continue to enhance our ability to work with large data sets.\u00a0 We are happy to announce that with this release, apps created from SQL Azure and Salesforce now support more than 500 records.\u00a0 As long as the author sticks to delegatable functions and operators and records are not unreasonably wide, PowerApps places no limit on the number of records that can be worked with.\u00a0 SQL Azure and Salesforce are just a start &#8211; more data sources are on the way.<\/p>\n<p>For illustration purposes, imagine you have a table in SQL Azure of 20,000 records, named \u201c20,000 Rows\u201d.\u00a0 In this table, there are two columns:<\/p>\n<ul>\n<li>The Number of the record.<\/li>\n<li>The same value spelled out in a text string, named \u201cNumberString\u201d, separating out the thousands for illustration purposes.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"20,000 rows in a table\" border=\"0\" height=\"295\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/1269756d-2270-4da3-b70c-dae8eec67e73.png\" style=\"background-image: none; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; margin-right: auto; border-width: 0px;\" title=\"20,000 rows in a table\" width=\"223\"\/><\/p>\n<p>If we direct PowerApps to create a phone app from data on this table using a SQL Azure connection, the result displays:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"20,000 rows, showing the first page of data\" border=\"0\" height=\"537\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/66c8a23d-fd80-403a-9e6c-e0379eeecf58.png\" style=\"background-image: none; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; margin-right: auto; border-width: 0px;\" title=\"20,000 rows, showing the first page of data\" width=\"302\"\/><\/p>\n<p>Notice that the rows are ordered 1, 10, 100 \u2013 because we are sorting based on the lexical order of text strings, not the numerical order.<\/p>\n<p>You can\u2019t tell when reading this, but this screen is populated relatively quickly.\u00a0 When the app starts, it pulls down the first page of results, but does not pull down the full 20,000 records.\u00a0 As the user scrolls down past the end of the first page, the next page is brought down automatically.<\/p>\n<p>Now let\u2019s try some interesting searches.\u00a0 Place \u201c500\u201d in the Search box:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"20,000 rows, searched for 500, showing the first page of data\" border=\"0\" height=\"531\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/9d90f729-bf2f-4730-ae9d-24e7b4312d57.png\" style=\"background-image: none; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; margin-right: auto; border-width: 0px;\" title=\"20,000 rows, searched for 500, showing the first page of data\" width=\"302\"\/><\/p>\n<p>The app has done a substring match for \u201c500\u201d and returned just those results across all 20,000 records.\u00a0 And you can\u2019t tell from reading this, but this is also done relatively quickly.\u00a0 The app sent the search term to SQL Azure to process, and SQL Azure replied with only the 20 records that contain \u201c500\u201d in their name (20 records).<\/p>\n<p>Let\u2019s try another search: \u201c10\u201d.\u00a0 This will result in 1,380 records, and again we will pull down just one page of results at a time so that this screen is displayed quickly:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"20,000 rows, searched for 10, showing the first page of data\" border=\"0\" height=\"531\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/0dd6899f-31d9-4630-95fb-fdcbbe22d00f.png\" style=\"background-image: none; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; margin-right: auto; border-width: 0px;\" title=\"20,000 rows, searched for 10, showing the first page of data\" width=\"302\"\/><\/p>\n<p>And if we scroll down, we can see some more \u201c10\u201d matches:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"20,000 rows, searched for 10, showing a later page of data\" border=\"0\" height=\"531\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/22206abc-7490-4703-9c90-99d0ebafea6a.png\" style=\"background-image: none; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; margin-right: auto; border-width: 0px;\" title=\"20,000 rows, searched for 10, showing a later page of data\" width=\"302\"\/><\/p>\n<p>We can also sort this list in the opposite direction by pressing the sort up\/down button at the top of the screen:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"531\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/559098a0-d1e5-4fdb-bae6-a231b9abf60d.png\" style=\"background-image: none; float: none; padding-top: 0px; padding-left: 0px; margin-left: auto; display: block; padding-right: 0px; margin-right: auto; border-width: 0px;\" title=\"image\" width=\"302\"\/><\/p>\n<p>Computers have been searching and sorting text by pushing queries to servers for a very long time. Nonetheless, this is a milestone for PowerApps in supporting large data sets.\u00a0 In addition, PowerApps is novel in some important ways:<\/p>\n<ul>\n<li>PowerApps brings these capabilities to mobile devices, making it possible to have good performance in low bandwidth and limited memory\/storage situations.<\/li>\n<li>We will support a wide assortment of data sources. The first step is SQL Azure and Salesforce but more connectors will be added in the months ahead.\u00a0 You can tell us which ones are most important to you on the <a href=\"https:\/\/powerusers.microsoft.com\/t5\/PowerApps-Community\/ct-p\/PowerApps1\">Community pages<\/a> at <a href=\"https:\/\/powerapps.com\">https:\/\/powerapps.com<\/a>.<\/li>\n<li>We will make it easy to author an app that can handle large data sets and performs well.\u00a0 <strong>In the above example, not one formula was touched<\/strong>\u00a0 &#8211; this app was completely generated by solely looking at the schema of our 20,000 row table<strong>.<\/strong>\u00a0 Even with great connector diversity, authors work with data in a consistent manner.\n<ul><!--EndFragment--><\/ul>\n<\/li>\n<\/ul>\n<h2>New Search function<\/h2>\n<p>If we look at the formula for the gallery\u2019s Items property, we\u2019ll find:<\/p>\n<blockquote><p><strong>SortByColumns( Search( &#8216;[dbo].[20,000 Rows]&#8217;, TextSearchBox1.Text, &#8220;NumberString&#8221;), &#8220;NumberString&#8221;, If(SortDescending1, Descending, Ascending) )<\/strong><\/p><\/blockquote>\n<p>We have introduced a new <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/function-filter-lookup\/\"><strong>Search<\/strong> function<\/a> to search one or more columns for a text string.\u00a0 It automatically handles the case in which no search term is present, returning all records, a good match for a search Text input control.\u00a0 As was shown above, the entire text string need not be matched (a substring match).\u00a0 For more details and examples, please see the <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/function-filter-lookup\/\">documentation<\/a>.<\/p>\n<p>Also in this release, the <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/operators\/\"><strong>In<\/strong> operator<\/a> now supports delegation making it possible to delegate the equivalent of the above formula using the <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/function-filter-lookup\/\"><strong>Filter<\/strong> function<\/a> instead.\u00a0 We have decided to switch over to the <strong>Search<\/strong> function for apps created from data since it is tuned to this scenario and it is simpler to use.\u00a0 Some caution will always be required with the <strong>Filter<\/strong> function as a complex formula could be introduced that cannot be delegated.<\/p>\n<h2>More to come<\/h2>\n<p>Although we have reached an important milestone, we are far from done.\u00a0 Here are some of the important limitations to be aware of:<\/p>\n<ul>\n<li>With each keystroke in the Search box, the app will initiate a new search.\u00a0 At present, we do not cancel the old ones and the queries stack up sequentially.\u00a0 So although a single query may be fast, slowly typing a long search term will result in many queries being issued, one after another, and performance will suffer.<\/li>\n<li>The <strong>Search<\/strong> function operates only on text fields.\u00a0 It will not find, for example, \u201c10\u201d in a number or date field.\u00a0 This is why we needed to have a text field in our table in the above example.<\/li>\n<li>Delegation support in more functions and operators.<\/li>\n<li>And as mentioned above, delegation support in more connectors.<\/li>\n<\/ul>\n<h2>Other new features in release 2.0.450<\/h2>\n<p>As always, we continue to fix bugs and improve performance across the board.<\/p>\n<p>Thank you for your many questions, comments, suggestions, and bug reports on the <a href=\"https:\/\/powerusers.microsoft.com\/t5\/PowerApps-Community\/ct-p\/PowerApps1\">Community pages<\/a> at <a href=\"https:\/\/powerapps.com\">https:\/\/powerapps.com<\/a>.\u00a0 Even easier is the \u201cSend feedback\u201d button while authoring (upper right hand, next to your name).\u00a0 We really want to hear from you!<\/p>\n<h3>Adding a data source to Form controls is easier<\/h3>\n<p>When working with <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/control-form-detail\/\">form controls<\/a>, you can now add a data source directly in the right hand pane.\u00a0\u00a0 Tap the data source icon or \u201cNo data source selected\u201d.<\/p>\n<h3>Set shared password for protected PDF files<\/h3>\n<p>There is a new <strong>Password<\/strong> property on the <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/control-pdf-viewer\/\">PDF viewer control<\/a> which an author can set so that all users of the app can view a password protected PDF.\u00a0 Without this, each user will be prompted for the PDF\u2019s password.<\/p>\n<h3><\/h3>\n<h3>UTC now supported in the DatePicker control<\/h3>\n<p>To stay time zone agnostic, many data sources store date\/times in Coordinated Universal Time (UTC).\u00a0 There is a new <strong>DataTimeZone<\/strong> property on the <a href=\"https:\/\/powerapps.microsoft.com\/en-us\/tutorials\/control-date-picker\/\">Date picker control<\/a>, which an author can set to <strong>Local<\/strong> or <strong>UTC.\u00a0\u00a0 <\/strong>If this difference is not taken into account, displaying and picking dates can be off by one, giving unexpected results.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We continue to enhance our ability to work with large data sets. We are happy to announce that with this release, apps created from SQL Azure and Salesforce now support more than 500 records.<\/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-314","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>No record limit with SQL Azure and Salesforce - 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\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"No record limit with SQL Azure and Salesforce - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"We continue to enhance our ability to work with large data sets. We are happy to announce that with this release, apps created from SQL Azure and Salesforce now support more than 500 records.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/no-record-limit-with-sql-azure-and-salesforce\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-28T16:25:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:18:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/1269756d-2270-4da3-b70c-dae8eec67e73.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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/greg-lindhorst\/\",\"@type\":\"Person\",\"@name\":\"Greg Lindhorst\"}],\"headline\":\"No record limit with SQL Azure and Salesforce\",\"datePublished\":\"2016-06-28T16:25:17+00:00\",\"dateModified\":\"2025-06-11T15:18:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/\"},\"wordCount\":1039,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/1269756d-2270-4da3-b70c-dae8eec67e73.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/\",\"name\":\"No record limit with SQL Azure and Salesforce - 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\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/1269756d-2270-4da3-b70c-dae8eec67e73.png\",\"datePublished\":\"2016-06-28T16:25:17+00:00\",\"dateModified\":\"2025-06-11T15:18:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#primaryimage\",\"url\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/1269756d-2270-4da3-b70c-dae8eec67e73.png\",\"contentUrl\":\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/1269756d-2270-4da3-b70c-dae8eec67e73.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"No record limit with SQL Azure and Salesforce\"}]},{\"@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\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/gregli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"No record limit with SQL Azure and Salesforce - 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\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/","og_locale":"en_US","og_type":"article","og_title":"No record limit with SQL Azure and Salesforce - Microsoft Power Platform Blog","og_description":"We continue to enhance our ability to work with large data sets. We are happy to announce that with this release, apps created from SQL Azure and Salesforce now support more than 500 records.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/no-record-limit-with-sql-azure-and-salesforce\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2016-06-28T16:25:17+00:00","article_modified_time":"2025-06-11T15:18:16+00:00","og_image":[{"url":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/1269756d-2270-4da3-b70c-dae8eec67e73.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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/greg-lindhorst\/","@type":"Person","@name":"Greg Lindhorst"}],"headline":"No record limit with SQL Azure and Salesforce","datePublished":"2016-06-28T16:25:17+00:00","dateModified":"2025-06-11T15:18:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/"},"wordCount":1039,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#primaryimage"},"thumbnailUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/1269756d-2270-4da3-b70c-dae8eec67e73.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/","name":"No record limit with SQL Azure and Salesforce - 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\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#primaryimage"},"thumbnailUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/1269756d-2270-4da3-b70c-dae8eec67e73.png","datePublished":"2016-06-28T16:25:17+00:00","dateModified":"2025-06-11T15:18:16+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#primaryimage","url":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/1269756d-2270-4da3-b70c-dae8eec67e73.png","contentUrl":"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/1269756d-2270-4da3-b70c-dae8eec67e73.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2016\/06\/28\/no-record-limit-with-sql-azure-and-salesforce\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"No record limit with SQL Azure and Salesforce"}]},{"@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\/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:\/\/www.microsoft.com\/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:\/\/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\/314","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\/86"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=314"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/314\/revisions"}],"predecessor-version":[{"id":128807,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/314\/revisions\/128807"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=314"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=314"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=314"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=314"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=314"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=314"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=314"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}