web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Dropdown Contains Date...

Power Apps

Unanswered

Dropdown Contains Dates in Two Week Groups

(0) Share

Report

Report

Posted on by Phineas

5,331 Moderator

I need a Dropdown that allows the user to choose a date range that includes two weeks at a time.

When the user opens the Dropdown they should be able to choose from a list of date (in two week blocks), with the defaul date being including current date, however that range shoud start at the Sunday before.

The should be able to go as far back a one month and as far into the feature as the system allows.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

rb 835 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @Phineas,

If you are generating this dynamically in PowerApps, it will be different every time you load it - is that OK?

Here is an example of how I implemented with a combo box (so I could show the period number and the date range at the same time):

With( //Get Sunday before-last as Seed Day {SeedDate: DateAdd(Today(), -Weekday(Today(), Monday) - 7, Days)}, ForAll( //Generate a list of 2-week period starting from 2 periods before Seed Date Sequence(10, -2, 1) As Offset, { Number: Text(Offset.Value + 3), Dates: Text(DateAdd(SeedDate, Offset.Value * 14, Days), "dd/mm/yyyy") & " - " & Text(DateAdd(SeedDate, (Offset.Value + 1) * 14 - 1, Days), "dd/mm/yyyy") } ) )

The first argument of Sequence(), which is 10 in my example, can be adjusted to determine the number of periods generated.

Was this reply helpful? Yes No

Join the conversation