25 Power Apps IF Function Examples

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 Function Text Examples In Power Apps

IF Text Value Equals

Input:

Set(varManufacturer, "Samsung")

Code:

Check if varManufacturer equals Samsung

If(varManufacturer ="Samsung", true, false)

Output:

true

IF Text Value Contains

Input:

Set(varTitle, "Dishwasher")

Code:

Check if varTitle contains “wash”

If("wash" in varTitle, true, false)

Output:

true

IF Text Value StartsWith

Input:

Set(varTitle, "Kitchen Sink")

Code:

Check if varTitle starts with “Kitchen”

If(StartsWith(Title, "Kitchen"), true, false)

Output:

true

IF Text Value Is Blank

Input:

Set(varManufacturer, Blank())

Code:

Check if varManufacturer is blank

If(IsBlank(varManufacturer), true, false)

Output:

true

IF Text Value Equals With Multiple Conditions

Input:

Set(varTitle, "Kitchen Sink")

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"
)

Output:

"Kitchen Sink was found!"

IF Function Number Examples In Power Apps

IF Number Value Is Greater Than Or Less Than

Input:

Set(varQuantityInStock, 15)

Code:

Check if varQuantityInStock is greater than 10

If(varQuantityInStock > 10, true, false)

Output:

true

IF Number Value Is Greater Than Or Equal To/Less Than Or Equal To

Input:

Set(varQuantityInStock, 8)

Code:

Check if varQuantityInStock is less than or equal to 10

If(varQuantityInStock <= 10, true, false)

Output:

true

IF Number Value Does Not Equal

Input:

Set(varQuantityInStock, 2)

Code:

Check if varQuantityInStock does not equal 9

If(varQuantityInStock <> 9, true, false)

Output:

true

IF Number Value Is Between Two Values

Input:

Set(varQuantityInStock, 6)

Code:

Check if varQuantityInStock is between 5 and 10

If(
    varQuantityInStock >= 5
    And varQuantityInStock <= 10,
    true,
    false
)

Output:

true

IF Number Is Found Within A Range (Multiple Conditions)

Input:

Set(varQuantityInStock, 5)

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"
)

Output:

"Low inventory, time to re-stock"

IF Function Date Examples In Power Apps

IF Date Value Equals Current Date

Input:

Set(varLastSoldDate, Today())

Code:

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

If(varLastSoldDate = Today(), true, false)

Output:

true

IF Date Value Equals A Specific Date

Input:

Set(varLastSoldDate, Date(2023, 3, 1))

Code:

Check if LastSoldDate column equals March 1, 2023

If(varLastSoldDate = Date(2023, 3, 1), true, false)

Output:

true

IF Date Value Is Between Two Dates

Input:

Set(varLastSoldDate, Date(2023, 3, 10))

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
)

Output:

true

IF Function Boolean Examples In Power Apps

Boolean Value Equals true

Input:

Set(varOnSale, true)

Code:

Check if varOnSale equals true

If(varOnSale, true, false)

Output:

true

IF Boolean Value Equals false

Input:

Set(varOnSale, false)

Code:

Check if varOnSale equals false

If(!varOnSale, true, false)

Output:

true

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:

Check if the OrderStatus of varInventoryItem equals “Ordered”

If(varInventoryItem.OrderStatus.Value = "Ordered", true, false)

Output:

true

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:

Check if the ID of varInventoryItem equals 3

If(Manufacturer.ID = 3, true, false)

Output:

true

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:

Check if the Title of varInventoryItem equals “American Standard”

If(Manufacturer.Value = "American Standard", true, false)

Output:

true

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:

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)

Output:

true

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:

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

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:

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

If(varInventoryItem.Buyer.Email = "[email protected]")

Output:

true

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:

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
)

Output:

true

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:

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
)

Output:

true

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:

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

If(Not(varInventoryItem="Samsung"), true, false)

Output:

true

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:

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
)

Output:

true

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.