Unanswered

How i can make sure that the user did not enter any special characters (except ",") inside a text field.

(0) Share

Report

Posted on by johnjohnPter

1,950 Season of Giving Solutions 2025

I have a text field where users can enter characters and numbers and only this special characters "," -comma-. so how i can force this rule inside my field?

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@johnjohnPter see this useful article:

https://www.practicalpowerapps.com/data/specialcharacters/

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @johnjohnPter ,

Please try this:
1)Create a collection of ASCII values for special characters except comma.
OnVisible of screen: ClearCollect( col, ForAll( Sequence(15), {test: Char(32 + Value)} ), ForAll( Sequence(7), {test: Char(57 + Value)} ), ForAll( Sequence(5), {test: Char(90 + Value)} ), ForAll( Sequence(4), {test: Char(122 + Value)} ) ); RemoveIf(col,test=Char(44))
2)Set the textinput:
OnChange:ForAll(col,If(test in Self.Text,Notify("can not enter any special characters except(,)")&Reset(Self)))

Best regards,
Rimmon

Was this reply helpful? Yes No
johnjohnPter 1,950 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

@v-mengmli-msft Thanks for the reply ,,,so power apps does not provide this list of special chars out of the box?

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

As far as I know, it doesn't have.

Was this reply helpful? Yes No
johnjohnPter 1,950 Season of Giving Solutions 2025 on at

Like (0)

Report
Copy link

Link copied!

@v-mengmli-msft it worked for me thanks.. but how i can only allow numbers and "," .. without characters is this possible?

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @johnjohnPter ,

Just numbers and ","?
It seems that I missed something....
Please modify above code:
OnVisible of screen: ClearCollect( col, ForAll( Sequence(9), {test: Char(48 + Value)} ), {test: Char(44)} )
OnChange of TextInput: ForAll(Split(Self.Text,"") As C,If(Not(C.Value in col),Notify("can not enter any special characters")&Reset(Self)))

Best regards,
Rimmon

Was this reply helpful? Yes No