How Can We Filter Contain Date

(1) Share

Report

Posted on by Dynatech123

Hello Everyone,

I have Requirement for filter next 2 week data from entity,

and also want if my start date is 13-jun and end date is 22-jun then get that record in next 2 week filter gallery

this task in high priority so please anyone help me with this.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @demo099
can try below

ddlfromDate.Format = "mm/dd/yyyy" ddltoDate.Format = "mm/dd/yyyy" TemplateGalleryList1.Items = Filter(taskList, fromDate>=ddlfromDate.SelectedDate && toDate <= ddltoDate.SelectedDate)

And also if you want to get the data only 2 weeks data and and source should be having only date format
you can apply the below filter on Gallery

TemplateGalleryList1.Items = Filter(taskList, (fromDate>=ddlfromDate.SelectedDate && toDate <= ddltoDate.SelectedDate) && toDate <= DateAdd(Now(),14))

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.
Dynatech123 59 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @Shujaath_Khan ,
thanks for your suggestion, for next 2 week filter works properly,
but I also want like my request "Start Date" select from current week and "End Date" select from next week
then also show in gallery,
So can you help me with filter that type of record in Gallery.
Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @demo099
as you might be aware we cannot set max and min dates to date picker but we can set the conditions in filter
can you try below
On screen Visible keep WeekNum in context variable
Screen.OnVisible = UpdateContext({CurrentWeekNum: WeekNum(Now())}); TemplateGalleryList1.Items= Filter( taskList, (fromDate >= ddlfromDate.SelectedDate && toDate <= ddltoDate.SelectedDate) && toDate <= DateAdd(Now(),14) && (CurrentWeekNum= WeekNum(ddlfromDate.SelectedDate) && (WeekNum(ddltoDate.SelectedDate)>CurrentWeekNum)) )

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.