Show Public Holiday on Custom Calendar

(0) Share

Report

Posted on by Charl

I have a custom calendar and I am trying to indicate the public holidays that comes from a SharePoint list.

So I have the following to show me the current day that works perfect:

OnSelect : Set(_DateSelected,DateAdd(_FirstDayofWeek,ThisItem.Value,TimeUnit.Days))

OnVisible: If(DateAdd(_FirstDayofWeek,ThisItem.Value) =_DateSelected,true,false)

But If I want to change it to do a Filter to check if today is a Public Holiday I can't seem to get that working..

OnSelect: Set(_DateSelected,DateAdd(_FirstDayofWeek,ThisItem.Value,TimeUnit.Days))

OnVisible: If(Filter(MICT_TC_Public_Holidays, Start_Date <= DateAdd(_DateSelected,0,TimeUnit.Days)
&& End_Date >= DateAdd(_DateSelected,6,TimeUnit.Days)),true,false)

I tried this and various others but I cant seem to get this right.

Any advice ?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Charl

You should use the TemplateFill property of the gallery items or another visual indicator within the gallery template to change the appearance of the item if it represents a public holiday.

If(
CountRows(
Filter(
colPublicHolidays,
Start_Date <= DateAdd(_FirstDayOfWeek, ThisItem.Value, Days) &&
End_Date >= DateAdd(_FirstDayOfWeek, ThisItem.Value, Days)
)
) > 0,
Color.Red, // This color indicates a public holiday
Color.Transparent // Default color when it's not a public holiday
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Charl 28 on at

Like (0)

Report

Hi Thanks for the reply. Sorry to say still having issues. the If statement is expecting true/false so does not like the Color.Red.. I have tried few changes but basically getting same issue.

Was this reply helpful? Yes No
Verified answer

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (1)

Report
Try this formula,

If(
CountRows(
Filter(
MICT_TC_Public_Holidays,
Start_Date <= DateAdd(_FirstDayOfWeek, ThisItem.Value, TimeUnit.Days) &&
End_Date >= DateAdd(_FirstDayOfWeek, ThisItem.Value, TimeUnit.Days)
)
) > 0,
Color.Red, // This color indicates a public holiday
Color.Transparent // Default color when it's not a public holiday
)

Was this reply helpful? Yes No
Charl 28 on at

Like (1)

Report

Thank you @Rajkumar_404 I am learning 😁 !!

Was this reply helpful? Yes No
Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report

Happy Learning 😇 !!!

Was this reply helpful? Yes No