web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Multiple IF statements

Power Apps

Answered

Multiple IF statements

(0) Share

Report

Report

Posted on by juliowastaken

75

When I only enter 2 conditions it works, but when I enter 3 conditions it doesn't work. Can someone please help me with the syntax.

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Pstork1 69,665 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
YOu are missing a comma in front of the true.

if(dpSelectStudy.selected.value = "something" | dpSelectStudy.selected.value = "something" | dpSelectStudy.selected.value = "something" , true, false)
Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@juliowastaken - you're missing a comma.

If( dpSPSelectStudy.Selected.Value = "ASPIRE" || dpSPSelectStudy.Selected.Value = "DETECT" || dpSPSelectStudy.Selected.Value = "SOFAST", true, false )

On a related note, depending on what you're trying to do, you do not need to wrap an IF function around a formula which is already going to return a boolean anyway. For example, the below will return the same output:

dpSPSelectStudy.Selected.Value = "ASPIRE" || dpSPSelectStudy.Selected.Value = "DETECT" || dpSPSelectStudy.Selected.Value = "SOFAST"

As will this:

dpSPSelectStudy.Selected.Value in [ "ASPIRE", "DETECT", "SOFAST" ]
juliowastaken 75 on at

Like
a
(0)

Report
Copy link

Link copied!

it worked, thank you for your help. 🙏
alexsolexToo 37 on at

Like
a
(1)

Report
Copy link

Link copied!
and consider using Or(...) and And(...) as soon as you have several conditions to check : your code will be more readable.
Or( dpSPSelectStudy.Selected.Value = "ASPIRE", dpSPSelectStudy.Selected.Value = "DETECT", dpSPSelectStudy.Selected.Value = "SOFAST" )

Join the conversation