Power Apps Filter SharePoint List [25+ Examples]

Microsoft Provides a list of functions to the Power Apps to make the applications more responsive and attractive. One of the key functions is Power Apps Filter(), which allows users to filter SharePoint list in Power Apps using various conditions.

In this article, we will learn how to filter SharePoint Online list in Power Apps based on various columns and logical operators with examples.

Table of Contents

Filter SharePoint List in Power Apps

Let’s take a simple scenario.

I have created a SharePoint Online list named “Product Order Details” with different fields.

Column NameData Type
Product NameIt is a default single line of text
PriceCurrency
QuantityNumber
Order DateOrder Date
Delivery DateDelivery Date
powerapps filter sharepoint list

Now, I would like to filter the SharePoint Online list using the Power Apps filter conditions based on the different columns and display the filtered records on the Data table control or Gallery control.

Now, let me discuss how to work with Power Apps filter SharePoint list using different columns [Text, Choice, Person, Number, Lookup, Date and time, etc…]

1. Power Apps Filter SharePoint List Using Text Column

In Power Apps, there is a Data table control that retrieves the data from the SharePoint list [Product Order Details].

Now, I want to filter the data table and display each record from the SharePoint Online list based on the Text column value [“Mobile”].

filter sharepoint list powerapps

For that, on the Power Apps Screen -> Insert a Data table and set its Items property to the code below.

Items = Filter(
    'Product Order Details',
    Title = "Mobile"
)

Where,

  • ‘Product Order Details’ = SharePoint Online list
PowerApps Filter SharePoint List

Have a look at the below screenshot for the output:

Power Apps Filter SharePoint List

Filter SharePoint Text Column Using StartsWith()

Suppose you want to filter the SharePoint text column with the StartsWith function in Power Apps; follow the code below.

Items = Filter(
    'Product Order Details',
    StartsWith(
        Title,
        "Laptop"
    )
)

Output:

How to Filter SharePoint Online List in Power Apps

Filter SharePoint Text Column Using EndsWith()

Similarly, you can filter the SharePoint Online list text column using the EndsWith function in Power Apps. For that, you can follow the below code.

Items = Filter(
    'Product Order Details',
    EndsWith(
        Title,
        "Camera"
    )
)

Output:

How to Filter SharePoint Online List in PowerApps

Filter SharePoint Text Column Using Text input

In Power Apps, there is a Text input control and a Data table control. Whenever a user enters or provides the Text column value, the data table filters and displays each record from the SharePoint list based on the text input value.

See also  How to remove Power Apps form from SharePoint list?

To do so, set the Data table’s Items property to the code below.

Items = Filter(
    'Product Order Details',
    Title = txt_ProductName.Text
)

Where,

  • txt_ProductName = Power Apps text input name

Output:

How to Filter SharePoint List in Power Apps

This is how we can filter the SharePoint text field in Power Apps.

2. Power Apps Filter SharePoint List Using Date Column

Next, I will show you how to filter the SharePoint list date and time column using different filter conditions in Power Apps. Such as:

Filter SharePoint List using Date Column By Current Date

I will also take the above SharePoint Online [Product Order Details] for this example. Now, I need to display only today’s or current-day records on the Power Apps data table.

For that, you can use the below code for the Data table’s Items property.

Items = Filter(
    'Product Order Details',
    'Order Date' = Today()
)

Where,

  • ‘Order Date’ = SharePoint date and time field

Output:

How to Filter SharePoint List in PowerApps

Filter SharePoint List using Date Column Between Two Dates

You can also filter the SharePoint list date column between two dates [Order Date and Delivery Date]. For that, follow the below code.

Items = Filter(
    'Product Order Details',
    OrderDate>= Date(2024,3,19),
    DeliveryDate <= Date(2024,3,27)
)

Output:

How to Filter a SharePoint Online List in PowerApps

Filter SharePoint List using Date Column By Add Or Subtract Days

Let me show you how to filter the SharePoint date and time column by adding or subtracting days. To achieve this, you can use the code below.

Items = Filter(
    'Product Order Details',
    OrderDate = Today() + 2                //For adding days
)


Filter(
    'Product Order Details',
    OrderDate = Today() -5               //For subtracting days
)

Output:

Filter SharePoint List in Power Apps

Filter SharePoint List using Date Column By Selected Date

If you want to filter the SharePoint date column by a selected date, you can add a date picker and filter the data table based on the date picker’s selected date.

To achieve it, follow the below code:

Items = Filter(
    'Product Order Details',
    'Order Date' = dte_SelectDate.SelectedDate
)

Where,

  • dte_SelectDate = Power Apps date picker name
How to Filter a SharePoint List in PowerApps

Whenever the user selects a specific date, the data table filters and displays each record from the SharePoint list based on that date.

Have a look at the below screenshot for the output.

How to Filter a SharePoint List in Power Apps

Filter SharePoint List using Date Column By Date Range

In this example, I will show you how to filter the SharePoint list date column by date range using two date pickers [dte_Orderdate and dte_DeliveryDate].

To do so, you can use the below code for the Data table’s Items property:

Items = Filter(
    'Product Order Details',
    OrderDate >= dte_OrderDate.SelectedDate,
    DeliveryDate <= dte_DeliveryDate.SelectedDate
)

Output:

How to Filter a SharePoint Online List in Power Apps

3. Power Apps Filter SharePoint List Using Number Column

Now, I would like to show you how to filter the SharePoint list number column using different filter conditions. Such as:

See also  Power Apps Data Table Default Select Row

Filter SharePoint Number Column Does Equals

Suppose you want to filter the SharePoint number column value as equal to the specific number, you can follow the below code.

Items = Filter(
    'Product Order Details',
    Quantity = 5                                  //you can change the number
)

Where,

  • Quantity = SharePoint number column

Output:

Filter SharePoint List in PowerApps

Filter SharePoint Number Column Does Not Equal

Likewise, follow the below code to filter the SharePoint number column that does not equal the specific number.

Items = Filter(
    'Product Order Details',
    Quantity <> 10
)

Output:

Filter SharePoint Online List in Power Apps

Filter SharePoint Number Column is Between Two Numbers

Suppose I would like to filter the SharePoint number column based on the two numbers in Power Apps. In this case, we can use the below code.

Items = Filter(
    'Product Order Details',
    Quantity >= 3 And Quantity <=7
)

Output:

Power Apps Filter SharePoint List using a Number Column

Filter SharePoint Number Column is Greater Than Or Less Than

You can also filter the SharePoint number column that is greater than or less than a specific value. For that, follow the below code.

Items = Filter(
    'Product Order Details',
    Quantity > 3                                        //For greater values
)

Filter(
    'Product Order Details',
    Quantity <5                                      //For less values
)

Output:

PowerApps Filter SharePoint List

Filter SharePoint Number Column is Greater Than Or Equals To/Less Than Or Equals To

Similarly, if you want to filter the SharePoint number field that is greater than or equals/less than or equals a specific value, you can follow the code below.

Filter(
    'Product Order Details',
    Quantity >= 5                                        //For Greater Than Or Equals Values
)

Filter(
    'Product Order Details',
    Quantity <= 5                                      //For Less Than Or Equals Values
)

Output:

PowerApps Filter SharePoint List using Number Column
Note:  Whenever you want to filter the SharePoint Online list by "Currency column", you can follow the above examples [Number column Filter condition applicable for Currency column as well].

4. Power Apps Filter SharePoint List Using Choice Column

For this example, I have taken another SharePoint Online list named “Travel Requests,” which contains the fields below.

Column NameData Type
Trip TitleIt is a default single line of text
AirlineChoice
Travel Start DateDate and time
Travel End DateDate and time
RequesterRequester
Estimated AirfareEstimated Airfare
Power Apps Filter SharePoint List Using Choice Column

Now, I would like to filter the SharePoint Choice field based on the specific value [Alaska Air] and display the filtered records on the gallery control. The output is shown in the screenshot below.

Output:

PowerApps Filter SharePoint List Using Choice Column

To work around this, follow the steps below. Such as:

1. On the Power Apps Screen -> Insert a Gallery control and set its Items property to the code below.

Items = Filter(
    'Travel Requests',
    Airline.Value = "Alaska Air"
)

Where,

  • ‘Travel Requests’ = SharePoint Online List
  • Airline = SharePoint Choice Field
  • “Alaska Air” = Choice Field Value
Power Apps filter from SharePoint list

2. Once your app is ready, Save, Publish, and Preview the app. The gallery displays filtered records based on the choice field value, as shown below.

filter the sharepoint list in powerapps

Filter SharePoint Choice Column By Dropdown

Let’s see how to filter the SharePoint choice field by dropdown. To achieve it, follow the below steps.

1. On the Power Apps screen -> Insert a Dropdown control and set its Items property to the code below.

Items = Choices([@'Travel Requests'].Airline)
how to filter sharepoint list in powerapps

2. Then, insert a Gallery control and set Its Items property as:

Items = Filter(
    'Travel Requests',
    Airline.Value = drp_Airlene.Selected.Value
)

Where,

  • drp_Airlene = Power Apps Drodown Value
how to filter a sharepoint list in powerapps

3. Whenever the user selects any value from the dropdown control, the gallery displays filtered records based on the selected choice value.

Refer to the below screenshot:

how to filter sharepoint list in the powerapps

5. Power Apps Filter SharePoint List Using Person Column

Here, we will discuss the powerapps filter sharepoint list by person column using different filter conditions. Such as:

See also  PowerApps repeating table

Filter SharePoint List Person Field By Current User

To get the current user records in the Power Apps based on the SharePoint list person field, you can use the code below.

Items = Filter(
    'Travel Requests',
    'Requested By'.DisplayName = User().FullName
)


                                                               OR

Filter(
    'Travel Requests',
    User().Email exactin Requester.Email
)

Where,

  • ‘Requested By’ = SharePoint Person or Group column name

Output:

Power Apps Filter SharePoint List Using Person Column

Filter SharePoint List Person Field By User Name/Email

We can filter the SharePoint list person field using a specific user’s name or email. To do so, follow the below given code.

Items = Filter(
    'Travel Requests',
    'Requested By'.Email = "PattiF@szg52.onmicrosoft.com"
)

                                                                 OR

Filter(
    'Travel Requests',
  "PattiF@szg52.onmicrosoft.com" exactin 'Requested By'.Email
)

Output:

PowerApps Filter SharePoint List Using Person Field

Filter SharePoint List Person Field By User Department/JobTitle

Also, if you want to filter the SharePoint list person column using user Department or Job Title, follow the code below.

Items = Filter(
    'Travel Requests',
    'Requested By'.Email = "PattiF@szg52.onmicrosoft.com"
)

Text = ThisItem.'Requested By'.Department
Power Apps Filter SharePoint List Using Person Field

Have a look at the below screenshot for the output:

Output:

How to Filter SharePoint List Using Person Field in PowerApps

6. Power Apps Filter SharePoint List Using Yes/No Column

In this example, I will discuss how to filter the SharePoint list Yes/No column with two different filter conditions. Such as:

Filter SharePoint List Yes/No Column Equals “Yes” Value

If you want to display only approved records [True values] on the Power Apps gallery control, you can follow the code below.

Items = Filter(
    'Travel Requests',
    Approved=true
)

Where,

  • Approved = SharePoint Yes/No filed

Output:

Power Apps Filter SharePoint List Using Yes No Column

Filter SharePoint List Yes/No Column Equals “No” Value

If you want to display not approved records [False values] on the Power Apps gallery control, you can follow the code below.

Items = Filter(
    'Travel Requests',
    Approved=false
)

Output:

PowerApps Filter SharePoint List Using Yes No Column

7. Power Apps Filter SharePoint List Using Lookup Column

Let’s see how to filter the Power Apps SharePoint list by lookup column with a simple scenario:

Scenario:

I have a SharePoint Online List named [Patient Tracker] and this list contains the below fields.

Destination List:

Column NameData Type
Patient IDIt is a default single line of text
Patient NameA single line of text
Date Of BirthDate of Birth
DiseaseLookup
Power Apps Filter SharePoint List Using Lookup Column

This SharePoint lookup column [Disease] is added from another SharePoint source list named “Diseases List“. This list contains the below fields.

Column NameData Type
DiseaseIt is a default single line of text
Doctor’s NameA single line of text
Doctor’s FeesCurrency
Doctor’s ExperienceNumber
PowerApps Filter SharePoint List Using Lookup Column

Now, I would like to filter the SharePoint lookup field and display filtered records on the data table in two different ways. Such as:

Filter SharePoint Lookup Field Equals a Specific Value

You can follow the code below whenever you want to filter the SharePoint list records by a specific lookup filed value.

Items = Filter(
    'Patient Tracker',
    Disease.Value = "Malaria"                      //You can change lookup field value
)

Where,

  • Disease = SharePoint lookup field

Output:

Power Apps Filter SharePoint List Using Lookup Field

Filter SharePoint Lookup Field By Radio Button

Let me show you how to filter the SharePoint Lookup field by radio button. To achieve this, follow the below steps.

1. On the Power Apps Screen -> Insert a Radio button and set its Items property to the code below.

Items = 'Diseases List'.Title

Where,

  • Diseases List’ = SharePoint source list
PowerApps Filter SharePoint List Using Lookup Field

2. Then, insert a Data table control and set its Items property as:

Items = Filter(
    'Patient Tracker',
    Disease.Value = rdo_Diseases.Selected.Disease
)
How to Filter SharePoint List Using Lookup Field in PowerApps

3. Now, when a user selects any lookup field value from the radio button control, the data table displays filtered records, as in the screenshot below.

Output:

How to Filter SharePoint List Using Lookup Field in Power Apps

Filter SharePoint Lookup Field By ID

In this example, I will show you how to filter the SharePoint Online list lookup column by ID using the code below.

Items = Filter(
    'Patient Tracker',
    Disease.Id=5                        //You can change the ID name
)

Output:

How to Filter the SharePoint List Using Lookup Field in Power Apps
Note: PowerApps is not supported with the SharePoint "Calculated column", "Hyperlink Column", "Image column", and "List views" to filter the SharePoint Online list.

Power Apps Filter SharePoint Online List By Logical Operators

Finally, I will show you how to filter the SharePoint Online list by different logical operators. Such as:

Filter SharePoint Online List By “Not” Logical Operator

You can use the code below to filter the SharePoint list by the “Not” logical operator.

Items = Filter(
    'Product Order Details',
   Not Title = "Mobile"                             //You can change the text value
)

                     OR 

Filter(
    'Product Order Details',
    Title <> "Mobile"                      
)

Output:

Power Apps Filter SharePoint Online List By Logical Operators

Filter SharePoint Online List By “And” Logical Operator

Here, I will show you how to to filter the SharePoint list by the “And” logical operator using the below code.

Items = Filter(
    'Product Order Details',
    Title = "Laptop" And Quantity >= 2
)

Output:

PowerApps Filter SharePoint Online List By Logical Operators

Filter SharePoint Online List By “OR” Logical Operator

Next, we will see how to to filter the SharePoint list by the “OR” logical operator using the below code.

Items = Filter(
    'Product Order Details',
    Title = "Mobile" Or Quantity > 5
)

Output:

PowerApps Filter SharePoint Online List Using Logical Operators

Filter SharePoint Online List By Multiple Logical Operators

In the last, I will show you how to filter the SharePoint list by multiple logical operators. For that, you can follow the code below.

Items = Filter(
    'Product Order Details',
    Title = "Laptop" And Quantity > 4 Or Title="Laptop"
)

Output:

Power Apps Filter SharePoint Online List Using Logical Operators

This is how we can filter the SharePoint list using different columns and different logical operators in Power Apps.

I trust this tutorial is useful for you. If you have any requirements related to the Power Apps filter SharePoint Online list, you can easily do it by following the above examples.

Also, you may like:

  • This page was very informative, but downloading the data into a collection in chunks from SP list doesn’t work using the ID column.

  • >