How to check selected date is already in database

(0) Share

Report

Posted on by DTtechies

Hello Everyone,

In my app have start date picker and end date picker.

i want to notify to user when start date and end date is already in database.

my start date is 14th and end date is 16th and submit request.

then again i select 13th is start date and 15th is end date then i want to notify to user that They have already requested in selected date in between

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

JD382 114 on at

Like
a
(0)

Report
Copy link

Link copied!
You can filter your data source and see if it returns anything. If it is blank then there is not any overlap. In this example DataSource is your database, StartDate and EndDate are the respective column names in your database.
If( !IsBlank( Filter( DataSource, (StartDate >= StartDatePicker.SelectedDate && StartDate <= EndDatePicker.SelectedDate) || (EndDate >= StartDatePicker.SelectedDate && EndDate <= EndDatePicker.SelectedDate) ) ), Notify("Date already selected", NotificationType.Error) )
DTtechies 76 on at

Like
a
(0)

Report
Copy link

Link copied!

@JD382
thank for the answer, it is working now.

Thank you
DTtechies 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JD382
your solution is working but i have another problem

if i am taking request from 1st to 5th and try to take a request on 3rd then am i am able to take request.

but in my case a dont want to allow user to take request between date

thanks in advance
JD382 114 on at

Like
a
(0)

Report
Copy link

Link copied!

You can add another criterion to the filter function.

|| (startdate <= StartDatePicker.SelectedDate && enddate >= EndDatePicker.SelectedDate)

This captures any existing requests that completely encompass the start and end dates that the user picks.
DTtechies 76 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JD382
i have taken a leave on 21st to 23rd

and trying to take a leave on 21st, then its allow to take a leave, but i dont want to allow 21st date to take a leave