Answered

Select a range of dates in date picker

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I'm trying to sort my data in a range of dates in the date picker. For example being able to select 7/4/21 and select 7/26/21 and get any data that was entered in that time period. And/or being able to have a clickable options like "Last Week" "Last month" "Last 3 months"

I'm a beginner so please explain it in detail 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

v-xiaochen-msft on at

Like (0)

Report
Hi @Anonymous ,

I did a simple demo for you.

1\ This is my datasource.

2\ Add 2 datepicker control 'DatePicker1' and 'DatePicker2'.

Add a gallery control and set its Items property to:

Filter(LIST148,Date_Column>=DatePicker1.SelectedDate&&Date_Column<=DatePicker2.SelectedDate)

3\ Add a button control and set its onselect property to:

Set(Last_Week_End,DateAdd(Today(),-Weekday(Today()),Days));Set(Last_Week_Start,DateAdd(Today(),-Weekday(Today())-6,Days))

//Create 2 variables

Set gallery's Items property to:

Filter(LIST148,Date_Column>=Last_Week_Start&&Date_Column<=Last_Week_End)

// Show last week

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @Anonymous

With( { sData: Filter( 'SPDataSource', IsBlank(FromDate.SelectedDate) || IsEmpty(FromDate.SelectedDate) || Date >= FromDate.SelectedDate, IsBlank(ToDate.SelectedDate) || IsEmpty(ToDate.SelectedDate) || Date <= ToDate.SelectedDate ) }, Sort( sData, Date, If(SortDesending1, Descending, Ascending) ) )

We can add more filters if you need them.

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No