Answered

Dropdown list of Sundays is broken .... please help (suddenly showing Thurs)

(0) Share

Report

Posted on by aedmunds

Hi,

I have been using this code since 1st July 2022 to create a dropdown with a sequence of Sundays ... 4 weeks back and 16 weeks forward.

On App Startup: (spaces added to make it more readable)

Set(
weeksList ,
ForAll ( Sequence ( 20, Day ( DateAdd ( Today(), -1 * ( Weekday ( Today(), Monday ) - 1), Days ) - 28, 7 ) ,
Date ( Year ( Today() ), Month ( Today() ), Value )
)

Then on the dropdown in question:-

AddColumns ( weeksList, "WeekEnd", Text( DateAdd (Value,6,Days), "ddd, dd-mmm-yyyy")

Yesterday, its started to fail and now gives me Thur in the dropdown instead of Sunday ... 1st Sep, 8th Sept etc... bizarre.

Am I missing something obvious here?? If there is a cleaner better way to just produce a list of Sundays, I'm happy to hear it ... I hate all the +6d stuff going on that I have to use.

Cheers community for your help

Andre

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

aedmunds 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Looking at it again ... it seems the "day" component is correct, but its slipped a month ... i.e. if I set the offset starting point to 0 ... it does the right day for the start of the week ... 29th ... as in August, but it adds it to current month sept ... hmmm ...

So this part seems to be breaking it for a long 5 week month ...

Date(
Year(Today()),
Month(Today()),
Value
)

Appending the correct day to the wrong month

Was this reply helpful? Yes No
Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
@aedmunds

This is how I would do it:

Set( weeksList, With( { thisSunday: DateAdd( Now(), -(Weekday( Now(), StartOfWeek.Monday )), Days ) }, AddColumns( ForAll( Sequence( 20, -4 ), { sundayDate: DateAdd( thisSunday, 7 * Value ) } ), "sundayDateFormatted", Text( sundayDate, "ddd, dd-mmm-yyyy" ) ) ) )

This would then produce a "sundayDateFormatted" column in your variable, and you can avoid calling AddColumns in the Items property of your dropdown.

Was this reply helpful? Yes No
aedmunds 24 on at

Like
a
(0)

Report
Copy link

Link copied!
That's cool and works for that Sequence, thanks mate.

I've since found an even cleaner way to achieve a similar thing in another thread which works even better ... like this within the Set(weeksList, ...

ForAll( Sequence(13, -4), { myDate: DateAdd(Today(),-(Weekday(Today()) - 2) + 7 * - Value) } )

Cheers for that time and effort working through that, much appreciated.

Was this reply helpful? Yes No
aedmunds 24 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for working through that and I can see that would solve it.

On another thread, I got this answer which is an even cleaner way to do it and I have implemented this one now...

ForAll( Sequence(13, -4), { myDate: DateAdd(Today(),-(Weekday(Today()) - 2) + 7 * - Value) } )

Was this reply helpful? Yes No