i have inserted calender control from calender template screen.
now i want to remove last month disabled dates and future days from calender. so in each month it should display only that month days . how to do it.
i added button in gallery of calender to display choice value of sharepoint coloumn.
in button text properties i added as thisitem.SPchoice.value.
Hi @venky232 ,
Could you please share a screenshot of the new Label and current formula in Visible? I cannot understand why the convert to number error appears.
Best regards,
error
Issue
Name isn't valid. 'Value' isn't recognized.
This error appears most commonly when a
formula refers to something that no longer exists
(for example, a control that you've deleted).
Location
CB Button 3
Msible
How to fix
Remove or correct the reference to the name that
isn't valid.
and also the value cant convert to number
Hi @venky232 ,
You can simply copy all the codes in Visible of Title Label to Visible of the holiday Label you just added then hide them from current month.
Best regards.
its working but i have added a label in gallery to show holidays .but for blank date also it is showing label value in below code
LookUp(
Filter(
Holidays2023,
'Holiday Type' = "Public Holiday"
),
'Holiday Date' = Text(DateAdd(_firstDayInView, ThisItem.Value, TimeUnit.Days), "dd-mmm-yyyy"),
'Holiday Type'
)
Hi @venky232 ,
Please go to Visible of the Label inside the MonthDayGallery, add the formula below as in my screenshot:
&&!(Abs(Self.Text - ThisItem.Value) > 10)
Best regards,
WarrenBelz
146,552
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,928
Most Valuable Professional