Thanks for sharing video. I have some issue with Total to use Sum function is not supported for power app. I can't get the total number of leave available and Token. Can you help me out?
Hi Anil, How can I maintain the leave balance for each employee? for example, I have 8 members in my team where can I manage the applied and balanced leave with their names?
Hi Anil, thanks a lot for your video. I found that you have deleted the 'Applied Leave' field and 'Balance Leave' field on the "Balance Leave " list. If I want to keep them on the list, how can I update the values when the leave is approved? Thanks a lot.
Hi Anil, thanks a lot for the tutorials they have been really useful. I have a question how do you set the policy for different cadre so that a person can see their exact leave days based on the different leave of employment. Thank you
You can create a list of cadre and manage leaves as per cadre then you need to filter your user belongs to respective cadre and then accordingly you can update leaves
hello sir i am facing some issues on sum formula can you please help me sum operation not supported by connectors : is line p code may ye issue arha hy ( ClearCollect(LeaveSum,Sum(Filter(LeavesAppliedByUsers,LeaveId.Value=Gallery5.Selected.LeaveId && RequestedBy.Email=User().Email),TotalDays)); ClearCollect(TotalLeave,Sum(Filter(BalanceLeave,LeaveId=Gallery5.Selected.LeaveId),'Total Leave')); ) and Leave Id b nahi arhae balance leave waly part ka full code and sharepoint lists mayn issue arha hy please help me
Hi Anil. Can you please explain after the rejection of applied leave,How to add the leaves again in our balance? I am facing approved and rejected for both leaves are reducing?
@@TipsByAnil: hi Anil, Thanks for Replying back. I have a sharepoint Point list Balance Leave have Columns ( leaveType, Year, Total_Leave, BalanceLeave, LeaveApplied, LeaveId, EmployeeName) under which I have added the below item for 1. Employee 1: ITEM1 :( AnnualLeave, 2022, 30, 30,0, Leave001,Emp001), ITEM2:( AnnualLeave, 2023, 30, 30,0, Leave001,Emp001),ITEM3 :( SickLeave, 2023, 30, 30,0,Leave002, Emp001), ITEM4 :( Maternity, 2023, 45, 45,0,Leave003, Emp001) 2. Employee 2 : ITEM1 :( AnnualLeave, 2022, 30, 30,0, Leave001,Emp002), ITEM2:( AnnualLeave, 2023, 30, 30,0, Leave001,Emp002),ITEM3 :( SickLeave, 2023, 30, 30,0,Leave002, Emp002), Under Power App -- Balance Leave When i import the Gallery : ITEM Field : Filter('Balance Leave','Employee Name'.Email =User().Email : - this display leave assigned to me, Leave Avaliable : Sum(Filter('Balance Leave', LeaveId =ThisItem.LeaveId),'Total Leave')-Sum(Filter('Leave of Absence',LeaveID.Value=ThisItem.LeaveId && 'Created By'.Email=User().Email),TotalDays) & " Days" -- Which you provided. But the Gallary display For EMPLOYEE one : Annual Leave 2 time ( for the year 2022, and 2023) - can we have a solution to group this into one
Hello Anil, I think you provided a good follow-up, and I have a question for you. How would you create a leave policy that is based on hours? For example, if I want to take a leave on a specific day but only need 2 hours off work. Also, if the total amount of time off work in a day reaches 7 hours, it should automatically count as a full day of leave. Also example if I take time off work to see a doctor, it should be considered as a sick leave. If the total amount of sick leave taken over time exceeds 8 hours, it should count as one day off from my total sick leave allowance.
Hi bro I'm working in startup, my manager assigned me two tasks 1) Payment approval requirst, approvals, payment done, and invoice attachment (like financ flow) 2) Leave application in teams And it should useabl by all employees and manager has to approve the leave, this thing I need to create in teams, But I don't have minimum idea also
Thanks for sharing video. I have some issue with Total to use Sum function is not supported for power app. I can't get the total number of leave available and Token. Can you help me out?
you didnt show the my leave coll sharepoint list
Hi Anil, How can I maintain the leave balance for each employee? for example, I have 8 members in my team where can I manage the applied and balanced leave with their names?
Hi Anil, thanks a lot for your video.
I found that you have deleted the 'Applied Leave' field and 'Balance Leave' field on the "Balance Leave " list. If I want to keep them on the list, how can I update the values when the leave is approved? Thanks a lot.
You can update it by patch function or workflow while approving leav
Hi Anil, thanks a lot for the tutorials they have been really useful. I have a question how do you set the policy for different cadre so that a person can see their exact leave days based on the different leave of employment.
Thank you
You can create a list of cadre and manage leaves as per cadre then you need to filter your user belongs to respective cadre and then accordingly you can update leaves
@@TipsByAnil Thank you
hello sir i am facing some issues on sum formula can you please help me sum operation not supported by connectors : is line p code may ye issue arha hy ( ClearCollect(LeaveSum,Sum(Filter(LeavesAppliedByUsers,LeaveId.Value=Gallery5.Selected.LeaveId &&
RequestedBy.Email=User().Email),TotalDays));
ClearCollect(TotalLeave,Sum(Filter(BalanceLeave,LeaveId=Gallery5.Selected.LeaveId),'Total Leave')); )
and Leave Id b nahi arhae balance leave waly part ka full code and sharepoint lists mayn issue arha hy please help me
Bonjour,
avez vous trouvé une solution à votre problème ? je suis confronté à la même situation.
Hi Anil. Can you please explain after the rejection of applied leave,How to add the leaves again in our balance? I am facing approved and rejected for both leaves are reducing?
After finishing everything how is going to available to all users?
You can share this with your organisation groups
how did u do the sum of of leave for more than a year. eg. 2022 - Annual leave 30day 2023 - 30
Can you explain more about it
@@TipsByAnil: hi Anil, Thanks for Replying back.
I have a sharepoint Point list Balance Leave have Columns ( leaveType, Year, Total_Leave, BalanceLeave, LeaveApplied, LeaveId, EmployeeName) under which I have added the below item for
1. Employee 1: ITEM1 :( AnnualLeave, 2022, 30, 30,0, Leave001,Emp001), ITEM2:( AnnualLeave, 2023, 30, 30,0, Leave001,Emp001),ITEM3 :( SickLeave, 2023, 30, 30,0,Leave002, Emp001), ITEM4 :( Maternity, 2023, 45, 45,0,Leave003, Emp001)
2. Employee 2 : ITEM1 :( AnnualLeave, 2022, 30, 30,0, Leave001,Emp002), ITEM2:( AnnualLeave, 2023, 30, 30,0, Leave001,Emp002),ITEM3 :( SickLeave, 2023, 30, 30,0,Leave002, Emp002),
Under Power App -- Balance Leave
When i import the Gallery : ITEM Field : Filter('Balance Leave','Employee Name'.Email =User().Email : - this display leave assigned to me,
Leave Avaliable : Sum(Filter('Balance Leave', LeaveId =ThisItem.LeaveId),'Total Leave')-Sum(Filter('Leave of Absence',LeaveID.Value=ThisItem.LeaveId && 'Created By'.Email=User().Email),TotalDays) & " Days" -- Which you provided.
But the Gallary display For EMPLOYEE one : Annual Leave 2 time ( for the year 2022, and 2023) - can we have a solution to group this into one
Hi Anil, Thanks for the video.
Could you explain on how to factor company holiday into the calendar. Thanks
Hello Anil,
I think you provided a good follow-up, and I have a question for you. How would you create a leave policy that is based on hours? For example, if I want to take a leave on a specific day but only need 2 hours off work. Also, if the total amount of time off work in a day reaches 7 hours, it should automatically count as a full day of leave. Also example if I take time off work to see a doctor, it should be considered as a sick leave. If the total amount of sick leave taken over time exceeds 8 hours, it should count as one day off from my total sick leave allowance.
Just put a drop down there and bind half day or full day leave accordingly deduct leaves from total leaves
Hi bro I'm working in startup, my manager assigned me two tasks 1) Payment approval requirst, approvals, payment done, and invoice attachment (like financ flow)
2) Leave application in teams
And it should useabl by all employees and manager has to approve the leave, this thing I need to create in teams,
But I don't have minimum idea also
Hi Anil,
Will you give training on PowerPlatform?
Yes