Leave request type - Changing or creating new types

[zmm14]

Hi, I need help... please bear with me since I have no coding knowledge or Powerapps experience.

I'm working with the Leave Request Template.

How do I create or modify the leaves types, example:

Floating Holiday for *Rollover days (22 days from previous vacations) 

Jury Duty for *Maternity Leave (90 days)

Bereavement for *Half Day (either 8:30 am - 12:30 pm or 12:30 pm to 4:30 pm)

In my country we don't have Jury Duty, Bereavement or Floating Holidays.

Please help I've been searching and cant find something like this.

[zmm14]

Thanks again

Concurrent(
//collection used in the left nav menu
ClearCollect(EmployeeNavigation,
{MenuItem: "My Leave Requests"},
{MenuItem: "My Leave Balance"},
{MenuItem: "Company Holidays"},
{MenuItem: "About"},
{MenuItem: "Log out"}),

//collection used in the left nav menu
ClearCollect(ManagerNavigation,
{MenuItem: "Leave Requests"},
{MenuItem: "Company Holidays"},
{MenuItem: "About"},
{MenuItem: "Log out"}),

//add custom leave types to this collection to make them show up in the app
ClearCollect(
LeaveTypeCollection,
Table(
{
type:"Vacation",
icon:vacation,
iconselected:'vacation-selected',
description:
"Vacation leave is provided to all employees for the purpose of rest, relaxation, and to attend to personal affairs. Vacation balance is acquired over time and can be used at any time."
}
,
{
type:"Sick Leave",
icon:'sick-leave',
iconselected:'sick-leave-selected',
description:"Sick leave may be used for your own illness or medical/dental appointments or for the illness or medical/dental appointments of family members. Sick leave can also be used to address the psychological, physical, or legal aspects of domestic violence, sexual assault, stalking, or other crime. You may not use sick leave for vacation purposes. Some cities and states have specific laws governing sick leave that allow use of sick leave to care for other family members."
}
,
{
type:"Rollover",
icon: Rollover,
iconselected:'floating-holiday-selected',
description:"As a regular employee working full time, you."
}
,
{
type:"Jury Duty",
icon: 'jury-duty',
iconselected:'jury-duty-selected',
description:"If you are summoned for jury duty or subpoenaed as a trial witness in a federal or state court in the United States or its territories, or in a suit to which the company is a party, you will be granted paid time away from work for the time that you are required to devote to jury service or being a trial witness, (for hourly employees, up to eight hours in a day). Regular employees working part-time will be eligible for paid time away in accordance with their part-time work schedules. You may keep all jury-duty–related compensation paid to you (for example, parking reimbursements or payments for jury duty)."
}
,
{
type:"Bereavement",
icon: bereavement,
iconselected:'bereavement-selected',
description:"Regular employees may take paid time away from work in the event of the death to attend the funeral (or alternative to a funeral), make arrangements necessitated by the death of a family member or grieve the death of a family member. Bereavement leave for a family member may be taken as follows: Employees may take up to 5 work/business days in the event of a death of an immediate family member broadly including a spouse, domestic partner, custodial parent, non-custodial parent, adoptive parent, foster parent, biological parent, parent-in-law, parent of domestic partner, sibling, grandparent or grandchild of the employee, or a person with whom the employee is or was in a relationship of in loco parentis. The term also includes the biological, adopted, legal ward, foster or step child of an employee or the child of an employee's domestic partner."
}
)
),
//defines leave start and end for requests. Default set to Now since most users will be creating new requests. Changes to reflect leave times for requests which are being edited
Set(_leaveStart,Now()),
Set(_leaveEnd,Now()),
Set(_myProfile,Office365Users.MyProfile());
If(
IsBlank(
LookUp(Balance, Year = Text(Year(Now())) && EmployeeEmail = _myProfile.UserPrincipalName)),
Patch(Balance, Defaults(Balance),
{
EmployeeEmail: _myProfile.UserPrincipalName,
EmployeeName: _myProfile.DisplayName,
Year: Text(Year(Now())),
Vacation:10,
VacationUsed:0,
Sick:8,
SickUsed:0,
Floating:8,
FloatingUsed:0,
JuryDuty:3,
JuryDutyUsed:0,
Bereavement:5,
BereavementUsed:0,
BalanceID:_myProfile.UserPrincipalName&Text(Now(), "[$-en-US]mm-dd-yyyy-hh-mm-ss-fff")
}
)
),
ClearCollect(EmailTemplate,
"<html>

<head>
<meta http-equiv=""Content-Type"" content=""text/html; charset=us-ascii"">
</head>

<body>
<p>
There is a leave request from: {SubmitterName} pending your approval. <ul><li>Type: {LeaveType}</li><li>Title: {LeaveTitle}</li><li>Description: {LeaveDescript}</li><li>Start Date: {LeaveStart}</li><li>End Date: {LeaveEnd}</li>" &
"</p>
</body>
</html>"
)
)

I think I added all icons correctly but not working

what can i do to get this thing working?

Thank for the help.

[ArchitectMadhan]

Hi @zmm14 ,

I can see there are single quotes missing in the newly added leave types. Where as the icon names for unchanged leave types are enclosed in single quotes. Could you try enclosing the modified leave types icon names?

icon:vacation,
iconselected:'vacation-selected',

type:"Rollover",
icon: Rollover,
iconselected:'floating-holiday-selected',

type:"Bereavement",
icon: bereavement,
iconselected:'bereavement-selected',

type:"Sick Leave",
icon:'sick-leave',
iconselected:'sick-leave-selected',

Please accept this as solution, if it works for you.

[zmm14]

Thanks to all of you for the help.

@ArchitectMadhan gave me an idea and start with a clean template to see my error.

Now I have 3 issues

1. Leave Balance Screen does not show my new leave types only the old ones

2. My balance can't be updated, do I need to re-name all the leave types to the ones I changed or do not change anything?

3. As I click on the icons of my new leaves it shows the original icon and does not show the balance as I click in the different options (can't upload the video).

Working Formula

Concurrent(
//collection used in the left nav menu
ClearCollect(EmployeeNavigation,
{MenuItem: "My Leave Requests"},
{MenuItem: "My Leave Balance"},
{MenuItem: "Company Holidays"},
{MenuItem: "About"},
{MenuItem: "Log out"}),

//collection used in the left nav menu
ClearCollect(ManagerNavigation,
{MenuItem: "Leave Requests"},
{MenuItem: "Company Holidays"},
{MenuItem: "About"},
{MenuItem: "Log out"}),

//add custom leave types to this collection to make them show up in the app
ClearCollect(
LeaveTypeCollection,
Table(
{
type:"Vacation",
icon:vacation,
iconselected:'vacation-selected',
description:
"Vacation leave is provided to all employees for the purpose of rest, relaxation, and to attend to personal affairs. Vacation balance is acquired over time and can be used at any time."
}
,
{
type:"Sick Leave",
icon:'sick-leave',
iconselected:'sick-leave-selected',
description:"Sick leave may be used for your own illness or medical/dental appointments or for the illness or medical/dental appointments of family members. Sick leave can also be used to address the psychological, physical, or legal aspects of domestic violence, sexual assault, stalking, or other crime. You may not use sick leave for vacation purposes. Some cities and states have specific laws governing sick leave that allow use of sick leave to care for other family members."
}
,
{
type:"Rollover",
icon: rollover,
iconselected:'floating-holiday-selected',
description:"As a regular employee working full time, you must finished any vacation days left from previous year before March 31st of current year. Unused days cant be cashed."
}
,
{
type:"Half Day",
icon: 'half-day',
iconselected:'jury-duty-selected',
description:"If you need a half day permit this could be either half day morning 8:30 am to 12:30 pm or half day afternoon 12:30 pm to 4:30 pm."
}
,
{
type:"Maternity Leave",
icon: 'maternity-leave',
iconselected:'bereavement-selected',
description:"Female employees as per law are entitled to 90 days of maternity leave, this would be 1.5 months before the delivery and 1.5 after the delivery."
}
)
),
//defines leave start and end for requests. Default set to Now since most users will be creating new requests. Changes to reflect leave times for requests which are being edited
Set(_leaveStart,Now()),
Set(_leaveEnd,Now()),
Set(_myProfile,Office365Users.MyProfile());
If(
IsBlank(
LookUp(Balance, Year = Text(Year(Now())) && EmployeeEmail = _myProfile.UserPrincipalName)),
Patch(Balance, Defaults(Balance),
{
EmployeeEmail: _myProfile.UserPrincipalName,
EmployeeName: _myProfile.DisplayName,
Year: Text(Year(Now())),
Vacation:22,
VacationUsed:0,
Sick:18,
SickUsed:0,
Floating:0,
FloatingUsed:0,
JuryDuty:5,
JuryDutyUsed:0,
Bereavement:90,
BereavementUsed:0,
BalanceID:_myProfile.UserPrincipalName&Text(Now(), "[$-en-US]mm-dd-yyyy-hh-mm-ss-fff")
}
)
),
ClearCollect(EmailTemplate,
"<html>

<head>
<meta http-equiv=""Content-Type"" content=""text/html; charset=us-ascii"">
</head>

<body>
<p>
There is a leave request from: {SubmitterName} pending your approval. <ul><li>Type: {LeaveType}</li><li>Title: {LeaveTitle}</li><li>Description: {LeaveDescript}</li><li>Start Date: {LeaveStart}</li><li>End Date: {LeaveEnd}</li>" &
"</p>
</body>
</html>"
)
);

[Pstork1 · Accepted solution]

1) You need to find the leave types wherever they are used in the program, like the balance screen, and make the changes.

2) Yes, you need to change the names of the balances also or they won't update.

3) The Icon-selected: property right below the icon property in the onStart is the name of a .png file just like the one used for the icon.  Only this one is used when the icon is selected.  You need to upload images and change both.

[zmm14]

Thank You SOOOOOOO MUCH!!!!!

YOU GUYS HELP ME A LOT! I'M SOOOOO HAPPY! ‌‌

@Pstork1 can you help me with the half-day option *** 8:30 am to 12:30 pm or 12:30 pm to 4:30 pm***

Thank You!

[zmm14]

I followed this guide but did not work

https://powerusers.microsoft.com/t5/Building-Power-Apps/Leave-Template-Include-half-day-option/td-p/... 

[Pstork1]

I'll be happy to help, but for the sake of those who will be looking for answers later would you post it as a new question and reference the article you used again.  I'll respond there and see what I can do to help.