cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Red8aron
Frequent Visitor

Leave Request APP - How to Exlude Holidays from User request

Hi guys,

Iam new at powerapps, and have setup the LR Template from powerapps, and now iam strugling to implemente a formula that exclude all days that i have on my HolidaysCollection when a user try to request a leave, need a help to create a formula and step-by-step how to implemented.

 

Kind regards

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Community Support
Community Support

Hi @Red8aron ,

 

The Leave Request Template has already implemented the function of excluding the Holidays. Please navigate to the OnSelect property of LeaveStartDatePicker in NewRequestScreen, the _requestedDays variable is the request days you want.

Notice that the holiday collection is hardcoded in OnStart property of App, it stores the holiday of 2018, you need to update for the holiday date of this year.

Snipaste_2020-08-13_15-48-42.png

Hope this helps.

Sik

View solution in original post

3 REPLIES 3
v-siky-msft
Community Support
Community Support

Hi @Red8aron ,

 

The Leave Request Template has already implemented the function of excluding the Holidays. Please navigate to the OnSelect property of LeaveStartDatePicker in NewRequestScreen, the _requestedDays variable is the request days you want.

Notice that the holiday collection is hardcoded in OnStart property of App, it stores the holiday of 2018, you need to update for the holiday date of this year.

Snipaste_2020-08-13_15-48-42.png

Hope this helps.

Sik

View solution in original post

Hi @v-siky-msft 

Frist sorry for double posting i didnt notice i have posted this topic twice, and thanks for your help, now i had another question, i cant find the holiday collection on my onstart (What hardcode means?) i have create my own, but i want to know how i can change the holiday content without modify the excel file?

Hi @Red8aron ,

 

A lot of ways. You can use Gallery to list all holidays and use EditForm to submit modification on it, Or use Patch/Update function to do this.

The easiest way is to create another app from your data, then it will generate a basic app automatically for you to perform CURD on table data.

Snipaste_2020-08-13_17-46-26.png

Hope this helps.

Sik

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

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.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,858)