web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Select a range of date...

Power Apps

Answered

Select a range of dates in date picker

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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 Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!
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

Join the conversation