Answered

Textinput box date and time validation in power apps

(0) Share

Report

Posted on by Nikilp

Hi, Good day!
I have created a new power app.
In the application one of the text input field user will update date and time values
Ex format : 29/12/2022 10:30 AM

Before saving the data I need to validate the format like (DD/MM/YYYY HH:MM AM/PM).

Could you please some one help if user entered the wrong format need through error message or highlight the field.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

virksami 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Why you don't use date picker control instead of text input?

Was this reply helpful? Yes No
Nikilp 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, In my application we needs to update multiple date and time fields. Users will directly copy and paste the details.

Was this reply helpful? Yes No
WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Nikilp ,

You can use this test - Note the last bit just needs to be something the date will always be after

DateTimeValue(YourTextBoxName.Text) > Today() - 60

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Nikilp 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Good day!
It's not working.
In the TEXT INPUT box user needs to update below format
Ex. 27/Dec/22 9:30 AM
01/Jan/23 10:20 PM
If user entered the wrong format needs to show the alert message befor submit.
Wrong format examples. 27/ Dec/22
27/Dec/22 10:30 A
27/Dec/22 10 AM
Could you please help.

Was this reply helpful? Yes No
WarrenBelz 156,386 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Nikilp ,

If you are going to use text instead of a date picker, then the format that you regard as valid needs to be one recognised by Power Apps as a valid date. 27/Dec/22 9:30 AM is not a valid date/time and would require a heap of code gymnastics to validate manually (which my brain hurts thinking about). 27/12/2022 09:30 AM is valid and would work with the formula I provided. Please consider using a date picker and your minute/drop-downs or change the format valid of the Text.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

SitaramamurthyJ 12 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello Nikilp,
Try this code in OnChange property of the text field. When wrong format entered and moves to next field, it will display error notification.
If(!IsMatch(TextInput3.Text,"\d{2}/\d{2}/\d{4} (1[0-12]|[1-9]):[0-5][0-9] ([AaPp][Mm])"),
Notify("Please enter DD/MM/YYYY 00:00 AM/PM Format",
NotificationType.Error);Reset(TextInput3));

Was this reply helpful? Yes No
Nikilp 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SitaramamurthyJ ,

Good day!
The above code works if we use the 02/02/2023 10:30 AM format, but I am using 02/Feb/2023 10:30 AM.
Can you please help?

Was this reply helpful? Yes No
SitaramamurthyJ 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Nikilp ,
Then try this code on OnChange property of the text field.
If(
!IsMatch(
TextInput1.Text,
"^(([0-9])|([0-2][0-9])|([3][0-1]))\/(Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec)\/\d{4} (1[0-12]|[1-9]):[0-5][0-9] ([AaPp][Mm])"
),
Notify(
"Enter DD/MMM/YYYY HH:MM AM/PM Format",
NotificationType.Error
);
Reset(TextInput1)
)

Was this reply helpful? Yes No