Today we are happy to announce support for connecting to SharePoint lists that have more than 256 items using PowerApps.\u00a0Please see the details below on the changes you need to make to your apps to take make use of this support. We are also working on making any new apps generated use these capabilities out of box,\u00a0so look for that announcement in the near future.<\/p>\n
First off, the 256 item limit was raised to 500 items, so even without making use of the new support for paging, you should now be able to get up to 500 items from the list.<\/p>\n
With the changes rolled out today, your existing apps should see no difference in behavior. If the list you were connecting to was under 500 items, your apps will continue to work fine without any changes. In these cases, PowerApps was simply retrieving all of the items, and letting you sort\/search\/filter by any of the columns you had in your list.<\/p>\n
For lists that contain more than 500 items, there are some changes you need to make to your app (to the \u201cItems\u201d property of the Gallery control), and once these are done, you should be able to simply scroll to the bottom of a list, and PowerApps will bring in the next set of results from SharePoint\u00a0to make things work.<\/p>\n
First off, to display the results that are most relevant to you, you have to decide on what to sort by. SharePoint supports sorting on column types of \u201cSingle line of Text\u201d, Choice, Number, Date and Person. In the formula for \u201cItems\u201d in the gallery control of your app, make sure you pick one of the columns of these types. If you pick a column that does not support sorting, you will get a warning with a blue icon telling you that your source list doesn\u2019t support the column you picked for sorting. In those cases, PowerApps will just revert to sorting the first 500 items in your list by ID, so watch out for that. If you are dealing with a list that has more than 5,000 items in SharePoint, you should make sure that you add an index to the column that you want to sort by.<\/p>\n
Second, if you\u2019d like to filter the set of items that you are showing in the gallery control, you will make use of a \u201cFilter\u201d expression, rather than the \u201cSearch\u201d expression, which is the default that existing apps used. With our changes, SharePoint connector now supports \u201cequals\u201d type of queries on columns that support filtering (Single line of text, choice, numbers, dates and people), so make sure that the columns and the expressions you use are supported and watch for the same warning to avoid reverting back to the top 500 items. We will be adding \u201cStarts With\u201d support in the future as well. As with sorting, it is required to have an index on the column that you want to filter your items by, if you are dealing with a SharePoint list that has more than 5,000 items.<\/p>\n
We will be working on adding support for \u201cSearch\u201d function by connecting to SharePoint Search service in the future.<\/p>\n
Here are some sample expressions for the \u201cItems\u201d field that show how you can retrieve items from SharePoint that match certain criteria:<\/p>\n
Retrieve all items that are \u201cAssignedTo\u201d the current user, and sort by \u201cDueDate\u201d, where these are column names in a SharePoint list named \u201cIssues\u201d:<\/strong><\/p>\n SortByColumns(Filter(‘Issues’,AssignedTo.Email=User().Email), “DueDate”, If(SortDescending1, Descending, Ascending))<\/p>\n<\/blockquote>\n Retrieve all items that have \u201cStatus\u201d equal to \u201cPending\u201d, and that match the string added to the search box, sorted by \u201cCreated\u201d date in a list called \u201cHelpdesk Requests\u201d:<\/strong><\/p>\n SortByColumns(Filter(‘Helpdesk Requests’, Status=\u201dPending\u201d, If(Len(TextSearchBox1.Text)>0, Title=TextSearchBox1.Text, true)), “Created”, If(SortDescending1, Descending, Ascending))<\/p>\n<\/blockquote>\n Please continue to give us feedback using the Forum and your comments on what other options you would like to see in SharePoint integration, it is very helpful to drive our prioritization as we add new features.<\/p>\n","protected":false},"excerpt":{"rendered":" Today we are happy to announce support for building apps that connect to large SharePoint lists using PowerApps, a top request from our users.<\/p>\n","protected":false},"author":152,"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":[2110],"class_list":["post-268","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-news","product-power-apps"],"yoast_head":"\n\n
\n