cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hughrmarks
Helper IV
Helper IV

Using IF(AND) after a string of IFs

In Excel, if you want to use multiple IF statements, it would go like this:

IF(A=B, value if true, value if false), IF(C=D, value if true, value if false), IF(E=F, value if true, value if false)

 

In PowerApps, you don't have to use "IF" the second and third time:

IF(A=B, value if true, value if false), (C=D, value if true, value if false), (E=F, value if true, value if false)

 

I'm looking to start with two "IF" statements, and then add a "IF(AND)" statement, which is simple in Excel:

IF(A=B, value if true, value if false), IF(C=D, value if true, value if false), IF(AND(E=F, G=H, value if true, value if false))

 

But I can't make it work in PowerApps because that I can't use that third "IF".   If I just use "AND" it doesn't work.

There has got to be a simple solution to this but I can't find it anywhere.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
C_Ian_Davis
Power Apps
Power Apps

Hi Hugh,

 

A couple solutions here: (very bad example, but highlights how to nest the 'And' statements)

 

Set(a, 1);
Set(b, 2);
Set(c, 3);

If(And(And(a = b, b = c), c = a), Do stuff, else do other stuff)

and then, as your logic grows, it may be easier for you to use && in place of 'And' like so:

 

Set(a, 1);
Set(b, 2);
Set(c, 3);

If(a = b && b = c && c = a, Do stuff, else do other stuff)

 

View solution in original post

5 REPLIES 5
C_Ian_Davis
Power Apps
Power Apps

Hi Hugh,

 

A couple solutions here: (very bad example, but highlights how to nest the 'And' statements)

 

Set(a, 1);
Set(b, 2);
Set(c, 3);

If(And(And(a = b, b = c), c = a), Do stuff, else do other stuff)

and then, as your logic grows, it may be easier for you to use && in place of 'And' like so:

 

Set(a, 1);
Set(b, 2);
Set(c, 3);

If(a = b && b = c && c = a, Do stuff, else do other stuff)

 

View solution in original post

I knew there was a simple solution that I was missing!

Thanks so much.

Makes perfect sense.

HI @C_Ian_Davis 

Can you help me with my formula? i want to make the gallery visible with 2 OR condition TRUE.

If(GalleryTabInspection.Selected.Value.ID = "MenuTab2", Or(CountRows(Filter(HeaderColl, SO_Number=GalleryFilterSO.Selected.'Service Order Id'))=0), false, true)

It doesnt seem work like i expected. 
What should i do to make it work properly?

Thanks,

pytbyt

Hi @C_Ian_Davis@C_Ian_Davis 

 

 

 

It seems 'and' can be used only for comparision.

 

Yes it is possible to perform multiple stuff If True, - using "&"

here is the example code which I'm using

 

I'm running this code in OnChange event of Dropdown1

 

If (
Dropdown1.Selected.Value = "Edit",

Reset(Dropdown1) &
EditForm(formuserinfo) &
Set(
visformuserinfo,
true
) &
Set(
grpfrmsubmit,
true
),
Reset(Dropdown1)
)

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,326)