IF with And doesnt work as excel

(1) Share

Report

Posted on by Michal_Boro17

Hello,

i ve got easy problem but dont know why is not working properly.

User must type any text in TextInput2 and add at least one attachment to enable "Save button".

With function below, it only needs one argument not two as i wanted to and button show

If(
IsBlank(TextInput2) && IsEmpty(DataCardValue14.Attachments) ;
DisplayMode.Disabled;
DisplayMode.Edit
)

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

365-Assist 2,327 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Don't use semicolons. Use commas. I believe your PowerFX should be:
If( IsBlank(TextInput2) && IsEmpty(DataCardValue14.Attachments), DisplayMode.Disabled, DisplayMode.Edit )
--------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
Verified answer

mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

So right now what you have is saying:

If the textinput is blank AND if the attachments are blank then disable the control. What it sounds like you want is If the textinput is blank OR if the attachments are blank then disable the control. This is b/c you are requiring both.

In terms of logic:
the positive is TexInput2 AND Attachments
which means the opposite (or contrapositive) would be:
!Attachents OR !TextInput2

Since you are using the contrapositive version this would be your formula:
If(IsBlank(TextInput2) Or IsEmpty(DataCardValue14.Attachments), DisplayMode.Disabled, DisplayMode.Edit)

Not sure if the ';' should be ',' or not as that is based on your location/syntax used there. Hope this helps!

Was this reply helpful? Yes No
Michal_Boro17 26 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank u, now i understand the logic.

"Not sure if the ';' should be ',' or not as that is based on your location/syntax used there. Hope this helps!" -> Exactly, in my location this is the proper syntax

Was this reply helpful? Yes No