PowerApps Template - Leave Request

[Anonymous]

Hello PowerApps Community,

I'm currently in the process of adopting the Leave Request template for use in my organization. However, I've run into a few problems. I'm attempting to edit the already established collections in the app and am having a lot of trouble doing so. I've read the Patch article and I just can't figure out how to successfully use the Patch function to update the various collections I will need.

Some methods I've tried include editing the OnStart action in the Login Screen and this didn't work. I figured out how to edit the Company Holidays Collection via Excel on OneDrive. Essentially, I just need to edit one collection, the LeaveTypeCollection. I want to edit the options as well as the image (icon) available.

Can someone please give me a step-by-step guide on how to do so? I would be extremely grateful.

[Anonymous]

Bump

[v-xida-msft · Accepted solution]

Hi @Anonymous,

How do you want to update the LeaveTypeCollection? Insert a new record into this collection or Update an existing record within this Collection?

Further, do you want to update the LeaveTypeCollection with Patch function?

The LeaveTypeCollection is defined within the OnStart property of the LoginScreen via the ClearCollect function. If you want to update the LeaveTypeCollection, you could update the LeaveTypeCollection within the OnStart property of the LoginScreen directly. Modify the formula within the OnSelect property of the LoginScreen as below:

Concurrent(
    //collection used in the left nav menu
    ...
    //collection used in the left nav menu
    ...
    //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:"Floating Holiday", 
                    icon: 'floating-holiday', 
                    iconselected:'floating-holiday-selected',
                    description:"As a regular employee working full time, you receive eight floating holidays at the beginning of each calendar year. Please obtain your manager's approval prior to scheduling your floating holidays (one floating holiday equals eight hours for full-time employees). As a regular employee working part-time, you will receive the equivalent of eight floating holidays at the beginning of each calendar year in accordance with your reduced work schedule. If you were hired on or after October 16, you will not receive floating holidays for that calendar year. You will receive eight floating holidays in January of the following calendar year. If your floating holidays are not used within the current calendar year, they are forfeited. Unless required by state law, unused floating holidays are not cashed out at termination."
                }
                    ,
                {
                    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."
                } ,
                {              /* <-- Add formula start */
                  type: "TypeName",
                  icon: 'iconImage',  /* iconImage and iconSelectedImage represent the image files you have embedded within your app */
                  iconselected: 'iconSelectedImage',
                  description: "Description..."
                }            /* <-- Add formula end */
            )
    ),
    //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()),
    ...

If you want to use Patch function to update your LeaveTypeCollection, please take a try with the following workaround:

1. If you want to insert a new record into the LeaveTypeCollection, please take a try with the following formula:

Patch(
    LeaveTypeCollection, 
    Defaults(LeaveTypeCollection),
    {
       type: "TypeName",
       icon: 'iconImage',     /* <- iconImage and iconSelectedImage represent the image files you have embedded within your app already */
       iconselected: 'iconSelectedImage',
       description: "The description about the new leave type"
    }
)

2. If you want to update an existing record (leave type) within the LeaveTypeCollection, please take a try with the following formula:

Patch(
     LeaveTypeCollection, 
     LookUp(LeaveTypeCollection, type = "The specific type name"),
     {
       icon: "iconImage",
       iconselected: "iconSelectedImage",
       description: "Leave type description"
     }
)

Note: The available icon images has been embedded within this template app already, the screenshot as below:

You could also consider add your own icon images within your app. Please check the following article for more details:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-images-pictures-audio-video

More details about Patch function in PowerApps, please check the following article:

Patch function

Best regards,

Kris

[Lucas_]

Hi

Your solution is not complete.

This addresses only one part.

I have discovered 2 more parts and no idea how to complete it.

1. Going to My Leave Balance, still shows the wrong collection, RequesterBalanceCollection, don't know where to modify it.
2. Saving of data in an Excel spreadsheet,
ClearCollect(BalanceCollection,
{
EmployeeEmail: _myProfile.UserPrincipalName,
EmployeeName: Office365Users.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")
}
)

How do I get this to work? And that the application does the correct subtraction of leave.

Seems like the whole app is only for American employers.
If only it was easy to adjust for other employers....

If these PowerApps examples are so hard to use and configure (hard coded for American use), I might look into just developing it from scratch.

I thought it would be easier using PowerApps.

Regards
Lucas

[MeeraThakkar]

Hello @Lucas_ @Anonymous @v-xida-msft ,

I want to customise the leave types and started following this blog. But it seems that apart from changing the collections defined at OnStart, there are many places we need to update in the application. 

Changing the OnStart code to below is giving me 148 errors.

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:”Paid Leave“, 
                    icon:vacation,
                    iconselected:'vacation-selected',
                    description:
                    “All employees get 12 paid leave per year, if not used, can be encased at the end of the year.”
                }
                ,
                {
                    type:"Sick Leave", 
                    icon:'sick-leave', 
                    iconselected:'sick-leave-selected',
                    description:”5 sick leaves are granted to all employees.”
                }
                    ,
                {
                    type:”National Holiday“, 
                    icon: 'floating-holiday', 
                    iconselected:'floating-holiday-selected',
                    description:”10 national holidays are granted to all employees.“
                }
                    ,
                {
                    type:”Casual Leave“, 
                    icon: 'jury-duty', 
                    iconselected:'jury-duty-selected',
                    description:”5 casual leaves are granted to all employees“
                }
                    ,
                {
                    type:”Compensatory off”, 
                    icon: bereavement, 
                    iconselected:'bereavement-selected',
                    description:”Compensatory off can be availed against any pre-approved overtime.”
                }
            )
    ),
    //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()),
    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>"
    ),
    ClearCollect(HolidaysCollection, 
     {HolidayName: "Thanksgiving", StartDate: DateValue("11/22/2018")}, 
     {HolidayName: "Day after Thanksgiving", StartDate: DateValue("11/23/2018")}, 
     {HolidayName: "Christmas", StartDate: DateValue("12/25/2018")}, 
     {HolidayName: "DayAfterChristmas", StartDate: DateValue("12/26/2018")}, 
     {HolidayName: "New Year's Day", StartDate: DateValue("1/1/2019")})
);


ClearCollect(LeaveCollection, 
     {Title: "Vacation", Detail: "Example vacation request", StartDate: Today(), EndDate: DateAdd(Today(), 6, Days), LeaveType: "Paid", Requester: _myProfile.UserPrincipalName, Approver: Office365Users.MyProfile().UserPrincipalName, 
     Status: "Pending", LeaveID: _myProfile.UserPrincipalName&Text(Now(), "[$-en-US]mm-dd-yyyy-hh-mm-ss-fff")});

ClearCollect(BalanceCollection,
        {
            EmployeeEmail: _myProfile.UserPrincipalName, 
            EmployeeName: Office365Users.MyProfile().DisplayName, 
            Year: Text(Year(Now())), 
            Paid:12, 
            PaidUsed:0, 
            Sick:5, 
            SickUsed:0, 
            National:10, 
            NationalUsed:0, 
            Casual:3, 
            CasualUsed:0, 
            Overtime:0, 
            OvertimeUsed:0, 
            BalanceID:_myProfile.UserPrincipalName&Text(Now(), "[$-en-US]mm-dd-yyyy-hh-mm-ss-fff")
        }
)

I have just changed the collections LeaveTypeCollection & BalanceCollection but saving it is giving me 148 errors.

Did you make your leave application from strach or were these errors solvable?

Thanks,

Meera.

[Lucas_]

Hi

I abandoned the leave application on my side.

To make it work well you need to use flow in the background to handle the complex parts.

Power apps is a difficult development program.

Regards

[KMusab]

Hi,

Those errors are solvable, just update need to update the LeaveTypeCollection at all those error - popups.