Leave Request APP - How to Exlude Holidays from User request

[Red8aron]

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

[v-siky-msft · Accepted solution]

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.

Hope this helps.

Sik

[Red8aron]

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?

[v-siky-msft]

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.

Hope this helps.

Sik