trying to create the calendra view app from SP list_Need help

(0) Share

Report

Posted on by bbsin

1,994

I saw Shane's video creating Calendar link to SP list.

I try to create with his but the prev mth and next mth does not show on the gallery and the current month is showing it's time with date, anyone can help? Thank you

I try to use Days and it does not work. So I use the timeunit.days

Prev mth and Next mth is just empty

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (2)

Verified answer

BCBuizer 22,636 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @bbsin ,

If you want the label showing the date value to not show for values that are outside of the selected month, set the Visible property of the label to:

Month(DateValue(Self.Text)) = Month(varCalMonth)

If you want the label to only show the date, but not the time, you can use the Text function to format the value in the Text property of the label:

Text( <insert your current formula for the Text property of the label in the gallery here>, "mm/dd/yyyy" )

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

Thank you but why is the previous month button and next month button when clicked, all dates for the months does not have the date appear the dates on the gallery?
not sure which part is not right.

Was this reply helpful? Yes No
BCBuizer 22,636 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @bbsin ,

Can you please share the full OnSelect property of both buttons?

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

@BCBuizer

The on select button for Previous Month
Set(varCalMonth, DateAdd(varCalMonth, -1,TimeUnit.Months));
Set(varCalMonthFirstDayView, DateAdd(varCalMonth, - Weekday(varCalMonth,TimeUnit.Days)));

button Next Month
Set(varCalMonth, DateAdd(varCalMonth,1,TimeUnit.Months));
Set(varCalMonthFirstDayView, DateAdd(varCalMonth, - Weekday(varCalMonth,TimeUnit.Days)))

Gallery Item
Sequence(If(DateDiff(varCalMonthFirstDayView, DateAdd(varCalMonth, 1, TimeUnit.Months), TimeUnit.Days)>36,42,35))

date gallery that should to show the dd/mm/yy; the current mth is showing fine but not the prev and next mth
Text(DateAdd(varCalMonthFirstDayView, ThisItem.Value, TimeUnit.Days), "dd/mm/yyyy")

Thank you

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,636 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @bbsin ,

One of the brackets for both buttons has been misplace causing an error when running the formula and hence the dates are not showing.

Please try the below for the Previous Month button:

Set(varCalMonth, DateAdd(varCalMonth, -1,TimeUnit.Months)); Set(varCalMonthFirstDayView, DateAdd(varCalMonth, - Weekday(varCalMonth),TimeUnit.Days));

and this for the Next Month button:

Set(varCalMonth, DateAdd(varCalMonth, 1,TimeUnit.Months)); Set(varCalMonthFirstDayView, DateAdd(varCalMonth, - Weekday(varCalMonth),TimeUnit.Days));

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

@BCBuizer , Great. It work now.

Thank you for your help. 🙂

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

@BCBuizer

Hi Can I check with you
why is the nested gallery not displaying any text?
if I have two events of the same date start to end date different, will it display more than 2?

Thank you

SP list

current button

next mth button

prev mth button

Thank you

Was this reply helpful? Yes No
BCBuizer 22,636 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @bbsin ,

In the formula for the Items property of the nested gallery replace LblCurrentDate.Text with the actual formula you have for that property.

Indeed the gallery should show multiple items if there are multiple.

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

@BCBuizer

Strangely all the months are not displaying any items?

Thank you

Was this reply helpful? Yes No
BCBuizer 22,636 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @bbsin ,

Can you please share the Items property of GalDayDetails and the Text property of lblCurrentDate?

Was this reply helpful? Yes No