Learn to Filter SharePoint columns for Power Apps
Power Apps
Sep 26, 2023 9:00 AM

Learn to Filter SharePoint columns for Power Apps

by HubSite 365 about Shane Young [MVP]

SharePoint & PowerApps MVP - SharePoint, O365, Flow, Power Apps consulting & Training

Citizen DeveloperPower SelectionPower AppsLearning Selection

Boost SharePoint efficiency with our expert guide on filtering columns for Power Apps. Learn to curate data for specific business needs!

Understanding SharePoint Column Filtering for Power Apps

In the YouTube video by Shane Young [MVP], he discusses the unique capability in PowerApps for SharePoint users to develop an app from a SharePoint list. This tutorial showcases the generation of three initial screens: A Browse screen, a View screen, and a New/Edit Item screen. The emphasis is on the Browse screen, which houses a Gallery control that showcases the elements of a list.

Interestingly, this screen by default displays ALL items present in a list. While this might be adequate for some professional scenarios, others might require a more refined, filtered view. To cater to such needs, the video explains how to alter the list to display all items where the Request Type tallies with a certain value.

  • At 0:00, the video focuses on SharePoint list filtering in Power Apps.
  • At 0:56, he gives a brief overview of SharePoint List.
  • From 1:29, attention turns towards adding SharePoint list to Power Apps.
  • At 2:53, Shane delves into Filter Text and Multiple lines of text columns.
  • At 4:24, he introduces the StartsWith function for filtering SharePoint.
  • Further, at 6:05 there's a shift towards Filter by Number or Currency Columns.
  • From 9:01 to 23:28, the video traverses through various filters such as Date, Yes-No, Hyperlink, Calculated, Location, Choice, Multiple Choice, Lookup, Person, Created by, Managed Metadata Columns.
  • Lastly, at 24:55, filtering by ID Column is explored.

An Insight into SharePoint Column Filtering for Power Apps

This tutorial was a comprehensive journey towards understanding how SharePoint users can leverage PowerApps. By illustrating how to create an app from a SharePoint list, it provided a practical way to navigate through diverse business needs. In addition to explaining the initial setup, the video shed light on how to customize lists to display chosen items and delve into a refined, filtered view. Moreover, the tutorial delved into various filtering options, thereby facilitating flexibility and control over data view. It presents PowerApps within SharePoint as a robust tool for seamless and customized data management.

Learn about Learn to Filter SharePoint columns for Power Apps

The text focuses on using PowerApps to filter SharePoint columns, which is a powerful feature, especially for SharePoint users, as it allows them to create an app directly from a SharePoint list, adding three main screens: a Browse Screen, a View Screen, and a New/Edit Item Screen. By default, all items in a list are shown on the Browse Screen, however, the video guides on how to filter the list to display items where the Request Type is a specific value.


To learn more about this topic, one can go through Microsoft's official online course on PowerApps for SharePoint users, and numerous online tutorials and training courses available on platforms like Coursera, Udemy, and LinkedIn Learning. Besides, Microsoft's official forum and PowerApps Community are also great places to find help if one gets stuck.


More links on about Learn to Filter SharePoint columns for Power Apps

Filter a search list in an app - Power Apps
Dec 15, 2022 — This article explains how to search for items and filter the list in your app when sourcing data from a list created using Microsoft Lists.
Filter, Search, and LookUp functions in Power Apps
Feb 22, 2023 — The Filter function finds records in a table that satisfy a formula. Use Filter to find a set of records that match one or more criteria and ...
PowerApps Filter SharePoint List (21 Examples)
Jul 22, 2021 — In this scenario, We will see how we can filter SharePoint List items based on an ID column in PowerApps. The below screenshot represents a ...
PowerApps filter SharePoint list Example
Aug 7, 2020 — The Filter function in PowerApps allows you to query a table of data and which could come from your custom collection or data source. Here I ...
Working with SharePoint Choice columns in Power Apps
Dec 28, 2022 — Learn to work with SharePoint Choice columns in Power Apps. ... Learn how to filter when you are allowing multiple selections in a choice column.


Microsoft PowerApps expert, SharePoint list filtering professional, Power Apps for SharePoint specialist, SharePoint app creation guru, PowerApps Gallery control expert