Introduction
The Filter function in PowerApps allows you to filter data based on specific criteria. When working with SharePoint data sources, this function becomes invaluable for retrieving, sorting, and displaying the data you need. To use the Filter function effectively, it's important to understand its syntax:
Filter(Source, Formula)
Prerequisites
Before diving into the Filter function, ensure you have the following prerequisites:
- A PowerApps account.
- Access to a SharePoint site with a list containing various column types (text, number, date, choice, lookup, person, etc.).
Now, let's walk through the process step by step.
Connect to SharePoint
- Launch PowerApps and create a new app or edit an existing one.
- If not already connected, add a data source by selecting "Data" from the left-hand menu and clicking "Add a data source." Choose SharePoint and provide your site's URL.
Insert a Gallery
- On your app's screen, insert a Gallery control by selecting it from the "Insert" menu. This Gallery will display the filtered results.
Configure the Gallery
- Select the Gallery control, navigate to the formula bar, and set the "Items" property using the Filter function. Let's explore the filter function for different types of columns.
Use filter function for different types of columns
Text column
Let's apply filters to the Text column for values equal to 'Item 1'.
Filter('PowerApps Filter', Title = "Item 1")

Choice column
Let's apply filters to the Choice column for values equal to 'Choice #1'.
Filter('PowerApps Filter', ChoiceField.Value = "Choice #1")

Multi-select choice column
Let's apply filters to the Multichoice column for values containing 'SharePoint'.
Filter('PowerApps Filter', "SharePoint" in 'MultiChoice - Skills'.Value)

Boolean column
Let's apply filters to the Boolean column for values equal to true.
Filter('PowerApps Filter', BooleanField = true)

Currency column
Let's apply filters to the Currency column for values equal to 100.
Filter('PowerApps Filter', CurrencyField = 100)

Number column











Join the conversation! Your thoughts help the community grow.