Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Filling HTML table with requested leave dates

I've got an automated generated HTML table that gets all dates in a month, check for weekends in that month and fills the box with empty space, check for holidays in collection and fills the box with a message (;Liber) and automatically fills the hours worked( 10 to 18) and total worked hours(8) if its not weekend or holiday. 

I store months days in a collection DaysMonth, weekend days in a collection WeekDaysCollection, holidays in collection HolidaysCollection and hours worked are hard coded(its fine)


Employees can request holidays and the manager can accept or deny them. The holidays requests are stored in an excel on onedrive.


If someone has an accepted leave request i want to write "O.H" in the total worked hours cell. How can i do that? How can i get all the dates in a requested leave interval? Also i need to do that for every employee


I've attached a photo with my table in its current state 



Hi @Konjic 


>How can i get all the dates in a requested leave interval?

Please reference this case: Get-all-dates-in-an-date-interval-start-and-end 


Best Regards.


Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,878)