23 Power Apps Filter Function Examples For SharePoint

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/power-apps-filter-functions-examples/. Author: Matthew Devaney.

23 Power Apps Filter Function Examples For SharePoint Posted by - Matthew Devaney on - March 26, 2023 25 Comments

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 ID Title Manufacturer 1 Dishwasher LG 2 Freezer Samsung 3 Kitchen Faucet Kohler 4 Kitchen Sink American Standard 5 Refrigerator Samsung 6 Stove Code:

Get records where the Manufacturer column equals Samsung

Filter(Inventory, Manufacturer = "Samsung" ) Code language: JavaScript ( javascript ) Output: ID Title Manufacturer 2 Freezer Samsung 5 Refrigerator Samsung Text Column Starts With Input: Inventory SharePoint List ID Title Manufacturer 1 Dishwasher LG 2 Freezer Samsung 3 Kitchen Faucet Kohler 4 Kitchen Sink American Standard 5 Refrigerator Samsung 6 Stove Code:

Get records where the Title column starts with “Kitchen”

Filter(Inventory, StartsWith(Title, "Kitchen" )) Code language: JavaScript ( javascript ) Output: ID Title Manufacturer 3 Kitchen Faucet Kohler 4 Kitchen Sink American Standard Text Column Is Blank Input: Inventory SharePoint List ID Title Manufacturer 1 Dishwasher LG 2 Freezer Samsung 3 Kitchen Faucet Kohler 4 Kitchen Sink American Standard 5 Refrigerator Samsung 6 Stove Code:

Get records where the Manufacturer column is blank Filter(Inventory, Manufacturer=Blank()) Output: ID Title Manufacturer 6 Stove

Filter A SharePoint Number Column In Power Apps

Number Column Is Greater Than Or Less Than Input: Inventory SharePoint List ID Title InStock 1 Dishwasher 9 2 Freezer 14 3 Kitchen Faucet 7 4 Kitchen Sink 10 5 Refrigerator 15 6 Stove 13 Code:

Get records where the InStock column is greater than 10 Filter(Inventory, InStock > 10) Output: ID Title InStock 2 Freezer 14 5 Refrigerator 15 6 Stove 13

Number Column Is Greater Than Or Equal To/Less Than Or Equal To Input: Inventory SharePoint List ID Title InStock 1 Dishwasher 9 2 Freezer 14 3 Kitchen Faucet 7 4 Kitchen Sink 10 5 Refrigerator 15 6 Stove 13 Code:

Get records where the InStock column is less than or equal to 10 Filter(Inventory, InStock <= 10) Output: ID Title InStock 1 Dishwasher 9 3 Kitchen Faucet 7 4 Kitchen Sink 10 Number Column Does Not Equal Input: Inventory SharePoint List ID Title InStock 1 Dishwasher 9 2 Freezer 14 3 Kitchen Faucet 7 4 Kitchen Sink 10 5 Refrigerator 15 6 Stove 13 Code:

Get records where the InStock column does not equal 9 Filter(Inventory, InStock <> 9) Code language: HTML, XML ( xml ) Output: ID Title InStock 2 Freezer 14 3 Kitchen Faucet 7 4 Kitchen Sink 10 5 Refrigerator 15 6 Stove 13 Number Column Is Between Two Values Input: Inventory SharePoint List ID Title InStock 1 Dishwasher 9 2 Freezer 14 3 Kitchen Faucet 7 4 Kitchen Sink 10 5 Refrigerator 15 6 Stove 13 Code:

Get records where the InStock column is between 5 and 10

Filter(Inventory, InStock >= 5 And InStock <= 10) Output: ID Title InStock 1 Dishwasher 9 3 Kitchen Faucet 7 4 Kitchen Sink 10

Filter A SharePoint Date Column In Power Apps Date Column Equals Current Date Input: Inventory SharePoint List ID Title LastSoldDate 1 Dishwasher 2/16/2023 2 Freezer 2/18/2023 3 Kitchen Faucet 3/1/2023 4 Kitchen Sink 3/4/2023 5 Refrigerator 2/23/2023 6 Stove 3/6/2023 Code:

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

Filter(Inventory, LastSoldDate = Today()) Output: ID Title LastSoldDate 6 Stove 3/6/2023 Date Column Equals A Specific Date Input: Inventory SharePoint List ID Title LastSoldDate 1 Dishwasher 2/16/2023 2 Freezer 2/18/2023 3 Kitchen Faucet 3/1/2023 4 Kitchen Sink 3/4/2023 5 Refrigerator 2/23/2023 6 Stove 3/6/2023 Code:

Get records where the LastSoldDate column equals March 1, 2023

Filter( Inventory, LastSoldDate = Date ( 2023 , 3 , 1 ) ) Code language: JavaScript ( javascript ) Output: ID Title LastSoldDate 3 Kitchen Faucet 3/1/2023 Date Column Is Between Two Dates Input: Inventory SharePoint List ID Title LastSoldDate 1 Dishwasher 2/16/2023 2 Freezer 2/18/2023 3 Kitchen Faucet 3/1/2023 4 Kitchen Sink 3/4/2023 5 Refrigerator 2/23/2023 6 Stove 3/6/2023 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 ) ) Code language: JavaScript ( javascript ) Output: ID Title LastSoldDate 6 Stove 3/6/2023 Date Columns Date Range Includes Date Input: Inventory SharePoint List ID Title PromotionStartDate PromotionEndDate 1 Dishwasher 2/14/2023 2/28/2023 2 Freezer 2/20/2023 3/5/2023 3 Kitchen Faucet 2/24/2023 3/17/2023 4 Kitchen Sink 3/11/2023 3/18/2023 5 Refrigerator 3/15/2023 3/31/2023 6 Stove 3/17/2023 4/2/2023 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 ) ) Code language: JavaScript ( javascript ) Output: ID Title PromotionStartDate PromotionEndDate 2 Freezer 2/20/2023 3/5/2023 3 Kitchen Faucet 2/24/2023 3/17/2023

Filter A SharePoint Yes/No Column In Power Apps Yes/No Column Equals Yes Input: Inventory SharePoint List ID Title OnSale 1 Dishwasher Yes 2 Freezer No 3 Kitchen Faucet No 4 Kitchen Sink No 5 Refrigerator Yes 6 Stove No Code:

Get records where the OnSale column equals Yes Filter(Inventory, OnSale = true ) Code language: JavaScript ( javascript ) Output: ID Title OnSale 1 Dishwasher Yes 5 Refrigerator Yes Yes/No Column Equals No Input: Inventory SharePoint List ID Title OnSale 1 Dishwasher Yes 2 Freezer No 3 Kitchen Faucet No 4 Kitchen Sink No 5 Refrigerator Yes 6 Stove No Code:

Get records where the OnSale column equals No Filter(Inventory, OnSale = false ) Code language: JavaScript ( javascript ) Output: ID Title OnSale 2 Freezer No 3 Kitchen Faucet No 4 Kitchen Sink No 6 Stove No

Filter A SharePoint Choice Column In Power Apps Choice Column Equals Input: Inventory SharePoint List ID Title OrderStatus 1 Dishwasher Ordered 2 Freezer Ordered 3 Kitchen Faucet Not Ordered 4 Kitchen Sink Discontinued 5 Refrigerator Ordered 6 Stove Not Ordered Code:

Get records where the OrderStatus column equals “Ordered”

Filter(Inventory, OrderStatus.Value = "Ordered" ) Code language: JavaScript ( javascript ) Output: ID Title OrderStatus 1 Dishwasher Ordered 2 Freezer Ordered 5 Refrigerator Ordered

Filter A SharePoint LookUp Column In Power Apps LookUp Column ID Equals Input: Inventory SharePoint List ID Title Manufacturer 1 Dishwasher LG 2 Freezer Samsung 3 Kitchen Faucet Kohler 4 Kitchen Sink American Standard 5 Refrigerator Samsung 6 Stove Manufacturers SharePoint List ID Title 1 LG 2 Samsung 3 Kohler 4 American Standard Code:

Get records from the Inventory table where the Manufacturer column ID equals 2 Filter(Inventory, Manufacturer.ID = 2) Output: ID Title Manufacturer 2 Freezer Samsung 5 Refrigerator Samsung LookUp Column Value Equals Input: Inventory SharePoint List ID Title Manufacturer 1 Dishwasher LG 2 Freezer Samsung 3 Kitchen Faucet Kohler 4 Kitchen Sink American Standard 5 Refrigerator Samsung 6 Stove Manufacturers SharePoint List ID Title 1 LG 2 Samsung 3 Kohler 4 American Standard Code:

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

Filter(Inventory, Manufacturer.Value = "Kohler" ) Code language: JavaScript ( javascript ) Output: ID Title Manufacturer 3 Kitchen Faucet Kohler

Filter A SharePoint Person Column In Power Apps Person Column Equals Current User Input: Inventory SharePoint List ID Title Buyer 1 Dishwasher Matthew Devaney 2 Freezer Sarah Green 3 Kitchen Faucet Matthew Devaney 4 Kitchen Sink David Johnson 5 Refrigerator David Johnson 6 Stove Alice Lemon 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: ID Title Manufacturer 1 Dishwasher Matthew Devaney 3 Kitchen Faucet Matthew Devaney Person Column Equals User Name Input: Inventory SharePoint List ID Title Buyer 1 Dishwasher Matthew Devaney 2 Freezer Sarah Green 3 Kitchen Faucet Matthew Devaney 4 Kitchen Sink David Johnson 5 Refrigerator David Johnson 6 Stove Alice Lemon Code:

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

Filter(Inventory, Buyer. 'Display Name' = User().Name) Code language: JavaScript ( javascript ) Output: ID Title Manufacturer 2 Freezer Sarah Green Person Column Equals User Email Input: Inventory SharePoint List ID Title Buyer 1 Dishwasher Matthew Devaney 2 Freezer Sarah Green 3 Kitchen Faucet Matthew Devaney 4 Kitchen Sink David Johnson 5 Refrigerator David Johnson 6 Stove Alice Lemon Code:

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

Filter(Inventory, Buyer.Email = " [email protected] " ) Code language: JavaScript ( javascript ) Output: ID Title Manufacturer 4 Kitchen Sink David Johnson 5 Refrigerator David Johnson Additional Examples AND Logical Operator Input: Inventory SharePoint List ID Title Manufacturer OnSale 1 Dishwasher LG Yes 2 Freezer Samsung No 3 Kitchen Faucet Kohler No 4 Kitchen Sink American Standard No 5 Refrigerator Samsung Yes 6 Stove No 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 ) Code language: JavaScript ( javascript ) Output: ID Title Manufacturer OnSale 5 Refrigerator Samsung Yes OR Logical Operator Input: Inventory SharePoint List ID Title Manufacturer OnSale 1 Dishwasher LG Yes 2 Freezer Samsung No 3 Kitchen Faucet Kohler No 4 Kitchen Sink American Standard No 5 Refrigerator Samsung Yes 6 Stove No 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 ) Code language: JavaScript ( javascript ) Output: ID Title Manufacturer OnSale 1 Dishwasher LG Yes 2 Freezer Samsung No 5 Refrigerator Samsung Yes NOT Logical Operator Input: Inventory SharePoint List ID Title Manufacturer OnSale 1 Dishwasher LG Yes 2 Freezer Samsung No 3 Kitchen Faucet Kohler No 4 Kitchen Sink American Standard No 5 Refrigerator Samsung Yes 6 Stove No Code:

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

Filter(Inventory, Not Manufacturer= "LG" ) Code language: JavaScript ( javascript )

Important note: the NOT operator does not support delegation. Use the <> equals operator instead. Output: ID Title Manufacturer OnSale 2 Freezer Samsung No 3 Kitchen Faucet Kohler No 4 Kitchen Sink American Standard No 5 Refrigerator Samsung Yes 6 Stove No Multiple Logical Operators Input: Inventory SharePoint List ID Title Manufacturer OnSale 1 Dishwasher LG Yes 2 Freezer Samsung No 3 Kitchen Faucet Kohler No 4 Kitchen Sink American Standard No 5 Refrigerator Samsung Yes 6 Stove No 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" ) Code language: JavaScript ( javascript ) Output: ID Title Manufacturer OnSale 1 Dishwasher LG Yes 5 Refrigerator Samsung Yes Did You Enjoy This Article? 😺

Subscribe to get new Copilot Studio articles sent to your inbox each week for FREE Enter your email address Sign Me Up 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. Matthew Devaney M365 Copilot Power Apps

How To Create Copilot Custom UI Widgets In Power Apps