Leave Request Template with sharepoint list

(0) Share

Report

Posted on by mmchx

154

I just create the 2 sharepoint lists.

one for collecting all the leave requests ad one for the leave balance like this.

But I have a problem that, It works only for one user.

I mean on my Leave request app, I want the users to see how many leave balances each type that they have left. like this.

but I don't know how to make it works for all users.

Example

User A

sick leave balance (maximum) = 10, Annual leave balance (maximum) = 20
already request the annual leave 4 days ->> current annual leave balance = 20 - 4 =16

User B

sick leave balance (maximum) = 10, Annual leave balance (maximum) = 20
already request the sick leave 1days ->> current sick leave balance = 10-1 = 9

I don't know how can I make the sharepoint know that the current annual leave btw User A & User B is different , also how can I update the data for showing on the Power apps.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

WarrenBelz 155,501 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @mmchx ,

You need the user's email in the List and then compare this with the built-in function User().Email

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
mmchx 154 on at

Like (0)

Report
Copy link

Link copied!

So I need to create the user's email column on the ListTypeofLeave and another column to store the leave days that user requests right?
I'm sorry that I don't get how can I compare with the built-in function User().Email.
since power apps don't store anything

Was this reply helpful? Yes No
WarrenBelz 155,501 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
@mmchx ,

I am assuming ListTypeofLeave is a List? If you had a field called UserMail storing the User's email and another field called LeaveDays, you would get the value of that field in the current user's record with

LookUp( ListTypeofLeave, UserMail=User().Email ).LeaveDays

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
mmchx 154 on at

Like (0)

Report
Copy link

Link copied!

Yes, ListTypeofLeave is a List. I see appreciate it!
like this right? then if I want to the number of the current balance, I just calculate in power apps and update the value via power automate.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,501 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @mmchx ,

In your case, you have the user's name (the field would be better called NameUser), but disregarding this

LookUp( typeofleave, UserMail=User().FullName ).Current_AnnualLeave

would get the current annual leave.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
mmchx 154 on at

Like (0)

Report
Copy link

Link copied!

Got it Thank you very much, looks like on this part I need to manually create it without using the gallery lol.

Was this reply helpful? Yes No
WarrenBelz 155,501 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@mmchx ,

Is this solved now - if so please mark as solution.

Was this reply helpful? Yes No
mmchx 154 on at

Like (0)

Report
Copy link

Link copied!
arr, I have a problem with the lookup
based on your code, I set OnStart
set(currentUser,User().mail)
the power apps stored the user's mail correctly without error.
but when I applied to the Label like this
LookUp( typeofleave, NameUser= CurrentUser ).Current_AnnualLeave
It has the error on the equal sign "Incompatible types for comparison. These types can't be compared: Record, Text."
Even I change the currentUser to Office365Users.MyProfileV2().mail

Was this reply helpful? Yes No
mmchx 154 on at

Like (0)

Report
Copy link

Link copied!

Oh I got it, sorry for my dumb 😅

Was this reply helpful? Yes No
ElvinV 31 on at

Like (0)

Report
Copy link

Link copied!

I am confused, were you able to make it work?

Was this reply helpful? Yes No