Leave Request app

[Penjilia]

 Good day,

I am currently trying to adopt the leave request app for my business, I have "made my own" app and had the onedrive excel file created. I am seeing the on start code for the vacation type collection, however, when I select new request I am not seeing the options available:

[shinichi_kawara]

@Penjilia ,

The LeaveTypeCollection collection of "NewRequestScreen" is designed to be set by OnStart of App.

It will be displayed by executing OnStart of App.

Please check it.

[Penjilia]

Concurrent( //add custom leave types to this collection to make them show up in the app ClearCollect( LeaveTypeCollection, { type:"Vacation", icon:vacation, 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', 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', 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', 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, 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." } ), Set(_myProfile,Office365Users.MyProfile()); //Initially, approver is signed in user's manager Set(_defaultApprover,Office365Users.Manager(_myProfile.Id)); Set(_defaultApproverPhoto, If(Office365Users.UserPhotoMetadata(_defaultApprover.Id).HasPhoto, Office365Users.UserPhoto(_defaultApprover.Id))); 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") } ) ), //email templates used to send out request notifications ClearCollect(EmailTemplate, {Row: 1, Value: "

There is a leave request from: {SubmitterName} pending your approval.

• Type: {LeaveType}
• Title: {LeaveTitle}
• Description: {LeaveDescript}
• Start Date: {LeaveStart}
• End Date: {LeaveEnd}
" & "

"}, {Row: 2, Value: "

Your leave request from {LeaveStart} to {LeaveEnd} has been {LeaveStatus}" & "

"}) );

the code above is what i populated for onstart of the app

[v-xida-msft · Accepted solution]

Hi @Penjilia ,

Do you create a canvas app in Phone Layout based on the Leave Request Template app?

Based on the issue that you mentioned, I have made a test on my side, and the issue is confirmed on my side. I found that if I click "Make my own" button, the OnStart property of App would not be fired, so the LeaveTypeCollection would be empty. Therefore, you would not see options shown up in the NewRequestScreen.

As an fixed solution, please consider click "Run Start" option under the App control as below:

then the GalleryLeaveType would be populated with proper records as below:

Please try above solution, then check if the issue is solved.

Regards,

[Penjilia]

thank you, that's exactly what I did, this fix worked.

[Pan0s]

Hi there,

I have the same problem. Balance options not showing up.

Although I create the app (Make my own), the data.xlsx/balance is empty. 

any ideas?

pls note that I am using the Tablet Mode.

Thanks in advance!

Panos