Limiting digits in text input?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I have an app where users can type in the date.

It is not a calendar as this is faster to do than selecting specific dates from the calendar.

The format is "YYMMDD", is there a way to limit the number for the digits so the "MM" cannot be greater than 12 (December) and "DD" cannot be greater than 31.

If not possible, maybe changing the first M to be 0 or 1. Second M to be 0 to 9. D to be 0-3, Second D to be 0-9

Currently, the background changes from red to white, when in the correct format. If there is no way to limit it, maybe to change the background colour to show that it's in the wrong format.

Thank you,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,779 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,
Firstly make sure you have 6 characters
If( Len(YourTextBoxName.Text)<>6, Notify("Must have six numbers in YYMMDD format",Error) )
Now for the day
If( Value( Right(YourTextBoxName.Text,2) )>31, Notify("Date cannot be greater than 31",Error) )
and the month
If( Value( Mid(YourTextBoxName.Text,3,2) )>12, Notify("Month cannot be greater than 12",Error) )
These use notifications - also if you put this on the OnChange of the text box, you can replace the text box name with Self
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

Thank you, it worked.

I made it a notification, and also disabled the submit button if the format is wrong.

Was this reply helpful? Yes No