23 Power Apps Filter Function Examples For SharePoint

The Power Apps Filter function checks a table for any records matching a set of logical criteria. Then it extracts the results into a new table. Use these examples to help you filter a SharePoint list. All of the filter functions on this page support delegation so the full results set will be returned.

Table of Contents

• Filter A SharePoint Text Column In Power Apps
  ◦ Text Column Equals
  ◦ Text Column Starts With
  ◦ Text Column Is Blank

• Filter A SharePoint Number Column In Power Apps
  ◦ Number Column Is Greater Than Or Less Than
  ◦ Number Column Is Greater Than Or Equal To/Less Than Or Equal To
  ◦ Number Column Does Not Equal
  ◦ Number Column Is Between Two Values

• Filter A SharePoint Date Column In Power Apps
  ◦ Date Column Equals Current Date
  ◦ Date Column Equals A Specific Date
  ◦ Date Column Is Between Two Dates
  ◦ Date Columns Date Range Includes Date

• Filter A SharePoint Yes/No Column In Power Apps
  ◦ Yes/No Column Equals Yes
  ◦ Yes/No Column Equals No

• Filter A SharePoint Choice Column In Power Apps
  ◦ Choice Column Equals

• Filter A SharePoint LookUp Column In Power Apps
  ◦ LookUp Column ID Equals
  ◦ LookUp Column Value Equals

• Filter A SharePoint Person Column In Power Apps
  ◦ Person Column Equals Current User
  ◦ Person Column Equals User Name
  ◦ Person Column Equals User Email

• Additional Examples
  ◦ AND Logical Operator
  ◦ OR Logical Operator
  ◦ NOT Logical Operator
  ◦ Multiple Logical Operators

Filter A SharePoint Text Column In Power Apps

Text Column Equals

Input:

Inventory SharePoint List

Code:

Get records where the Manufacturer column equals Samsung

Filter(Inventory, Manufacturer ="Samsung")

Output:

Text Column Starts With

Input:

Inventory SharePoint List

Code:

Get records where the Title column starts with “Kitchen”

Filter(Inventory, StartsWith(Title, "Kitchen"))

Output:

Text Column Is Blank

Input:

Inventory SharePoint List

Code:

Get records where the Manufacturer column is blank

Filter(Inventory, Manufacturer=Blank())

Output:

Filter A SharePoint Number Column In Power Apps

Number Column Is Greater Than Or Less Than

Input:

Inventory SharePoint List

Code:

Get records where the InStock column is greater than 10

Filter(Inventory, InStock > 10)

Output:

Number Column Is Greater Than Or Equal To/Less Than Or Equal To

Input:

Inventory SharePoint List

Code:

Get records where the InStock column is less than or equal to 10

Filter(Inventory, InStock <= 10)

Output:

Number Column Does Not Equal

Input:

Inventory SharePoint List

Code:

Get records where the InStock column does not equal 9

Filter(Inventory, InStock <> 9)

Output:

Number Column Is Between Two Values

Input:

Inventory SharePoint List

Code:

Get records where the InStock column is between 5 and 10

Filter(Inventory, InStock >= 5 And InStock <= 10)

Output:

Filter A SharePoint Date Column In Power Apps

Date Column Equals Current Date

Input:

Inventory SharePoint List

Code:

Assuming the current date is March 6, 2023, get records where the LastSoldDate column equals today

Filter(Inventory, LastSoldDate = Today())

Output:

Date Column Equals A Specific Date

Input:

Inventory SharePoint List

Code:

Get records where the LastSoldDate column equals March 1, 2023

Filter(
    Inventory,
    LastSoldDate = Date(2023, 3, 1)
)

Output:

Date Column Is Between Two Dates

Input:

Inventory SharePoint List

Code:

Get records where the LastSoldDate column is between March 1, 2023 and March 31, 2023

Filter(
    Inventory,
    LastSoldDate >= Date(2023, 3, 1)
    And LastSoldDate <= Date(2023, 3, 31)
)

Output:

Date Columns Date Range Includes Date

Input:

Inventory SharePoint List

Code:

Get records where the PromotionStartDate column and the PromotionEndDate column includes March 1, 2023

Filter(
    Inventory,
    PromotionStartDate <= Date(2023, 3, 1)
    And PromotionEndDate >= Date(2023, 3, 1)
)

Output:

Filter A SharePoint Yes/No Column In Power Apps

Yes/No Column Equals Yes

Input:

Inventory SharePoint List

Code:

Get records where the OnSale column equals Yes

Filter(Inventory, OnSale = true)

Output:

Yes/No Column Equals No

Input:

Inventory SharePoint List

Code:

Get records where the OnSale column equals No

Filter(Inventory, OnSale = false)

Output:

Filter A SharePoint Choice Column In Power Apps

Choice Column Equals

Input:

Inventory SharePoint List

Code:

Get records where the OrderStatus column equals “Ordered”

Filter(Inventory, OrderStatus.Value = "Ordered")

Output:

Filter A SharePoint LookUp Column In Power Apps

LookUp Column ID Equals

Input:

Inventory SharePoint List

Manufacturers SharePoint List

Code:

Get records from the Inventory table where the Manufacturer column ID equals 2

Filter(Inventory, Manufacturer.ID = 2)

Output:

LookUp Column Value Equals

Input:

Inventory SharePoint List

Manufacturers SharePoint List

Code:

Get records from the Inventory table where the Manufacturer column value equals “Kohler”

Filter(Inventory, Manufacturer.Value = "Kohler")

Output:

Filter A SharePoint Person Column In Power Apps

Person Column Equals Current User

Input:

Inventory SharePoint List

Code:

Assuming the current user is Matthew Devaney, get records from the Inventory table where the Buyer column equals the current user

Filter(Inventory, Buyer.Email = User().Email)

Output:

Person Column Equals User Name

Input:

Inventory SharePoint List

Code:

Get records from the Inventory table where the Buyer column user name equals “Sarah Green”

Filter(Inventory, Buyer.'Display Name' = User().Name)

Output:

Person Column Equals User Email

Input:

Inventory SharePoint List

Code:

Get records from the Inventory table where the Buyer column email [email protected]

Filter(Inventory, Buyer.Email = "[email protected]")

Output:

Additional Examples

AND Logical Operator

Input:

Inventory SharePoint List

Code:

Get records from the Inventory table where the manufacturer column “Samsung” and the OnSale column equals Yes.

Filter(Inventory, Manufacturer="Samsung" And OnSale = true)

Output:

OR Logical Operator

Input:

Inventory SharePoint List

Code:

Get records from the Inventory table where the manufacturer column “Samsung” or the OnSale column equals Yes.

Filter(Inventory, Manufacturer="Samsung" Or OnSale = true)

Output:

NOT Logical Operator

Input:

Inventory SharePoint List

Code:

Get records from the Inventory table where the manufacturer column is not “LG.”

Filter(Inventory, Not Manufacturer="LG")

Output:

Multiple Logical Operators

Input:

Inventory SharePoint List

Code:

Get records from the Inventory table where the manufacturer column equals “Samsung” and OnSale equals Yes or the manufacturer column equals LG

Filter(Inventory, (Manufacturer="LG" And OnSale="Yes") Or Manufacturer="LG")

Output:

Questions?

If you have any questions or feedback about 23 Power Apps Filter Function Examples For SharePoint please leave a message in the comments section below. You can post using your email address and are not required to create an account to join the discussion.