Using Like or Contains

(0) Share

Report

Posted on by MEGA1

Hi !

Need a little help please! Thank you in advance!

I have tried many variations and can't get it to work...I have a form field that cannot be populated by a certain source. I'm trying to add an error message that says:
If SOURCE_ORG like '%UM%' and field is populated then give error as this source cannot populate this field. I can't get the following formula on my card / label to work says my formula has errors

I put this on the Visible element of the card where I have the label to display the message if any source containing UM has populated an input field (DataCardValue234)

If(("UM" in ThisItem.SOURCE_ORG && !IsBlank(Value(DataCardValue234.Text)),true, false)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@MEGA1

I'm on a mission to remove unnecessary If() functions.

"UM" in ThisItem.SOURCE_ORG && !IsBlank(DataCardValue234.Text)

Reduces to either true or false by itself

Was this reply helpful? Yes No
MEGA1 66 on at

Like (0)

Report
Copy link

Link copied!

@Drrickryp Thank you so much! This absolutely worked! I just changed the "in" to "exactin" because it's case sensitive. I'll have to poke around for a way to ignore case but otherwise this worked, thanks again!!

Was this reply helpful? Yes No