Checking several conditions using multiple If statements

(0) Share

Report

Posted on by TB-20081424-0

220

Hello,

I have a situation where I have an IF Statement that checks a condition. And that statement works but I also need to include another IF statement that will append to that the first IF statement.

First statement:

Comments: If(JobCode_x003a_PLine.Value="Wireline", "DR, Tier 1", "DR, Tier 1, MSK")

In the second statement I want to check the date and if it's a stat, I want the word, ", Stat" after the first statement result.

If(DataCardValue12_3.SelectedDate in DayCalendar.Event, ", Stat")

I tried to use an AND IF, but ended up with the word false being saved in my comments field.

Thanks for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report
Try something like this:

If( JobCode_x003a_PLine.Value="Wireline" && DataCardValue12_3.SelectedDate in DayCalendar.Event, "DR, Tier 1", "DR, Tier 1, MSK, Stat", JobCode_x003a_PLine.Value="Wireline"&& !(DataCardValue12_3.SelectedDate in DayCalendar.Event), "DR, Tier 1", "DR, Tier 1, MSK")

Was this reply helpful? Yes No
TB-20081424-0 220 on at

Like (0)

Report

When I submit, the comment is not saving, it is blank.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

I see what the issue is. Let me clarify one thing. On the second comparison does it matter if the first value equals Wireline or not?

Was this reply helpful? Yes No
TB-20081424-0 220 on at

Like (0)

Report

I want to check if a value is wireline and if so display "DR, Tier 1" and if day is a stat, I want to include ", Stat"; otherwise leave ",Stat" out.
If the value is not wireline, I want "DR, Tier 1, MSK", and if day is stat, I want to include ",Stat", otherwise leave, ",Stat" out.

Was this reply helpful? Yes No
Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like (1)

Report
Try something like this. Put your most complex conditions at the top and go from there. Once it matches a specified set of conditions it stops evaluating and returns the result.

If( JobCode_x003a_PLine.Value="Wireline" && DataCardValue12_3.SelectedDate in DayCalendar.Event, "DR, Tier 1, Stat", , JobCode_x003a_PLine.Value="Wireline", "DR, Tier 1", DataCardValue12_3.SelectedDate in DayCalendar.Event,"DR, Tier 1, MSK, Stat", "DR, Tier 1, MSK" )

Was this reply helpful? Yes No
TB-20081424-0 220 on at

Like (0)

Report

Thank you for your quick response and support in helping me solve my issue!

Was this reply helpful? Yes No