cancel
Showing results for
Did you mean:
Level 8

## Help with Formula Logic multiple conditions on an IF statement

Hi Everyone

Could some on give me some direction?

I am creating a preview of a form which will be emailed (HTMLText).

I am attempting to setup that text displays based on Dropdown values.

I have done it with selecting one value but can you do it with 2 values in one IF statement

My formula currently  is

&"<br><br><b>" & If(Dropdown1_1.Selected.Value="Minor Development", DataCardKey1.Text) &"<br></b>" & If(Dropdown1_1.Selected.Value="Minor Development", Dropdown1_1.Selected.Value)

I tried this but it doesn't work

&"<br></b>" & If(Dropdown1_0.Selected.Value="Minor Development", Dropdown1_0.Selected.Value) &"<br><br><b>" & If(Dropdown1_1.Selected.Value="Minor Development", DataCardKey1.Text) &"<br></b>" & If(Dropdown1_1.Selected.Value="Minor Development" Or "Safety Critical", Dropdown1_1.Selected.Value)

Any help appreciated

Gary

1 ACCEPTED SOLUTION

Accepted Solutions
Level 8

## Re: Help with Formula Logic

Hi All

I have found the solution (I am new to this lol) so this is to help the other new users

Instead of using If statements you use a Switch

Switch ( the value you want to action,

"measure", outcome,

"measure2",outcome )

in my case the example would be

Switch(Dropdown1_1.Selected.Value,

"Minor Development", DataCardKey1.Text,

"Safety Critical", DataCardKey1.Text

)

Hope this helps someone

Gary

2 REPLIES 2
Level 8

## Re: Help with Formula Logic

Hi All

I have found the solution (I am new to this lol) so this is to help the other new users

Instead of using If statements you use a Switch

Switch ( the value you want to action,

"measure", outcome,

"measure2",outcome )

in my case the example would be

Switch(Dropdown1_1.Selected.Value,

"Minor Development", DataCardKey1.Text,

"Safety Critical", DataCardKey1.Text

)

Hope this helps someone

Gary

Highlighted
Community Support Team

## Re: Help with Formula Logic multiple conditions on an IF statement

Hi @gazzo1967 ,

Thanks for sharing your resolution here and hope others could benefit from it.

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

#### Power Platform World Tour

Coming to a city near you

#### PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

#### Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 69 members 3,598 guests
Recent signins: