none
Leave Management - not able to deduct specific leave of respective employee

    Question

  • I am stuck here, any expert there who can guide me. I have 3 list viz;

    List:
    1)Types of leave
    2)Employee Leave Record
    3)Leave Request Form

    Types of leave: 
    coloumn: LeaveType
    - Sick
    - Casual
    - Annual

    Employee Leave Record: Employee Name (Group or person), Leave Types(lookup from Types of leave) Days(number), Requested days(number), Balance leave(Calculated (calculation based on other columns)


    Leave Request Form : Employee Name (Group or person), Leave Types (lookup from Types of leave), Start Date(date), Return Date(date), Requested Days (Calculated (calculation based on other columns)

    Work Flow is in Leave Request form

    Problem is, i want to find the specific balance leave of respective person and could not able to figure out 

    Workflow look up for number is like this: 

    Data Source: Employee Leave Record
    Field from Source: Balance Leave

    Field: Employee Name
    Value: Current Item: Employee Name (login name return field)

    but this not able to pinpoint particular person specific balance leave.  It  just goes in serial order :)
    Any guidence would be great help

    Balance leave





    • Edited by cosmicwave Saturday, March 18, 2017 10:25 AM
    Friday, March 17, 2017 5:53 PM

Answers

  • Seems like to this thread also I have to reply my self :P, Well friend i figure out the problem. 

    Mistake is in Employee Leave Record List. 

    Coloumn should be like this:

    Employee Name | Sick Leave | Casual Leave | Annual Leave| Sick Leave Taken | Casual Leave Taken | Annual Leave Taken |Sick Leave remaining | Annual Leave Remaining | Casual Leave Remaining

    No need to lookup leave types for this list.



    • Marked as answer by cosmicwave Saturday, March 18, 2017 10:29 AM
    Saturday, March 18, 2017 10:29 AM

All replies

  • Seems like to this thread also I have to reply my self :P, Well friend i figure out the problem. 

    Mistake is in Employee Leave Record List. 

    Coloumn should be like this:

    Employee Name | Sick Leave | Casual Leave | Annual Leave| Sick Leave Taken | Casual Leave Taken | Annual Leave Taken |Sick Leave remaining | Annual Leave Remaining | Casual Leave Remaining

    No need to lookup leave types for this list.



    • Marked as answer by cosmicwave Saturday, March 18, 2017 10:29 AM
    Saturday, March 18, 2017 10:29 AM
  • Hi cosmicwave,

    Thanks for sharing.

    Best Regards,

    Lisa Chen


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    Monday, March 20, 2017 5:53 AM
    Moderator