How to add Holidays to Calendar in P-app

[ReyOrtiz]

Hi all

I have been looking and cannot find how to add holidays to a calendar by the name of the holiday. I'm trying to create a calendar allowing teams to book training. However, we dont want them to use the holiday and the week the holiday falls into. I understand these are two different issues but knowing me. I will also need help to block the wee, which I assume will be done by disconnecting the view of some sort.
thank you 

Best Regards

Rey

[EricBLott]

Are you wanting to disable certain days/weeks in the default DatePicker control in Power Apps, or are you creating a custom calendar?

[ReyOrtiz]

Is a custom calendar no date picker

[EricBLott]

@ReyOrtiz We'll need more info on the custom calendar, but typically, you'd leverage the DisplayMode property. You'll need a collection (or some data source) of all the holidays relevant, and then if the day/week contains a holiday, you'll set the DisplayMode to Disabled.

[ReyOrtiz]

I got the calendar to display the name ( don't ask me how), and I used the same formula. But, now, since some holidays can fall in the middle of the week, how can I disable the week? For example, if it is on Wednesday, I would like the Wednesday to be disabled but the Monday and Tuesday before it, and Thursday and Friday. 

[EricBLott]

You can use the WeekNum() function to check if a date's week number (the week of the year) is equal to any holiday's WeekNum() value of the holiday collection.

[ReyOrtiz · Accepted solution]

I seem to understand your suggestion, but I don't know how to start it. This is what shows in Item

this is on a gallery inside the calendar gallery for the Holidays,

Filter(HolidayList,ThisItem.Value>='Effective Date',ThisItem.Value<='Effective Date')

And this is the calendar in SharePoint