Unanswered

Nesting If Statements

(0) Share

Report

Posted on by kpromma

Hi,

I want Field 3 to be conditionally formatted based on dropdown options chosen from Field 1 and dropdown options chosen from Field 2. How would the IF statement look? Here is more information:

A & B are dropdown options of Field 1

1, 2, 3, and 4 are dropdown options of Field 2

a, b, c, and d are dropdown options of Field 3 that are conditionally formatted based on what is chosen from Field 1 and Field 2

These are the outcomes I’m trying to achieve:

If A + 1 = a

If A + 2 = a

If A + 3 = b

If A + 4 = b

If B + 1 = c

If B + 2 = c

If B + 3 = d

If B + 4 = d

I tried this using this formula from combo box fields and it didn't work:

If(Field1 = A,
If(Or(Field2 = 1, Field2 = 2),
a,
b)
,
If(Or(Field2 = 1, Field2 = 2),
c,
d)
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 154,889 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @kpromma ,

There does not appear anything wrong with your code based on your description - you might try this

Switch( FieldA, "A", If( Field2 = 1 || Field = 2, "a", "b" ), "B", If( Field2 = 1 || Field = 2, "c", "d" ) )

but what is your actual code based on the drop-down outputs and where are you using it ?

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
kpromma 41 on at

Like (0)

Report
Copy link

Link copied!

Hi. The field I have that needs the nested if statement is a combobox. I'm trying to add the statement to the "Items" function of the dropdown.

This is what I tried, but it's not correct:

If(DataCardValue24.Selected.Value=”Office of Research Admin”,If(Or(DataCardValue25.Selected.Value=”Grants and Research Cost Reimb Soft”,DataCardValue25.Selected.Value=”Grants and Research Cost Reimb Hard”),DataCardSelectedValue26.Selected.Value=”PROV Costs ORA”,DataCardSelectedValue26.Selected.Value=”PROV Costs NonORA”), If(Or(DataCardValue25.Selected.Value=”Grants and Research Cost Reimb Soft”,DataCardValue25.Selected.Value=”Grants and Research Cost Reimb Hard”),DataCardValue26.Selected.Value=”PROV Amount ORA”,DataCardValue26.Selected.Value=”PROV Amount NonORA”)))

Was this reply helpful? Yes No
kpromma 41 on at

Like (0)

Report
Copy link

Link copied!
My scenario changed. Field 2 now only has 2 options. My fields are choice options from a List and the datacards are combobox dropdowns (DataCardValue###).

Field 1 (Oversight Group):
A (ORA)
B (Other)
Field 2 (Invoice Method):
a (cost reimbursable invoice)
b (amount based invoice)
Field 3:
1 (PROV Amount NonORA)
2 (PROV Amount ORA)
3 (PROV Costs NonORA)
4 (PROV Costs ORA)
Field 3 is conditionally formatted based on what is chosen from Field 1 and Field 2

These are the outcomes I’m trying to achieve:
If A + a = 4
If A + b = 2
If B + a = 3
If B + b = 1

Was this reply helpful? Yes No