Answered

PowerApps Form Validation -- OnSelect formula not working

(0) Share

Report

Posted on by CristinaM

Hello. I'm having trouble with a validation formula and I'm not sure why.

I'm using a Canvas Power App on my SharePoint Online list. I have a column "A" that is single line of text. I have another column "B" that is a choice, dropdown column. Column A contains a single word/single line of text. Column B choices are strings of text in a dropdown. When a user makes a choice in column B, I need a formula that will check Column A to see if the choice in B contains the word in column A.

If so, I do not want the user to be able to submit the update to the form. The formula I have tried is in the property OnSelect of my Submit button and reads:

If(Not(IsBlank(Find(DataCardValue3.Text,DataCardValue5.Selected.Value))),Notify("Invalid choice",NotificationType.Error)SubmitForm(SharePointForm1))

But the result is I'm able to submit my form even when my column B choice contains the word in column A. What do I have wrong here? Thank you in advance for your insights.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @CristinaM,

You could try to use the in operator instead of the current code:

If( Trim(DataCardValue3.Text) in DataCardValue5.Selected.Value, Notify("Invalid choice",NotificationType.Error), SubmitForm(SharePointForm1) )

With the Find function 2 issues could occur:

When using the wrong case in column A ("A" will not be found in the string "a")

When adding a space at the start or end of column A ("a " or " a" will not be found in string "a")

Issue one is fixed by using the in operator which is case insensitive. The second issue is fixed by using the Trim() function around the Column A text input.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
CristinaM 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Perfecto! Thank you, @LaurensM, so much. Had a chance to finally try it today, and it works like a charm.

Appreciate it.