Answered

One IF Multiple conditions

(0) Share

Report

Posted on by SecretAdmirer09

Hi All!

Trying to know if it's possible to use one if with three conditions. (see below formula) I know something is wrong but i dont have any technical background so im not sure what to use if and OR or OR & OR i should use something else?

Using gallery for this formula, trying to re-do reza's one tutorial vids for responsive data, he only use one condition with his, so now im trying to see if its possible.

Thank you!

If(
If( varTabSelected= 1,
Exception,
Filter(
Exception,
Handler.Email = User().Email))
And
If(varTabSelected= 3,
Filter(Exception,'Exception Status'.Value="Open"),
Filter(
Exception,
'Exception Status'.Value="Close"
)
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @SecretAdmirer09 , You can always use the nested IF's. Switch is also one if the alternative. Please check this: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-if

Above article has few examples that can help you understand the IF and SWITCH.
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
Sickle-Cell 600 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

You can use multiple conditions with IF. The best way I've found is by doing it like this.

If( And( conditionone, conditiontwo, conditionthree ), result.true, result.false )

Was this reply helpful? Yes No
Verified answer

Anchov 1,986 on at

Like (0)

Report
Copy link

Link copied!
There is a way to do nested If statements, with simplified syntax. Here is an example based on your code snippet, but you will need to update it so it fits your needs

If( varTabSelected = 1, // First Condition Exception, // Then do this varTabSelected = 2, // 1st else condition Filter( Exception, Handler.Email = User().Email ), varTabSelected = 3, // 2nd Else Condition Filter(Exception, 'Exception Status'.Value = "Open"), Filter(Exception, 'Exception Status'.Value = "Close") // Default else when no other conditions are meant )

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt

Was this reply helpful? Yes No
SecretAdmirer09 51 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the idea, i inserted them all in one ifs, just what you have mentioned.

Appreciate it ❤️

Was this reply helpful? Yes No