trying to create the calendra view app from SP list_Need help

[bbsin]

Hi 

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

[BCBuizer · Accepted solution]

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"
)

[bbsin]

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.

[BCBuizer]

Hi @bbsin ,

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

[bbsin]

@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

[BCBuizer · Accepted solution]

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));

[bbsin]

@BCBuizer , Great.  It work now.

Thank you for your help. 🙂

[bbsin]

@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

[BCBuizer]

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.

[bbsin]

@BCBuizer 

Strangely all the months are not displaying any items?

Thank you