Answered

Formulas for Weekly Calendar

(0) Share

Report

Posted on by Nuke_It_Newport

Hi All-

I am working on my first Canvas app in Power Apps. I have a date picker (DatePicker1), a Horizontal Gallery (gal_Calendar_Days), and a Label (lbl_SunDate) on my screen. I want to select a date in the date picker (any date in a week), and have the horizontal gallery display the week, Sunday to Saturday. I have the following formulas:

In gal_Calendar_Days.Items:

ForAll(Sequence(7), {date: DateAdd(DatePicker1.Value, -Weekday(DatePicker1.Value, StartOfWeek.MondayZero), Days)})

In lbl.SunDate.Text:

Text(ThisItem.date-Weekday(ThisItem.date,2)+1, "dddd m / dd")

When I select a date, the calendar populates with the Monday date of the selected week, but the days do not increment. I've been working on this for days, with little progress. Can somebody guide me in the right direction?

Thanks!

Screenshot 2.png Screenshot 1.png

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Nuke_It_Newport ,

Please use below formula instead:

ForAll(Sequence(7) As S, {date: DateAdd(DatePicker1.SelectedDate, -Weekday(DatePicker1.SelectedDate, StartOfWeek.MondayZero)+S.Value-1, Days)})

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
Nuke_It_Newport 53 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks! When I change my code to the formula you provided, The week dates don't populate at all. Is there something else I'm missing?

Was this reply helpful? Yes No
Nuke_It_Newport 53 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-jefferni I figured out my error. I had to change "DatePicker1.SelectedDate" back to "DatePicker1.Value", and then your formula worked. Thanks for your help! 👍

Was this reply helpful? Yes No