cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zmm14
Helper III
Helper III

Leave request type - Changing or creating new types

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.

16 REPLIES 16
zmm14
Helper III
Helper III

Thanks again

zmm14_0-1625025767502.png

 

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

zmm14_1-1625025841438.png

what can i do to get this thing working?

 

Thank for the help.

 

ArchitectMadhan
Super User
Super User

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.

 

 

- Architect Madhan

Please click the "Accept as Solution" button and give thumbs up, if it is helpful to you.
zmm14
Helper III
Helper III

Thanks to all of you for the help.

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

zmm14_0-1625078138763.png

 

Now I have 3 issues

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

zmm14_1-1625078243297.png

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?

zmm14_0-1625079003487.png

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).

zmm14_1-1625079164898.png

 

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>"
)
);

 

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
zmm14
Helper III
Helper III

Thank You SOOOOOOO MUCH!!!!!

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

zmm14_0-1625086537977.png


@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
Helper III
Helper III

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,660)