web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Can't block small lett...

Power Apps

Answered

Can't block small letter alphabets in Power Apps

(0) Share

Report

Report

Posted on by JAWL

393

Dear Experts,

How to formulate power apps to block both Capital Letter and Small Letter Alphabet?

My formula is:

IsMatch(DataCardValue1.Text,".*[\\\"&Char(34)&"/<>!@#$%^&.'*(),=-_|{}~:;+-].*")

The app behaves to my expectation to block Capital Letter:

However, the app cannot block small letters:

Categories:

Building Power Apps

All responses Img

All responses (6)

Answers Img

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Check out this Video by @RezaDorrani

https://www.youtube.com/watch?v=XvevCq6qhX4&t=1268s

Start watching from 5:44
JAWL 393 on at

Like
a
(0)

Report
Copy link

Link copied!

@zmansuri That is super useful! By the way, how can I modify the formula to allow hyphen "-" only and block all other special characters?

Coalesce(
Parent.Error,
If(
!IsBlank(DataCardValue6.Text) &&
!IsMatch(
DataCardValue6.Text,
Match.MultipleDigits
),
"Only number is allowed"
)
)
zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

If(
!IsBlank(TextInput1.Text) && !IsMatch(
TextInput1.Text,
"\d\d\d-\d\d"
),
"Only number is allowed"
)
JAWL 393 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @zmansuri , I guess "\d\d\d-\d\d" is only limited to that format right?
What I want is to allow ANY free format (\d\d\d\d; \d\d\d\-\d\d; \d\d\d\-\d\d\-\d\d, etc.) as long as they are numbers and/or hyphens, how can we further modify the formula?
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JAWL :

Regular expressions that only allow numbers and ‘-’ can use

"[0-9-]*"

For example:

Best Regards,

Bof
JAWL 393 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft Amazingly works as expected! Thanks for your help!

Join the conversation