Hello everyone, many people ask question about SharePoint list column. I request to you all don’t skip the video everything is there. See at 0:00:58 where I display list setting and there you can find column type RequestedBy: person or group RequestedTo: person and group From date: date and time To date: date and time TotalDays:number LeaveType:single line of text Leave description: single line of text LeaveId:lookup(from balance leave list column leaveid) Leavestatus : choice ( value: pending default and approved) I know there are many people have done with this video, can you guys please help to others as well . For demo purpose I created this site collection and got expired so not able to create video again, I don’t have any share point site now and license you know very costly
I am currently developing my application using my university admin account but the admin account has users that I can't use as I want to use my student email as a manager how can I overcome this
Hi Anil, I am just learning PowerApps, thank you for the tutorial it has been a Great Help. However can you please upload video tutorial on how to edit the leave collections. It will be greatly appreciated. Thank you.
@@TipsByAnil How can i stay the button selected for the event type of leave ? Because in your video, when i select a date for example, the event type goes unselected.
But when you will submit leave then gallery.selected.LeaveType you should get the selected value. On UI if button got un selected then on select event change the color of button, if on UI the button goes un selected it will not create problem in calculation
@@TipsByAnil Excuse me for my explanation, if i select a button for the event type, visually the pressed button appears in blank and not in blue. How can i modify this ?
Hi Anil thank you for your wonderful power apps video. I have one doubt In this video 00:33:15 you mentioned Updatecontext({_showSelectApprover}). I can't understand what is _showSelectApprover? Can you explain
Dear @TipsByAnil, Thank you so much for this wonderful playlist. With your guidance, I was able to set up an app for leave requests. However, I'm really struggling with setting up "Half Days" options. Could you please assist me with more detailed instructions? I have created the drop-down menu, but I'm unsure where to insert the calculation. Many thanks in advance for your support with this 🙂
Hi Anil, Great video.. please also make a video to edit the applied leave, if user changes his mind to take leave only 3 days instead of 3 days applied. It is useful if half day leave option is present
This is very helpful. A quick question, how can I implement multiple approvers? In my case for example, It goes to a supervisor, then Head of Department and finally HR.
Hi Anil, Thanks for the video. Could you explain more on excluding weekends or public holiday from the calendar. I have created a list of the holidays in SP. Thanks
Hi Sunil, Good Day. Here in 20:43 you have used office 365 Users; can I go ahead with SharePoint people and group only? if so, manager approval part how it'll work? Looking forward for a short discussion.
Hello @Anil. Can you share a video for the Edit option on My Leave Requests page? For Example, if the user requests a leave and change his mind then he should be able to make changes on it and then again request approval.
Hi Bro, Thank you so much for the beautiful, user friendly step by step guide. It is really helpful. Few help I needed to complete this leave app. Can you please help to calculate the carry over leave for each year?
Hi Anil, Thanks for your great sessions, have a doubt at 37:25, facing error while wrote the formula for text label to show approver name. "" If(IsEmpty(Label18_8),"choose manager",Gallery7.Selected.DisplayName)"" My Text label name is Label18_8 and gallery name is Gallery7. Please help me out. Struggling from last day
Hi Anil , Thanks for awesome video series. I want to ask one question here. What about the scenario where leave request gets rejected my the manager. How we are calculating their balance leaves(dynamically)
Hello Anil. Thanks for the video. But am stuck to gallery 7 sum collection. I am getting one out of the two sums for weeks now . Please help wit that . Thanks
Hi Anil, Thank You for creating the video from scratch it's so much helpful. I stuck on some point of part-8 can you just guide me. While creating the variable LeaveSum and LeaveTotals that you added as a 3 labels. And able to show in collection and give the leavesum and leavetotals values that part of video is not in this tutorial point how can i add the leavesum and leavetotal value in collections?
In 33:17 you are doing UpdateContext({_showApprover,false}), i would like to understand where you are defining the _showApprover, can you explain it please
Hi @Tips By Anil. I Have watched all the previous video and i didnt had any problems but in this video i am stuck on 54:39 my app is not calculating the LeaveValue. Could you please help me get through that also i tried to continue and then i got stuck again at 57:45 were you applied Updatecontext formula i have type exactly same formula but i got an error msg. Plus i have 8 Error msg in formulas could you please help on this i really want to get this app work. Thank you in advance. Regards, Amit
Hey Anil! Hope you doing well. I have faced some on LeaveID column in share point. can you please share Schema of Leave ID list. Means from where you doing calculated in BalanceLeave sheet
Hello @Anil, Thanks a lot for the training! I'm getting trouble in My Leave Request page, unable to see any data even when logging with different account. In the Create Request the formula didn't present any error, but the New Balance is not getting the current New Balance. I guess is something wrong in the Lists, already watched the other video. Can you please help?
Hi, At 37:23 time in this video ... While selecting the Approver name using Text=If(IsEmpty(Label25), "Click on Change Button" , Gallery6.Selected.DisplayName) ... I'm getting an error as "Invalid argument type(Control). Expecting a table value instead. Can you please help me out on this as I'm struck and need to finish this project by tomorrow.
At 1:11:14, this code can't calculated the values, the value of the total leaves in balance leave still appear as total balance, it can't substract the total days from it :(
Hi Anil, I viewed all the 9 parts. They are all Spot-On! Well Done!! This is really a great video and very helpful. I have one question though: We don't have a fixed number of Annual Leave days. Each employee has a specific number of days available to them which varies from user to user. How can I implement this please?
You have to create a SharePoint list where all users should be maintained and there you can define leaves yearly/ monthly/ quarterly. Now you need to display balance leave count from that list to apply filter with specific user row
@@TipsByAnil Thank you for your help. I have created a SharePoint List specifying columns for: user email, user displayname, Year, AnnualLeave, AnnualLeaveUsed, SickLeave, SickLeaveUsed. I have also connected the list to the app. Please will you be able to give me a code to use to display the balance leave count from this list to apply to specific user? Also, if you can tell me where in the app to put the code that will be very helpful. Thank you very much!
@@danielcecil951 hello dear kiya app mjhy ye issue solve krny may help karygy sharepoint list ye kesy banagey or iska code ya video ho to kindly help me plz
Hi anil, bleow command not working could you please help me data type showing as control If(IsEmpty(Label37),"Select or change",Gallery7.Selected.DisplayName)
Hi Anil - Thanks for your time and efforts, it will be more nice , if you upload Sample Excel file for the Users to Create app, with the Help of your Video and guideline.
Hi Anil, that is great project, we are using it now, thank you for explaining all the steps in details, I have been asked to add one more feature I don't know if you can help me or not but it's digital signature, is there a way that I can add digital signature section for the requester and the approver? we have DocuSign platform but I don't how to integrate with it or maybe if you have other idea like adobe acrobat or at least an indicator that shows as digital signature. thanks again
@@TipsByAnil Hi Anil, did you have a chance to look at that? and one more thing this will be used by all staff how can we add the balance credit for each employee? because each employees has different balance
Hi Anil, When I rejected the leave, It was deducted from the balance. But when we rejected the leave it should not be deducted and should be shown the last count right? How can I overcome this problem?
Hi Anil sir, Great teaching, very thank you for that. I have small problem in this video, exactly 37.31 and it's about formula , it's in your video:: If(IsEmpty(Label37), "click on change button" , Gallery8.Selected.DisplayName) but my practice i face problem that is [Invalid Argument type(control).Expecting a Table Value instead] I entered formula is If(IsEmpty(Label24), "click on change button" , Gallery7.Selected.DisplayName) can you help me with this.
Hi bro, Can you please explain me how we can edit the records . Because of the gallery, date picker,text input and labels are located in separate,not in form right. So how we can navigate the leave requests to edit screen
Hi Anil, thanks for the video. I am facing an issue in LeaveSum, it's calculated all TotalLeave, for example I have 21 vacation days and 8 sick days, so when I select the vacation, it's summed the vacation + sick that makes the current balance 29 days.
Anil Ji, In patch function can you explain - "Requested By, Requested To" Code once. most of viewers are struck at that point. can you please explain that code.
Hi Anil, thanks so much for your videos, I found them very interesting. I tried to reproduce and enanch all features you described. I followed first 8 but in my case the only thing doesn't work is the field LeaveId in LeavesAppliedByUsers table is updated with a strange string ("Digital Workplace Live: OneDrive tips & tricks") instead of LeaveId_001 for Vacation, LeaveId_002 for Sick Leave etc, and I'm not able to understand why. Can you please support me please?
Hi Anil, I practiced this video tutorial. This is really awesome and got to learn many things like component design and many other useful things. Just a question, how have you implemented logout screen and how are you refreshing the gallery after clicking on Approve or Reject button.
Hi Anil. At 47:25 , I got an error all over the formula of Submit Request Button. It says, "The function 'Patch' has some invalid arguments", "Invalid argument type. Expecting a record value, but of a different schema.", and "Missing column. Your formula is missing a column 'JobTitle' with a type of 'Text'. - What could be my mistakes Anil? I would really appreciate if you could reply to this. - I'm a first timer & don't have any programming knowledge/experience & excel formulas too. I just copy & pasting your formula while following your video tutorials. -------------------------------------------------------------------------------------------------------------------------- Patch('Employee Request Details', Defaults('Employee Request Details'), {LeaveType:Gallery4.Selected.LeaveType1}, {LeaveStartDate:StartDate.SelectedDate}, {LeaveEndtDate:EndDate.SelectedDate}, {LeaveDescription: txtLeaveDescription.Text}, { 'Requested by': {'@odata.type' : "#Microsoft.Azure.Connectors.Sharepoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & Lower(User().Email), Department: "", DisplayName: User().FullName, Email: User().Email, Jobtitle: ".", Picture: "."}}, {'Approved By': {'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExapandedUser", Claims: "i:0#.f|membership|" & Lower(_selectedApprover.Mail), Department: "", DisplayName: _selectedApprover.DisplayName, Email: _selectedApprover.Mail, Jobtitle: ".", Picture: "."}})
Hi Anil, your video is very helpful. Thank you very much. But I have a question about the patch function on the "Submit Leave" button. In the "RequestedTo" part, where does the variable "_selectedApprover" come from? I would be grateful if you can help me with this problem.
Thanks 🙏 watch complete video somewhere I created popup in this video and bind with all office365 users, there I created variable to capture selected user information. If you still not able to find out let me know i will tell you exact time where i did it
hello sir how you get data source in MyLeaveColl ? i am not getting data in galary by selecting ALL can you please share me that list from which you are getting all myleavecoll. and in variable collection there in no table record found in leavesum,totalleave and myleavecoll . can you please guide me how to set this error and how i get record from there variable collections
Dear Sir, Thanks for your amazing video, I followed your steps and it works well with me but at 1:22:38 I have faced something, I have created the Collection for MyLeavesColl but when I please on the All button I got now data from LeavesAppliedByUsers table,Knowing that I have data in LeavesAppliedByUsers table which is created from the app when I add new leave request, also I have no error found in All button just doesn't give me the data please I need your help thanks
Write your patch function with 2-3 columns only first and every hit just add one column in patch function then you can understand which column creating issue that issue let me Know
Thanks Mr. Anil for the beautiful guide of leave request. Can you please help in coding to calculate leave balance when the status of leave is rejected. In current setup when it is rejected the leave deducting from the total leave balance. Thank you again
Hi Anil, Thanks for creating such wonderful videos Could you please help me out I am stuck at 47:15 where at Submit Leave, if you can help me out I can complete this. Otherwise can you please send me that code here?
Hej Anil, I pretty much understand powerapps and how the lists are created,managed and how the apps are made in general. My only question for you is this. Did you just copy pasted the excel file list and created the SP list or did you do it on your own and used your own list as data for the app?
Created list manually on SharePoint site collection and balance leave data entered manually, leaves applied by user list data created when user create a leave request. See my previous videos also for better understanding
how did u bring the user names in the pop up, i cant add active users in admin area... is there any way i can add in sharepoint then pull the excel from sharepoint. am stuck in this phase pls help
How can I add a gallery to display the 3 next days after today ? For example, we are Wednesday and i would like to see Thurday & Friday of the week. Inside the gallery i have a Filter, to display if the user is "on site", or in "holidays".
can we make the manager name autopick from Azure AD? For example if my manager is ABC then the app will check Azure ad attributes and look for my manager.
Yes it's possible provide a dropdown there that having 2 option half day or full day and while inserting data just substract .5 days from date difference
Thank you @Anil, I am able to implement this successfully. However, the days are still deducted even when the leave has been declined. How can I resolve this?
Hi Anil, great series - thank you! Did I miss anyone taking you up on your offer to show the homework assignment to have the data showing when the screen appears (the 2 items you mentioned at the end of this #8 video)? I could use some help with that if you could point me in the right direction, that would be appreciated - thank you again for a great series!
Hi anil, with your help i have created the application still am not able to achieve the expected scenario, i have some doubts on the sharepoint side, it would be grateful if you do a video on sharepoint list for this leave request
Hi Anil! Thanks a lot these videos have been very useful. I am a first time powerapps user. After using the Patch function in the Submit Leave button when I run the app it shows me an error "Network error when using Patch function: Field 'Title' is required." Can you please help me resolve this ?
Hello, Thank you for this video.. Can you pls explain how you created a lookup column (LeaveID) in both the sharepoint list? Also, 1.I think there is no mention about the edit button in the leave details screen 2. When i create a new request, I see details about my old request still. 3. I get a delegation warning in the leave type gallery
Hi, the formula in the video helps reduce the number of leaves in the leave balance screen which is okay if the manager approves the leaves. But if the manager rejects the leaves, the leave count does not go back to the previous balance value. How can we modify that ?
Hi Anil, Watched all your tutorial videos for Leave management system. I have a scenario where my staff is from different vendors and have different leave allocation. How do i link the leaveid from Balance sharepoint list to Sharepoint list that is recording the leaves. Any response will be highly appreciated
Hi,the way of teaching is super..but i have one confusion requsted by and requested to coloumn code how you taken plese explain me.i tryed lot its not coming.
Hello Anil , very nice series you have done but schema for balance leave list and leave applied by user list not clear it would be great to have more focus on this i will wisting for your reply thank you.
Hey Anil,what exactly is in the LeaveId from the LeavesAppliedByUser SharePoint List? I know it's a Lookup column but what is the list source and the list column you're getting the LeaveId from?
Hi Anil Ji, Here 'Balance Leave' list there is a column added - LeaveID which is a lookup column in 'LeaveAppliedByUsers' list. Need column type for- LeaveID. Please help me
Appreciate for your video. I faced the issue that If another user uses the app, how can sharepoint or power apps how many balance leave of each type have left? example user A sick leave balance 8 days ->> current 5 days userB Sick leave balance 8 days ->> current 8 days but annual leave balance 10 days ->> current 7 days how can we show the current balance of each user?
When i am trying to submit leave, I cannot see "leave applied by user" sharepoint list populated. why?? please help. "leave applied by user" sharepoint list is already available in app. patchwork on submit leave button is correct. then why i cannot see the sharepoint list populated. please guide me.
I'm trying to translate the application with an Excel table. It's OK for the screens but how can i translate the menu on the left (components) and the text in the header ?
Sir, I have a doubt that after login as an employee when I login as a manager the 'leaves waiting for action' screen does not refresh.. Please let me know how to figure out this issue?
@@TipsByAnil OK. what would be the formula for (.5) day leave. can you tell me calculation formula on leaves calculation like applied leave, total leave and remaining leaves. "Applied Leave: " & daysdiff+1 &" Days" and "Available Leave: " & First(TotalLeave).Value-First(LeaveSum).Value-(daysdiff+1) & " Days"
Hi Anil. You are such a great tutor. Please i have been using your tutorials to build one for my team. However at ( 1hr 8 mins to 1 hr 13 mins). ... The leave balance is not calculating it refuses to change. . The LEAVESUM collection is not having values when I check it. Please help me. This is why the LEAVE BALANCE is not reducing even after I have applied for leave.
@@TipsByAnil thanks for attending to me. Do you mean the SharePoint list am using for the leave management only? If yes. I have just 3 list created as you did. Balance leave.... Same number of records with yours Company Holiday.. Same number of records. LeaveApliedByUser... Just one record.
on 1:04:20 the code: Value:Gallery6.Selected.Title gives me error. While typing VALUE it does not give me nothing, when i typed ID: it give me chanse to use it but VALUE no. Any idea where can be error? So what i mean when i add this {LeaveID:{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",ID:Gallery1.Selected.ID, Value:Gallery1.Selected.Title}} i get error in code, code is just like on your video tripl checked @Tips By Anil
Did you solve the issue? If not, try this {LeaveID:{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:Gallery1.Selected.ID, Value:Gallery1.Selected.Title}}
Hi Anil, I have tried everything to navigate to another screen after leave submit but did not work please help me out how to navigate when leave submit
Hello everyone, many people ask question about SharePoint list column. I request to you all don’t skip the video everything is there. See at 0:00:58 where I display list setting and there you can find column type
RequestedBy: person or group
RequestedTo: person and group
From date: date and time
To date: date and time
TotalDays:number
LeaveType:single line of text
Leave description: single line of text
LeaveId:lookup(from balance leave list column leaveid)
Leavestatus : choice ( value: pending default and approved)
I know there are many people have done with this video, can you guys please help to others as well . For demo purpose I created this site collection and got expired so not able to create video again, I don’t have any share point site now and license you know very costly
I am currently developing my application using my university admin account but the admin account has users that I can't use as I want to use my student email as a manager how can I overcome this
@@q2l867 what application you are buliding for univerity?
First time viewer.. Very useful and great videos. I am going through your videos now.
Thank you so much 🙂
Hi Anil, I am just learning PowerApps, thank you for the tutorial it has been a Great Help. However can you please upload video tutorial on how to edit the leave collections. It will be greatly appreciated. Thank you.
It's great. I'm searching to clear the fields in New Request after submitting.
It’s easy, you can clear it on submit button . Just update blank text in text box
@@TipsByAnil It's always simple when we know
@@TipsByAnil How can i stay the button selected for the event type of leave ? Because in your video, when i select a date for example, the event type goes unselected.
But when you will submit leave then gallery.selected.LeaveType you should get the selected value. On UI if button got un selected then on select event change the color of button, if on UI the button goes un selected it will not create problem in calculation
@@TipsByAnil Excuse me for my explanation, if i select a button for the event type, visually the pressed button appears in blank and not in blue. How can i modify this ?
Thanks for uploading...
Thanks keep watching
Hi Anil thank you for your wonderful power apps video. I have one doubt In this video 00:33:15 you mentioned Updatecontext({_showSelectApprover}). I can't understand what is _showSelectApprover? Can you explain
we use update context to create variables hence _showSelectApprover is a variable name you can use any name of your choice i hope it helps
Dear @TipsByAnil, Thank you so much for this wonderful playlist. With your guidance, I was able to set up an app for leave requests. However, I'm really struggling with setting up "Half Days" options. Could you please assist me with more detailed instructions? I have created the drop-down menu, but I'm unsure where to insert the calculation. Many thanks in advance for your support with this 🙂
At multiple places actually, sorry i can’t elaborate much here
Hi Anil, Great video.. please also make a video to edit the applied leave, if user changes his mind to take leave only 3 days instead of 3 days applied. It is useful if half day leave option is present
This is very helpful. A quick question, how can I implement multiple approvers? In my case for example, It goes to a supervisor, then Head of Department and finally HR.
You can, there is one video in my playlist multiple approval using powerautomate you can check that
@@TipsByAnil Thank you
Hi Anil, Thanks for the video.
Could you explain more on excluding weekends or public holiday from the calendar. I have created a list of the holidays in SP. Thanks
Hi Sunil, Good Day.
Here in 20:43 you have used office 365 Users; can I go ahead with SharePoint people and group only? if so, manager approval part how it'll work?
Looking forward for a short discussion.
Hello @Anil. Can you share a video for the Edit option on My Leave Requests page? For Example, if the user requests a leave and change his mind then he should be able to make changes on it and then again request approval.
thank you for video
Hi Anil, thanks for the video. Like others it was helpful for me as well. Just wanted to know can you show how to calculate compensatory off as well.
Hi Bro,
Thank you so much for the beautiful, user friendly step by step guide. It is really helpful. Few help I needed to complete this leave app. Can you please help to calculate the carry over leave for each year?
That’s possible you can create flow that will run at the end year day and update new year leave
@@TipsByAnil Thanks for the quick response. Can you guide if any resources you have pls
thanks for the video.
Thanks 🙏 keep watching
Hi Anil,
Thanks for your great sessions, have a doubt at 37:25, facing error while wrote the formula for text label to show approver name.
"" If(IsEmpty(Label18_8),"choose manager",Gallery7.Selected.DisplayName)""
My Text label name is Label18_8 and gallery name is Gallery7.
Please help me out. Struggling from last day
i have this problem too . please help anyone
@@nimeshjeewantha5227 , Can you try with put the name of other label instead of same label name
@@arifshaik9201 found this If(Value(""), "CLick on change button",Gallery5.Selected.DisplayName) it has worked for me
@@arifshaik9201 Tried but same result 😮💨
use this it worked for me If(
IsEmpty(Gallery6.Allitems),
"Click on Change Button",
Gallery6.Selected.DisplayName
)
@Tips By Anil can you please explain about the code on 1:04:20 - Value:Gallery6.Selected.Title cause i still did not figure it out
Hi Anil , Thanks for awesome video series. I want to ask one question here. What about the scenario where leave request gets rejected my the manager. How we are calculating their balance
leaves(dynamically)
Hello Anil. Thanks for the video. But am stuck to gallery 7 sum collection.
I am getting one out of the two sums for weeks now . Please help wit that . Thanks
Hi Anil,
Thank You for creating the video from scratch it's so much helpful.
I stuck on some point of part-8 can you just guide me. While creating the variable LeaveSum and LeaveTotals that you added as a 3 labels. And able to show in collection and give the leavesum and leavetotals values that part of video is not in this tutorial point how can i add the leavesum and leavetotal value in collections?
Hello Priya. Are you able to get respond regarding your question. I am also stuck at that point for weeks now
hello i am facing same issue can you plz send me code
In 33:17 you are doing UpdateContext({_showApprover,false}), i would like to understand where you are defining the _showApprover, can you explain it please
I understood, it is a Boolean variable defined for hiding the popup screen
Hi @Tips By Anil.
I Have watched all the previous video and i didnt had any problems but in this video i am stuck on 54:39 my app is not calculating the LeaveValue. Could you please help me get through that also i tried to continue and then i got stuck again at 57:45 were you applied Updatecontext formula i have type exactly same formula but i got an error msg.
Plus i have 8 Error msg in formulas could you please help on this i really want to get this app work.
Thank you in advance.
Regards,
Amit
Hi anil ,your video is very good, but there i want to know if any one decline leave so how to add requested leaves agin to employee bascket plz reply
What about delegation warning at 52:00 on OnSelect property of gallery.
Hey Anil! Hope you doing well. I have faced some on LeaveID column in share point. can you please share Schema of Leave ID list. Means from where you doing calculated in BalanceLeave sheet
Hi Parth did u solve this issue?
If you have solved this could you please help me out in this?
Hello @Anil, Thanks a lot for the training!
I'm getting trouble in My Leave Request page, unable to see any data even when logging with different account.
In the Create Request the formula didn't present any error, but the New Balance is not getting the current New Balance.
I guess is something wrong in the Lists, already watched the other video.
Can you please help?
Please also upload a video on edit this request
Ok sure i will try
Hi, At 37:23 time in this video ... While selecting the Approver name using Text=If(IsEmpty(Label25), "Click on Change Button" , Gallery6.Selected.DisplayName) ... I'm getting an error as "Invalid argument type(Control). Expecting a table value instead. Can you please help me out on this as I'm struck and need to finish this project by tomorrow.
Same problem
i fixed it using If(Value(""), "CLick on change button",Gallery5.Selected.DisplayName)
At 1:11:14, this code can't calculated the values, the value of the total leaves in balance leave still appear as total balance, it can't substract the total days from it :(
@TipsBySunil Could you share your balanceLeave sharepoint data table?
Hi Anil, I viewed all the 9 parts. They are all Spot-On! Well Done!! This is really a great video and very helpful. I have one question though: We don't have a fixed number of Annual Leave days. Each employee has a specific number of days available to them which varies from user to user. How can I implement this please?
You have to create a SharePoint list where all users should be maintained and there you can define leaves yearly/ monthly/ quarterly. Now you need to display balance leave count from that list to apply filter with specific user row
@@TipsByAnil Thank you for your help. I have created a SharePoint List specifying columns for: user email, user displayname, Year, AnnualLeave, AnnualLeaveUsed, SickLeave, SickLeaveUsed. I have also connected the list to the app. Please will you be able to give me a code to use to display the balance leave count from this list to apply to specific user? Also, if you can tell me where in the app to put the code that will be very helpful. Thank you very much!
@@danielcecil951 hello Daniel can you plz help me in sharepoint list balance leave formula
@@TipsByAnil hello sir can you please send me this list video and code i am facing this problem
@@danielcecil951 hello dear kiya app mjhy ye issue solve krny may help karygy sharepoint list ye kesy banagey or iska code ya video ho to kindly help me plz
Is there any other way or substitute of office 365 user list for approver list and automation?
Hi anil, bleow command not working could you please help me
data type showing as control
If(IsEmpty(Label37),"Select or change",Gallery7.Selected.DisplayName)
If(IsBlank(Label37),"Click on change button",Gallery5.Selected.DisplayName): IsEmpty change it to IsBlank
Hi Anil - Thanks for your time and efforts, it will be more nice , if you upload Sample Excel file for the Users to Create app, with the Help of your Video and guideline.
Ok I will try
HI Anil , your video is awesome, but after submiting data is not loaded in sharepoint list can you help me in that
What issue you are getting
@@TipsByAnil After Clicking on Submit Leave my data was not replicate in sharePoint List
Hi, in the My Leave requests screen can you tell how will you configure the Edit button in the Leave Details gallery ?
Hi Anil, please do video on edit screen.It's really helps to us
Ok
Hi Anil, that is great project, we are using it now, thank you for explaining all the steps in details, I have been asked to add one more feature I don't know if you can help me or not but it's digital signature, is there a way that I can add digital signature section for the requester and the approver? we have DocuSign platform but I don't how to integrate with it or maybe if you have other idea like adobe acrobat or at least an indicator that shows as digital signature. thanks again
Digital signature I need to check Barzan
@@TipsByAnil Hi Anil, did you have a chance to look at that? and one more thing this will be used by all staff how can we add the balance credit for each employee? because each employees has different balance
Hi Anil Sir, Could you please explain this project after 43 mins if possible . I have completed all ur videos . Thank you so much for ur best videos
Hello please watch one of my video leave application user error int that you will get details
Great series - many thanks. Were there any security settings applied for accessing SP list directly and not through PowerApps?
Hi Omar did you fully completed this app?
hi anil...where how you created MYLeavesColl list?
Hi Anil, When I rejected the leave, It was deducted from the balance. But when we rejected the leave it should not be deducted and should be shown the last count right? How can I overcome this problem?
Hi Anil sir, Great teaching, very thank you for that.
I have small problem in this video, exactly 37.31 and it's about formula , it's in your video:: If(IsEmpty(Label37), "click on change button" , Gallery8.Selected.DisplayName) but my practice i face problem that is [Invalid Argument type(control).Expecting a Table Value instead]
I entered formula is If(IsEmpty(Label24), "click on change button" , Gallery7.Selected.DisplayName)
can you help me with this.
up up We also encountered this issue.
Hi bro,
Can you please explain me how we can edit the records . Because of the gallery, date picker,text input and labels are located in separate,not in form right.
So how we can navigate the leave requests to edit screen
You can hold record in global variable and pass it to screen
Hi Anil, thanks for the video. I am facing an issue in LeaveSum, it's calculated all TotalLeave, for example I have 21 vacation days and 8 sick days, so when I select the vacation, it's summed the vacation + sick that makes the current balance 29 days.
ruclips.net/video/oYu3kB2Hy8I/видео.html
Anil Ji, In patch function can you explain - "Requested By, Requested To" Code once. most of viewers are struck at that point. can you please explain that code.
Hi Anil, thanks so much for your videos, I found them very interesting. I tried to reproduce and enanch all features you described. I followed first 8 but in my case the only thing doesn't work is the field LeaveId in LeavesAppliedByUsers table is updated with a strange string ("Digital Workplace Live: OneDrive tips & tricks") instead of LeaveId_001 for Vacation, LeaveId_002 for Sick Leave etc, and I'm not able to understand why. Can you please support me please?
Hi Anil i am not able to get leave type .I am getting 'leave type' 41:22
Hi Anil,
I practiced this video tutorial. This is really awesome and got to learn many things like component design and many other useful things. Just a question, how have you implemented logout screen and how are you refreshing the gallery after clicking on Approve or Reject button.
Hey yes screen is refreshing according sorry to delay in responding
Hi Anil. At 47:25 , I got an error all over the formula of Submit Request Button. It says, "The function 'Patch' has some invalid arguments", "Invalid argument type. Expecting a record value, but of a different schema.", and "Missing column. Your formula is missing a column 'JobTitle' with a type of 'Text'.
- What could be my mistakes Anil? I would really appreciate if you could reply to this.
- I'm a first timer & don't have any programming knowledge/experience & excel formulas too. I just copy & pasting your formula while following your video tutorials.
--------------------------------------------------------------------------------------------------------------------------
Patch('Employee Request Details', Defaults('Employee Request Details'),
{LeaveType:Gallery4.Selected.LeaveType1},
{LeaveStartDate:StartDate.SelectedDate},
{LeaveEndtDate:EndDate.SelectedDate},
{LeaveDescription: txtLeaveDescription.Text},
{ 'Requested by':
{'@odata.type' : "#Microsoft.Azure.Connectors.Sharepoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(User().Email),
Department: "",
DisplayName: User().FullName,
Email: User().Email,
Jobtitle: ".",
Picture: "."}},
{'Approved By':
{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExapandedUser",
Claims: "i:0#.f|membership|" & Lower(_selectedApprover.Mail),
Department: "",
DisplayName: _selectedApprover.DisplayName,
Email: _selectedApprover.Mail,
Jobtitle: ".",
Picture: "."}})
up
up
i also got the same error. did you resolved it??
Try with single text column first then go one by one, it’s running code
@@TipsByAnil glad to see your reply sir. Sir which column you are talking about??
Hi Anil thanks for video just wanted to know how to set manger view for Navi item i am not able to understand that
I posted a video recently watch that I also put the link in comments
Hi Anil, your video is very helpful. Thank you very much. But I have a question about the patch function on the "Submit Leave" button. In the "RequestedTo" part, where does the variable "_selectedApprover" come from? I would be grateful if you can help me with this problem.
Thanks 🙏 watch complete video somewhere I created popup in this video and bind with all office365 users, there I created variable to capture selected user information. If you still not able to find out let me know i will tell you exact time where i did it
Oh I got it. Sorry I rushed to ask the question. I just found out that you explained about it later
@@mayanli4623 Hi Mayan i am facing the same issue can you help me out to solve this ?
Appreciate ur reply.
hello sir how you get data source in MyLeaveColl ?
i am not getting data in galary by selecting ALL can you please share me that list from which you are getting all myleavecoll. and in variable collection there in no table record found in leavesum,totalleave and myleavecoll . can you please guide me how to set this error and how i get record from there variable collections
Dear Sir,
Thanks for your amazing video, I followed your steps and it works well with me but at 1:22:38 I have faced something, I have created the Collection for MyLeavesColl but when I please on the All button I got now data from LeavesAppliedByUsers table,Knowing that I have data in LeavesAppliedByUsers table which is created from the app when I add new leave request, also I have no error found in All button just doesn't give me the data please I need your help thanks
How many records you have in list? Also after applying leave just get this data in collection and check your collection
@@TipsByAnil Thanks a lot man for your reply I have 3 records applied to my list, I followed exactly your steps
@@mohamednasr5444 I have stuck 47.20 min .patch function showing error patch has some invalid arguments. can you help me in this?
Write your patch function with 2-3 columns only first and every hit just add one column in patch function then you can understand which column creating issue that issue let me
Know
Hi anil leave id is not working as per 1:04:12 , any reason for that
Thanks Mr. Anil for the beautiful guide of leave request. Can you please help in coding to calculate leave balance when the status of leave is rejected. In current setup when it is rejected the leave deducting from the total leave balance.
Thank you again
ruclips.net/video/oYu3kB2Hy8I/видео.html
Hi Anil,
Thanks for creating such wonderful videos
Could you please help me out I am stuck at 47:15 where at Submit Leave, if you can help me out I can complete this.
Otherwise can you please send me that code here?
Hej Anil, I pretty much understand powerapps and how the lists are created,managed and how the apps are made in general. My only question for you is this. Did you just copy pasted the excel file list and created the SP list or did you do it on your own and used your own list as data for the app?
Created list manually on SharePoint site collection and balance leave data entered manually, leaves applied by user list data created when user create a leave request. See my previous videos also for better understanding
how did u bring the user names in the pop up, i cant add active users in admin area...
is there any way i can add in sharepoint then pull the excel from sharepoint. am stuck in this phase pls help
How can I add a gallery to display the 3 next days after today ?
For example, we are Wednesday and i would like to see Thurday & Friday of the week.
Inside the gallery i have a Filter, to display if the user is "on site", or in "holidays".
can we make the manager name autopick from Azure AD? For example if my manager is ABC then the app will check Azure ad attributes and look for my manager.
Yes you need to get data from organization chart
Great series Anil, I have a funny question, is it possible to apply half day (0.5) instead of a full day?
Yes it's possible provide a dropdown there that having 2 option half day or full day and while inserting data just substract .5 days from date difference
Thank you @Anil, I am able to implement this successfully. However, the days are still deducted even when the leave has been declined. How can I resolve this?
You can apply a filter if leave status is approved then deduct only
Hi Anil, great series - thank you! Did I miss anyone taking you up on your offer to show the homework assignment to have the data showing when the screen appears (the 2 items you mentioned at the end of this #8 video)? I could use some help with that if you could point me in the right direction, that would be appreciated - thank you again for a great series!
Tipsbyanil1@gmail.com
Hello Joan, did you manage to get assistance with this?
@@xoliswamazomba80 No, but I worked through my confusion. thank you though.
Hi anil, with your help i have created the application still am not able to achieve the expected scenario, i have some doubts on the sharepoint side, it would be grateful if you do a video on sharepoint list for this leave request
Ok i will
@@TipsByAnil Thank you so much anil, looking forward for your update
@@TipsByAnil when will you upload the video on sharepoint list
Hi Anil! Thanks a lot these videos have been very useful.
I am a first time powerapps user. After using the Patch function in the Submit Leave button when I run the app it shows me an error "Network error when using Patch function: Field 'Title' is required." Can you please help me resolve this ?
ruclips.net/video/oYu3kB2Hy8I/видео.html
So how to create "Connections" Total Leave and LeaveSum at time 54:38
Hello, Thank you for this video.. Can you pls explain how you created a lookup column (LeaveID) in both the sharepoint list?
Also,
1.I think there is no mention about the edit button in the leave details screen
2. When i create a new request, I see details about my old request still.
3. I get a delegation warning in the leave type gallery
ruclips.net/video/oYu3kB2Hy8I/видео.html
Hi, the formula in the video helps reduce the number of leaves in the leave balance screen which is okay if the manager approves the leaves. But if the manager rejects the leaves, the leave count does not go back to the previous balance value. How can we modify that ?
ruclips.net/video/oYu3kB2Hy8I/видео.html
Please Anil, where did "Component 1" come from? I can't seem to understand the magic there
Hi Anil, Watched all your tutorial videos for Leave management system. I have a scenario where my staff is from different vendors and have different leave allocation. How do i link the leaveid from Balance sharepoint list to Sharepoint list that is recording the leaves. Any response will be highly appreciated
ruclips.net/video/oYu3kB2Hy8I/видео.html
Thanks for such a nice app. Anil how we can create travel approval app with custom responses.
Enjoy buddy send me requirements in email will look into it
great vedio, but how to exclude the weekends if the weekends is friday and saturday instead of sat and sun ??
Try this -
UpdateContext({
daysdiff:
RoundDown(DateDiff(StartDate.SelectedDate, EndDate.SelectedDate) / 7, 0) * 5 +
Mod(5 + Weekday(EndDate.SelectedDate, StartOfWeek.Sunday) - Weekday(StartDate.SelectedDate, StartOfWeek.Sunday), 5)
})
Hi Anil Ji ,Can You please explain the Request to and Request By Code one more time i stuck there itself.
Watch my new video recently uploaded
Hi,the way of teaching is super..but i have one confusion requsted by and requested to coloumn code how you taken plese explain me.i tryed lot its not coming.
ruclips.net/video/oYu3kB2Hy8I/видео.html
Hello Anil , very nice series you have done but schema for balance leave list and leave applied by user list not clear it would be great to have more focus on this i will wisting for your reply thank you.
ruclips.net/video/oYu3kB2Hy8I/видео.html
57:44 can someone explain hy this is showing error in my project?
Hey Anil,what exactly is in the LeaveId from the LeavesAppliedByUser SharePoint List? I know it's a Lookup column but what is the list source and the list column you're getting the LeaveId from?
Hi Israel Pratt did u solve this issue?
If you have solved this could you please help me out in this?
Hi Sir i am not able to understand that Value:Gallery6.Selected.Title cause i still did not figure it out
Can we get notifications by emails or anything that there is new pending leave?
sure you can implement power automate workflow
Hi Anil,
How have you updated the field leave status in sharepoint. i tried but my leave status is not updating.
Are you talking about patch function where user submitted the leave or when manager approved leave?
How did u add the users in Office 365 user?
@tips by anil patch function is not at all working. its saying that network error while using patch function the request operation is invalid
ruclips.net/video/oYu3kB2Hy8I/видео.html
Value:Gallery6.Selected does not work on 1:04:20 (my gallery is 4)
am actually on same issues, did you find solution?
Hi Anil, do you have a video explaining how to create this list in sharepoint?
Ok sure
Hi Anil Ji, Here 'Balance Leave' list there is a column added - LeaveID which is a lookup column in 'LeaveAppliedByUsers' list. Need column type for- LeaveID. Please help me
It’s coming from leave balance list i think and it is text type in that
Appreciate for your video.
I faced the issue that If another user uses the app, how can sharepoint or power apps how many balance leave of each type have left?
example
user A sick leave balance 8 days ->> current 5 days
userB Sick leave balance 8 days ->> current 8 days but annual leave balance 10 days ->> current 7 days
how can we show the current balance of each user?
The same we have implemented in this video, we are filtering data by some of leaves applied by user
hi did you solve this scenario can you please assist me on that if you have done that
When i am trying to submit leave, I cannot see "leave applied by user" sharepoint list populated. why?? please help. "leave applied by user" sharepoint list is already available in app. patchwork on submit leave button is correct. then why i cannot see the sharepoint list populated. please guide me.
Check your email
I'm trying to translate the application with an Excel table.
It's OK for the screens but how can i translate the menu on the left (components) and the text in the header ?
Sorry I didn’t tried it with excel
Sir, I have a doubt that after login as an employee when I login as a manager the 'leaves waiting for action' screen does not refresh.. Please let me know how to figure out this issue?
once it will go on production will refresh auto or you can put refresh button there
Can you please explain patch function leave Id
Hello Anil ,
Why when the request to leave is rejected, it is deducted from the balance
No you need one more filter on leave balance screen if leave is approved only in this case it will deduct not in rejected case
@@TipsByAnil Can you help me with how to add a filter?
Hello Anil WHEN YOU WILL MAKE HALF DAY LEAVE REQUEST VIDEO
Days are busy since one month didn’t uploaded anything
@@TipsByAnil OK. what would be the formula for (.5) day leave. can you tell me calculation formula on leaves calculation like applied leave, total leave and remaining leaves. "Applied Leave: " & daysdiff+1 &" Days" and "Available Leave: " & First(TotalLeave).Value-First(LeaveSum).Value-(daysdiff+1) & " Days"
Hi Anil. You are such a great tutor.
Please i have been using your tutorials to build one for my team. However at ( 1hr 8 mins to 1 hr 13 mins). ... The leave balance is not calculating it refuses to change. . The LEAVESUM collection is not having values when I check it. Please help me. This is why the LEAVE BALANCE is not reducing even after I have applied for leave.
How many records you having in SharePoint list?
@@TipsByAnil thanks for attending to me. Do you mean the SharePoint list am using for the leave management only? If yes. I have just 3 list created as you did.
Balance leave.... Same number of records with yours
Company Holiday.. Same number of records.
LeaveApliedByUser... Just one record.
@@TipsByAnil please help me out
Still stuck need to check your application on screen share I think
hello @Olaiya Olumide can you plz help me? i am facing same issue
on 1:04:20 the code: Value:Gallery6.Selected.Title gives me error. While typing VALUE it does not give me nothing, when i typed ID: it give me chanse to use it but VALUE no. Any idea where can be error? So what i mean when i add this {LeaveID:{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",ID:Gallery1.Selected.ID, Value:Gallery1.Selected.Title}} i get error in code, code is just like on your video tripl checked @Tips By Anil
Did you solve the issue?
If not, try this
{LeaveID:{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:Gallery1.Selected.ID, Value:Gallery1.Selected.Title}}
Sir how to pull status values to SharePoint as default?. Quick reply will be much appreciated😊
while you creating list column there is option to set column default value
Leave request template is not working. How to fix this? Please
Hi Anil, I have tried everything to navigate to another screen after leave submit but did not work please help me out how to navigate when leave submit
Share code
On the submit button, your request is submitting??
If possible please make video how we can add half day leave in this leave app thanks in advance
Sure
@@TipsByAnil when will you upload half day leave video
@@TipsByAnil HI WHEN YOU WILL MAKE HALF DAY LEAVE REQUEST VIDEO