Answered

Validation for Special Characters

Like (1) Share

Report

Posted on 22 Jul 2020 09:19:14 by AkshayManke

Hello,

I am working on an PowerApp where there are few fields in which i want a validation that, if a person enters special characters then the form should not get submitted and to show a warning message. For warning message i can use notify function but how to check and act if a field value consisting of special characters?

Regards,

Akshay

Categories:

General Questions

I have the same question (0)

All responses (15)

Answers (2)

PrudhviL 136 on 10 Jun 2023 at 14:58:07

Like (0)

Report

Re: Validation for Special Characters

HI @Varinder__Singh
I found a solution,
Just try removing &Char(34)& from the formula.
It worked for me.

Was this reply helpful? Yes No
Varinder__Singh 2 on 09 Jun 2023 at 08:07:35

Like (0)

Report

Re: Validation for Special Characters

I am getting the same issue, any resolution?

Was this reply helpful? Yes No
PrudhviL 136 on 09 Jun 2023 at 03:03:56

Like (0)

Report

Re: Validation for Special Characters

Hello I have tried this work around and it was working until yesterday. Since then it is showing an error message. I have also built it from scratch and tested it. Still it's not working. Could you please let me know why is this happening or is there any work around for it?

Thanks

Was this reply helpful? Yes No
JAWL 393 on 11 Mar 2022 at 02:52:10

Like (0)

Report

Re: Validation for Special Characters

Hi @jlindstrom
Unfortunately, your formula cannot flag ` [ ] as invalid characters? How can I modify it?

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on 24 Feb 2022 at 18:30:46

Like (0)

Report

Re: Validation for Special Characters

In reference to @RMD211 's question. I had him try this: IsMatch(Self.Text,".*[^a-zA-Z0-9_].*" ), which works well for me on all Special Characters, but he is having difficulty with it. It only works on certain special characters. He is in the UK and his language in the app is en-gb.

Was this reply helpful? Yes No
RM-30040732-0 468 on 24 Feb 2022 at 13:30:41

Like (0)

Report

Re: Validation for Special Characters

Hello! Do you have any idea how to set your Ismatch to find all special characters (without specifying each one)? And how to find spaces? I'm trying to validate entries that only contain letters or numbers and can't get Ismatch to work!

Was this reply helpful? Yes No
Dado90 2 on 20 Jul 2021 at 12:49:27

Like (0)

Report

Re: Validation for Special Characters

Works really well for me.
With this onchange-code i can block the special characters Char(34) and Char(47).

Now my new problem is, as soon as someone set a new line in de multiline datacardvalue-field by clicking the enter-button, the code is like not activ anymore.

does anybody knows how the ismatch is working when enter-button for a new line is clicked in an multiline datacardvalue-field?

Thanks

Was this reply helpful? Yes No
AkshayManke on 31 May 2021 at 17:16:49

Like (0)

Report

Re: Validation for Special Characters

Hi @GixStar ,

I think you can just add parenthesis in the two conditions like below.
If(
!(Label4.Visible) Or !(Label6.Visible),
Edit,
Disabled
)

I have created a test on my env. you can refer the below GIF for the same.

Was this reply helpful? Yes No
GixStar 6 on 27 May 2021 at 17:55:47

Like (0)

Report

Re: Validation for Special Characters

Hi
i tried that but its still only disabling the Submit button if Label4 and Label6 has invalid characters, if one of them have invalid Characters Submit button is still active.
Thank you

If(
!Label4.Visible Or !Label6.Visible,
Edit,
Disabled
)

Was this reply helpful? Yes No
jrtraylor 45 on 25 May 2021 at 19:59:19

Like (0)

Report

Re: Validation for Special Characters

@v-qiaqi-msft
How can i modify your formula to allow for 4 characters? I need to allow Char(38), Char(45), Char(46) and Char(95) in my text box.

Was this reply helpful? Yes No