Canvas template - amending the collection

[philburns72]

I am struggling to take the 'first steps' of amending a canvas template power app, specifically the 'Annual Leave request' one.

I can amend the visuals, no problem, but I cannot work out how and where to amend the collections which define the categories and amount of leave allocated.

I must be missing something but cannot work out what.

Could someone point me in the right direction please?

[MarvinBangert]

Hey @philburns72 

have you checked the "App" on top of your screens?

In most of the templates, this is where the collections were stored to get created on app start.

Hope this will help you! 🙂

Regards

Marvin

[PowerAddict]

Both these collections are defined in the OnStart property of the app. 

Here's the collection that defines the allocations: 

ClearCollect(BalanceCollection,
        {
            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")
        }
)

Here's the collection that defines the types: 

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

Let me know if this helps. 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

[philburns72]

Thanks @MarvinBangert  - and is that the best place to amend what's there?

The data in there was slow to expand, when I looked initially I thought it only contained one or two lines.

[philburns72]

Thank you @PowerAddict Hardit, it's helpful to see it that way.

But this raises a new question for me - is it possible to set some of the collection in a conditional way?

I mean in this collection all users have Vacation:10

Would it be possible to do something so that staff members a, b and c have 10, but d, e and f have 15? - Where would that control be set?

[PowerAddict · Accepted solution]

No problem, glad I could help!

You can surely do that. Let's say the distinguishing factor among the employees is Employee Type (this field may not exist on the employee record, this is just for reference, you might want to use another field that makes the most sense). Then you can modify the the BalanceCollection (using your example) with something like this:

ClearCollect(BalanceCollection,
        {
            EmployeeEmail: _myProfile.UserPrincipalName, 
            EmployeeName: _myProfile.DisplayName , 
            Year: Text(Year(Now())), 
            Vacation:If(_myProfile.EmployeeType = "a" || "b" || "c", 10, If(_myProfile.EmployeeType = "d" || "e" || "f", 8)), 
            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")
        }
)

Let me know if this helps. 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
https://thepoweraddict.com

[PowerAddict]

Glad I could help! Good luck with the rest of your app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
The Power Addict
https://thepoweraddict.com