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)

 

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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,424)