25 Power Apps IF Function Examples

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

25 Power Apps IF Function Examples Posted by - Matthew Devaney on - July 9, 2023 25 Comments

The Power Apps IF Function performs a logical comparison to see if the result is true. Then it conditionally executes the next lines of code based on whether the result was true or false. The examples on this page show how the Power Apps IF Function works for every data type.

Important note: for most examples the IF Function the 2nd argument is true and the 3rd argument is false . These true and false values are only placeholders. They should be replaced with your own code in the real-world. Table of Contents IF Function Text Examples In Power Apps IF Text Value Equals IF Text Value Contains IF Text Value StartsWith IF Text Value Is Blank

IF Text Value Equals With Multiple Conditions

IF Function Number Examples In Power Apps

IF Number Value Is Greater Than Or Less Than

IF Number Value Is Greater Than Or Equal To/Less Than Or Equal To IF Number Value Does Not Equal IF Number Value Is Between Two Values

IF Number Is Found Within A Range (Multiple Conditions) IF Function Date Examples In Power Apps IF Date Value Equals Current Date IF Date Value Equals A Specific Date IF Date Value Is Between Two Dates

“>IF Function Boolean Examples In Power Apps IF Boolean Value Equals true IF Boolean Value Equals false

IF Function Choice Column Examples In Power Apps IF Choice Column Value Equals

IF Function LookUp Column Examples In Power Apps IF LookUp Column ID Equals IF LookUp Column Value Equals

“>IF Function Person Column Examples In Power Apps IF Person Column Equals Current User IF Person Column Equals User Name “>IF Person Column Equals User Email

Additional IF Function Examples For Power Apps IF Condition Using AND Logical Operator IF Condition Using OR Logical Operator IF Condition Using NOT Logical Operator

#IF-Condition-Using-Multiple-Logical-Operators”>IF Condition Using Multiple Logical Operators IF Function Text Examples In Power Apps IF Text Value Equals Input: Set (varManufacturer, "Samsung" ) Code language: JavaScript ( javascript ) Code: Check if varManufacturer equals Samsung

If(varManufacturer = "Samsung" , true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF Text Value Contains Input: Set (varTitle, "Dishwasher" ) Code language: JavaScript ( javascript ) Code: Check if varTitle contains “wash” If( "wash" in varTitle, true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF Text Value StartsWith Input: Set (varTitle, "Kitchen Sink" ) Code language: JavaScript ( javascript ) Code: Check if varTitle starts with “Kitchen”

If(StartsWith(Title, "Kitchen" ), true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF Text Value Is Blank Input: Set (varManufacturer, Blank()) Code language: JavaScript ( javascript ) Code: Check if varManufacturer is blank

If(IsBlank(varManufacturer), true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript )

IF Text Value Equals With Multiple Conditions Input: Set (varTitle, "Kitchen Sink" ) Code language: JavaScript ( javascript ) Code:

Check multiple conditions and return the result where varTitle is equal to “Kitchen Sink” If( varTitle = "Dishwasher" ,

"Dishwasher was found!" , varTitle = "Kitchen Sink" ,

"Kitchen Sink was found!" , varTitle = "Refrigerator" , "Refrigerator was found!" , "No matches found" ) Code language: JavaScript ( javascript ) Output: "Kitchen Sink was found!" Code language: JSON / JSON with Comments ( json )

IF Function Number Examples In Power Apps

IF Number Value Is Greater Than Or Less Than Input: Set (varQuantityInStock, 15 ) Code language: JavaScript ( javascript ) Code:

Check if varQuantityInStock is greater than 10

If(varQuantityInStock > 10 , true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF

Number Value Is Greater Than Or Equal To/Less Than Or Equal To Input: Set (varQuantityInStock, 8 ) Code language: JavaScript ( javascript ) Code:

Check if varQuantityInStock is less than or equal to 10

If(varQuantityInStock <= 10 , true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF Number Value Does Not Equal Input: Set (varQuantityInStock, 2 ) Code language: JavaScript ( javascript ) Code:

Check if varQuantityInStock does not equal 9

If(varQuantityInStock <> 9 , true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF Number Value Is Between Two Values Input: Set (varQuantityInStock, 6 ) Code language: JavaScript ( javascript ) Code:

Check if varQuantityInStock is between 5 and 10 If( varQuantityInStock >= 5 And varQuantityInStock <= 10 , true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript )

IF Number Is Found Within A Range (Multiple Conditions) Input: Set (varQuantityInStock, 5 ) Code language: JavaScript ( javascript ) Code:

Check multiple conditions and return the result where varQuantityInStock is greater than 0 but less than 10. If( varQuantityInStock >= 50 ,

"Too many in stock" , varQuantityInStock >= 10 ,

"Item is in stock" , varQuantityInStock > 0 , "Low inventory, time to re-stock" , "No inventory left" ) Code language: JavaScript ( javascript ) Output: "Low inventory, time to re-stock" Code language: JSON / JSON with Comments ( json ) IF Function Date Examples In Power Apps IF Date Value Equals Current Date Input: Set (varLastSoldDate, Today()) Code language: JavaScript ( javascript ) Code:

Assuming the current date is March 6, 2023, check if varLastSoldDate equals today

If(varLastSoldDate = Today(), true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF Date Value Equals A Specific Date Input:

Set (varLastSoldDate, Date ( 2023 , 3 , 1 )) Code language: JavaScript ( javascript ) Code:

Check if LastSoldDate column equals March 1, 2023

If(varLastSoldDate = Date ( 2023 , 3 , 1 ), true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF Date Value Is Between Two Dates Input:

Set (varLastSoldDate, Date ( 2023 , 3 , 10 )) Code language: JavaScript ( javascript ) Code:

Check if varLastSoldDate is between March 1, 2023 and March 31, 2023

If( varLastSoldDate >= Date ( 2023 , 3 , 1 ) And varLastSoldDate <= Date ( 2023 , 3 , 31 ), true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript )

IF Function Boolean Examples In Power Apps Boolean Value Equals true Input: Set (varOnSale, true ) Code language: JavaScript ( javascript ) Code: Check if varOnSale equals true If(varOnSale, true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF Boolean Value Equals false Input: Set (varOnSale, false ) Code language: JavaScript ( javascript ) Code: Check if varOnSale equals false If(!varOnSale, true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript )

IF Function Choice Column Examples In Power Apps IF Choice Column Value 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

Get the first row in the Inventory SharePoint list where OrderStatus is a Choice type column

Set (varInventoryItem, LookUp(Inventory, ID= 1 )) Code language: JavaScript ( javascript ) Code:

Check if the OrderStatus of varInventoryItem equals “Ordered”

If(varInventoryItem.OrderStatus.Value = "Ordered" , true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript )

IF Function LookUp Column Examples In Power Apps IF 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

Get the 3rd row in the Inventory SharePoint list where Manufacturer is a Lookup type column

Set (varInventoryItem, LookUp(Inventory, ID= 3 )) Code language: JavaScript ( javascript ) Code:

Check if the ID of varInventoryItem equals 3 If(Manufacturer.ID = 3 , true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF 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

Get the 4th row in the Inventory SharePoint list where Manufacturer is a Lookup type column

Set (varInventoryItem, LookUp(Inventory, ID= 4 )) Code language: JavaScript ( javascript ) Code:

Check if the Title of varInventoryItem equals “American Standard”

If(Manufacturer.Value = "American Standard" , true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript )

IF Function Person Column Examples In Power Apps IF 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

Get the first in the Inventory SharePoint list where Buyer is a Person type column

Set (varInventoryItem, LookUp(Inventory, ID= 1 )) Code language: JavaScript ( javascript ) Code:

Assuming the current user is Matthew Devaney, check if the Buyer of varInventoryItem equals the current user

If(varInventoryItem.Buyer.Email = User().Email, true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF 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

Get the 2nd row in the Inventory SharePoint list where Buyer is a Lookup type column

Set (varInventoryItem, LookUp(Inventory, ID= 2 )) Code language: JavaScript ( javascript ) Code:

Check if the Buyer column of varInventoryItem has a user name equal to “Sarah Green”

If(varInventoryItem.Buyer.'Display Name = "Sarah Green", true, false) Output: true Code language: JavaScript ( javascript ) IF 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

Get the 5th row in the Inventory SharePoint list where Buyer is a Person type column

Set (varInventoryItem, LookUp(Inventory, ID= 5 )) Code language: JavaScript ( javascript ) Code:

Check if the Buyer column of varInventoryItem has an email equal to “ [email protected] ”

If(varInventoryItem.Buyer.Email = " [email protected] " ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript )

Additional IF Function Examples For Power Apps IF Condition Using 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

Get the 1st row in the Inventory SharePoint list where Manufacturer is a text column and OnSale is a Yes/No type column

Set (varInventoryItem, LookUp(Inventory, ID= 5 )) Code language: JavaScript ( javascript ) Code:

Check if varInventoryItem has a Manufacturer equal to “Samsung” and an OnSale column equal to Yes.

If( varInventoryItem.Manufacturer= "Samsung" And varInventoryItem.OnSale, true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF Condition Using 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

Get the 2nd row in the Inventory SharePoint list where Manufacturer is a text column and OnSale is a Yes/No type column.

Set (varInventoryItem, LookUp(Inventory, ID= 2 )) Code language: JavaScript ( javascript ) Code:

Check if varInventoryItem has a Manufacturer equal to “Samsung” or an OnSale column equal to Yes.

If( varInventoryItem.Manufacturer= "Samsung" Or varInventoryItem.OnSale, true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) IF Condition Using 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

Get the 3rd row in the Inventory SharePoint list where Manufacturer is a text column and OnSale is a Yes/No type column.

Set (varInventoryItem, LookUp(Inventory, ID= 3 )) Code language: JavaScript ( javascript ) Code:

Check if varInventoryItem has a Manufacturer column not equal to “Samsung”

If(Not(varInventoryItem= "Samsung" ), true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript )

IF Condition Using 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

Get the 1st row in the Inventory SharePoint list where Manufacturer is a text column and OnSale is a Yes/No type column

Set (varInventoryItem, LookUp(Inventory, ID= 1 )) Code language: JavaScript ( javascript ) Code:

Check if varInventoryItem has a Manufacturer column equals “Samsung” and OnSale equals Yes or the Manufacturer column equals “LG”

If( ( varInventoryItem.Manufacturer= "LG" And varInventoryItem.OnSale= "Yes"

) Or varInventoryItem.Manufacturer= "LG" ), true , false ) Code language: JavaScript ( javascript ) Output: true Code language: JavaScript ( javascript ) 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 25 Power Apps IF Function Examples 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