{"id":758,"date":"2016-08-03T10:32:07","date_gmt":"2016-08-03T16:32:07","guid":{"rendered":"http:\/\/www.idubbs.com\/blog\/?p=758"},"modified":"2016-08-03T10:32:07","modified_gmt":"2016-08-03T16:32:07","slug":"powerapps-and-sharepoint-filtering-the-list-view","status":"publish","type":"post","link":"https:\/\/www.idubbs.com\/blog\/2016\/powerapps-and-sharepoint-filtering-the-list-view\/","title":{"rendered":"PowerApps and SharePoint – Filtering the List View"},"content":{"rendered":"

*Disclaimer* \u2013 This post based on Preview version of PowerApps. I\u2019ll make every effort to update with any changes and verify when PowerApps is released.<\/font> <\/p>\n

One of the powerful features in PowerApps for SharePoint users is the ability to create an app from a SharePoint list. When using this feature, PowerApps creates three screens for us to start with: A Browse screen, a View screen, and a New\/Edit Item screen.   <\/p>\n

The Browse screen contains a Gallery control \u2013 which displays the contents of a list. By default it shows ALL items in a list. This might be fine for some business needs \u2013 especially with the inclusion of the search functionality also built into the default screen. Some use cases however may look for a filtered view of a list.  <\/p>\n

The Short Version<\/h2>\n

The browse screen is set up to show all items, as well as take input from the search box. I\u2019m going to change the list to display all items where the Request Type is a certain value. <\/p>\n

    \n
  1. Select the Gallery on the browse page 
    \"image\"<\/a>\n
  2. Change the Items<\/em> formula from search-based to filter-based:
    From:
    \"image\"<\/a>
    SortByColumns(Search(‘Service Requests<\/strong>‘, TextSearchBox1_1.Text, “Comments”, “Notes”, “Title”, “Title”), “Comments”, If(SortDescending1, Descending, Ascending))
    To:
    SortByColumns(Filter(\u2018Service Requests\u2019, ReqType.Value=\u201dPEBKaC\u201d)<\/strong>, “Comments”, If(SortDescending1, Descending, Ascending))\n
  3. Items displayed on the screen should now be filtered by the Request Type. <\/li>\n<\/ol>\n

    Notes <\/h2>\n