Statement assistance with 2 conditions 1 required

(0) Share

Report

Posted on by Tango

1,168

Hi,

Trying to get my head around the format of a statement that has 2 conditions, the first required and the second only if true

for example

if ColA true and TextInput1.Text = ColB or TextInput1.Text = ColC or TextInput1.Text = ColD TextInput1.Text = ColE)

Thanks in advance for any assistance

Todd

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

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

Like (0)

Report
Copy link

Link copied!

@Tango - what is the data type for ColB, ColC and ColD?

Is it Text?

Was this reply helpful? Yes No
Tango 1,168 on at

Like (0)

Report
Copy link

Link copied!

@Amik Yes

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Assuming these arguments should apply to a Gallery or EditForm, this is the formula based on what you have described:

If( Or( ThisItem.ColA = "true" && ThisItem.ColB= TextInput1.Text, //if ColA true and TextInput1.Text = ColB ThisItem.ColC = TextInput1.Text, //or TextInput1.Text = ColC ThisItem.ColC = TextInput1.Text //or TextInput1.Text = ColC ), ThisItem.ColD = TextInput1.Text, //TextInput1.Text = ColD) Blank() )

Was this reply helpful? Yes No
Tango 1,168 on at

Like (0)

Report
Copy link

Link copied!

@Amik Thanks for your reply.

ColA has to equal true on all.

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report
Copy link

Link copied!
Apply another “&&” operator to the other conditions to check ColA.

Also, your description is not terribly clear / does not make sense. It’s not clear why Col C is appearing twice in your description, and whether ColD is also a condition to check. It is also not clear what is supposed to happen if the If statement returns true or false.

Assuming you just want to return a Boolean true/false. Use either:

Or( ThisItem.ColA = "True" && ThisItem.ColB = TextInput1.Text, ThisItem.ColA = "True" && ThisItem.ColC = TextInput1.Text, ThisItem.ColA = "True" && ThisItem.ColD = TextInput1.Text)

And(ThisItem.ColA = "True", Or( ThisItem.ColB = TextInput1.Text, ThisItem.ColC = TextInput1.Text, ThisItem.ColD = TextInput1.Text ) )

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Tango 1,168 on at

Like (1)

Report
Copy link

Link copied!

Thanks @Amik, just rectified that. It actually will return results from a gallery

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Need anything else or has my previous response answered the question?

Was this reply helpful? Yes No