Power Platform Community Forum Thread Details

Hi, I want to display available no. of leaves which is calculated on the basis of employment type of the employee and leave type using SharePoint lookup. Please help me with this.

I will try to explain it with an example, When an Employee selects leave type Annual Leave, it should check the employment type of the employee using User Mapping List (Ref: image 2), then it should check how many no. of leaves can an employee take, based on its employment type (Ref: image 3), so if the employee is permanent, and applies for annual leave, it should reflect Available leaves = 15, if the employee has not taken any leave in the past.

(Image 1)