Filter Function For SharePoint List in Power apps

Requirement: Powerapps Filter function for Sharepoint list.

Create SharePoint list “Filter Function list”. Add fields to the list as shown in below:

• Title: Text field
• Products: Text field
• Number: Number field
• Manufacture Date: date and Time field
• Varent: date and Time field
• Purchased: Yes/No
• Status: Choice field
• Seller: People picker

Use the Filter function for the specific requirement as shown in below:

Filter A SharePoint Text Column In Power Apps

Text Column Equals-Filter(DataSource, Products ="Samsung")
Text Column Starts With-Filter(DataSource, Title="Amal")
Text Column Is Blank-Filter(DataSource, Products=Blank())

Filter A SharePoint Number Column In Power Apps

Number Column Is Greater Than Or Less Than-Filter(DataSource, Number > 10)
Number Column Is Greater Than/Less Than-Filter(DataSource, Number > 10)
Number Column Is Greater Than Or Equal To/Less Than Or Equal To-Filter(DataSource, Number <= 10)
Number Column Does Not Equal-Filter(DataSource, Number <> 9)
Number Column Is Between Two Values-Filter(DataSource, Number >= 5 And Number <= 10)

Filter A SharePoint Date Column In Power Apps

Date Column Equals Current Date-Filter(DataSource, Manufacture Date = Today())
Date Column Equals A Specific Date-Filter(DataSource, Manufacture Date>= Date(2023, 3, 1) And Manufacture Date <= Date(2023, 3, 31)
Date Column Is Between Two Dates-Filter(DataSource, Manufacture Date >= Date(2023, 3, 1) And Manufacture Date <= Date(2023, 3, 31)
Date Columns Date Range Includes Date-Filter(DataSource, Varent <= Date(2023, 3, 1) And Varent >= Date(2023, 3, 1)

Filter A SharePoint Yes/No Column In Power Apps

Yes/No Column Equals Yes-Filter(DataSource, Purchased = true)
Yes/No Column Equals No-Filter(DataSource, Purchased = false)

Filter A SharePoint Choice Column In Power Apps

Choice Column Equals-Filter(DataSource, Status.Value = "Ordered")

Filter A SharePoint LookUp Column In Power Apps

LookUp Column ID Equals-Filter(DataSource, Products.ID = 2)
LookUp Column Value Equals-Filter(DataSource, Products.Value = "Jhon Francis")

Filter A SharePoint Person Column In Power Apps

Person Column Equals Current User-Filter(DataSource, Seller.Email = User().Email)
Person Column Equals User Name-Filter(DataSource, Seller.'Display Name' = User().Name)
Person Column Equals User Email-Filter(DataSource, Seller.Email = "michael@rishansolutions.com")

Additional Examples

AND Logical Operator-Filter(DataSource, Products="Samsung" And Purchased = true)
OR Logical Operator-Filter(DataSource, Products="Samsung" Or Purchased = true)
NOT Logical Operator-Filter(DataSource, Not Products="Iphone")
Multiple Logical Operators-Filter(DataSource, (Products="Iphone" And Purchased="Yes") Or Products="Iphone")

The Above 23 Filter functions are used in Power apps for SharePoint list.