Answered

Create a calendar with public holiday in power apps

(0) Share

Report

Posted on by safiranrd

Hi All.

I am trying to insert a public holiday for my leave request app, I already create the list separately on share point. And I have found this formula to calculate total leave taken except the public holiday. But every time I try to insert the formula, power apps giving me this alert.

I think its the CountIF formula, bcs if I take out the CountIF formula, they dont give any alert

ID public holiday is my list, and holidaystart and holidayend is the start and the end date of the public holiday from my list

Any help is really appreciated, thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Jiis 254 Moderator on at

Like (0)

Report
Copy link

Link copied!
Add ending parenthesis

UpdateContext({daysdiff: RoundDown(DateDiff(StartDate.SelectedDate, EndDate.SelectedDate, Days) / 7, 0) * 5 + Mod(5 + Weekday(EndDate.SelectedDate) - Weekday(StartDate.SelectedDate), 5) - CountIf('2024 ID Public Holiday', HolidayStart >= StartDate.SelectedDate, HolidayEnd <= EndDate.SelectedDate)})

Was this reply helpful? Yes No
safiranrd 50 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thank you for the suggestion! I have added ending parenthesis as you suggested, the alert is now gone but somehow this warning icon is still there
any idea why?

Was this reply helpful? Yes No
Jiis 254 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello, i think it might be because CountIf function isnt delegable. If your datasource is bigger than 2000 records it wont work and if you do have a large dataset, you could use a Flow. Or you could filter them first out with delegable formula and then count them.

Was this reply helpful? Yes No
safiranrd 50 on at

Like (0)

Report
Copy link

Link copied!

the alert is still showing but its working perfectly, thanks!

Was this reply helpful? Yes No
Jiis 254 Moderator on at

Like (0)

Report
Copy link

Link copied!

Be careful with that, if your datasource '2024 ID Public Holiday' exceeds 500 records, it might not work correctly
You can increase the limit to 2000 records from the settings.

Was this reply helpful? Yes No
safiranrd 50 on at

Like (0)

Report
Copy link

Link copied!

Since my data only have under 30 rows, I think it will be fine. Once again, thank you!

Was this reply helpful? Yes No