Sharepoint PowerApps Form - two date picker boxes. how to make sure 2nd box is always later date than first.

(0) Share

Report

Posted on by cchan000

359

hi. hopefully a simple question.

i have two date fields. one is start date, one is end date. obviously i don't want the end date ever to be earlier than the start date. can i make it an error if this is chosen? how?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

RezaDorrani 12,145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cchan000

Disable the submit button by setting displaymode property for button as
If(dateEnd.SelectedDate<dateStart.SelectedDate,DisplayMode.Disabled,DisplayMode.Edit)

Also add a label with erro message text
and set visible property of label to
dateEnd.SelectedDate<dateStart.SelectedDate

where dateStart and dateEnd are control names of date field

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
cchan000 359 on at

Like
a
(0)

Report
Copy link

Link copied!

hi. this is what i put in the SECOND date picker right? The first one i leave alone?

this is what i have right now in the DATA CARD properties of the second picker.

If(FIRSTDATACARD.SelectedDate<FIRSTDATACARD.SelectedDate,DisplayMode.Disabled,DisplayMode.Edit)

FIRSTDATACARD = the datacard of the first date picker. is what i have above right?
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @cchan000

There is no need to make any formula changes to DatePickers. To display an error, you can create a text label, and set the below configurations:

Label Control

Text -> "Start Date cannot be greater than End Date"

Color -> Red

VIsible -> If(DatePicker1.SelectedDate > DatePicker2.SelectedDate, true,false)

Here, DatePicker1 corresponds to Start Date and DatePicker2 corresponds to End Date.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!