if( not empty then add specific text in card

(0) Share

Report

Posted on by Sjon

All,

Maybe this is a simple solution but i am getting frustrated in this formula.

I have this code working, but it needs to be the other way around.

If(
 IsEmpty([DataCardValue13.Text]),
 "Send to CL for re approval",
 Or(
 IsEmpty([DataCardValue14.Text]),
 "Send to CL for re approval 2",
 Or(
 IsEmpty([DataCardValue15.Text]),
 "Send to CL for re approval 3",
 "Pending"
 )
 )
)

So instead of being blank or empty i want to have it with but the Isnotempty or Isnotblank does not exist.

If(
 IsNotEmpty([DataCardValue13.Text]),
 "Send to CL for re approval",
 Or(
 IsNotEmpty([DataCardValue14.Text]),
 "Send to CL for re approval 2",
 Or(
 IsNotEmpty([DataCardValue15.Text]),
 "Send to CL for re approval 3",
 "Pending"
 )
 )
)

Any work arounds for this or simple solution.

So when a specific text field is not empty give me a specific text in another text field.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Sjon

Please consider changing your Formula to the following:

If(IsBlank(DataCardValue13.Text), "Send to CL for re approval", IsBlank(DataCardValue14.Text), "Send to CL for re approval 2", IsBlank(DataCardValue15.Text), "Send to CL for re approval 3", "Pending" )

I hope this is helpful for you.

Was this reply helpful? Yes No
Sjon 29 on at

Like (0)

Report
Copy link

Link copied!

I will change it to is blank.
But then i still get the wrong outcome, i want to execute when it is not empty or is not blank.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Sjon

I am not entirely clear on your logic as you have stated it, but if you are looking for the inverse (not) of the conditions, then just add a NOT operator.

Ex:

If(!IsBlank(DataCardValue13.Text), "Send to CL for re approval", !IsBlank(DataCardValue14.Text), "Send to CL for re approval 2", !IsBlank(DataCardValue15.Text), "Send to CL for re approval 3", "Pending" )

1 people found this reply helpful.

Was this reply helpful? Yes No
Sjon 29 on at

Like (2)

Report
Copy link

Link copied!

And that simple ! made it work.

Thank you, i was looking for the old fashion Isnotempty or isnotblank

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@Sjon

IsEmpty only applies to records/tables not to Text. IN your original formula you were converting your text into a table (the square brackets) in order to then try to use the IsEmpty on it.

All you need is IsBlank - that is blank or "".

And of course...that function returns a true or false, so prepending it with a ! (NOT) operator will flip the trues and falses.

Glad it helps you!

Was this reply helpful? Yes No