cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,266)