Leave Request Power Apps Template - SharePoint

[@ArohShukla]

and you again nailed it with step by step video for us to follow ....Thank you so much Reza!!!

[@RezaDorrani]

Thank You!

[@greatkingrat]

For me, you’re one of the top helpful content providers on PowerApps. Your speed and details are perfect to learn from too, thank you very much for taking the time to post this.

[@RezaDorrani]

Great to hear! Thanks so much for watching and liking the videos.

[@bouseuxlatache4140]

Before even watching your Tutorial i wondered how on earth were you able to be so productive. I got to the point that yes your little Shrek is really helping you.

[@RezaDorrani]

My lucky mascot :)

[@ibitoyeolarewaju7498]

Reza, you have yet again come through for me right when I need you. Thank you so much. Not easy being a novice expected to deliver a pro solution. Thank you Reza.

[@RezaDorrani]

Thank you for your kind words

[@bairikrishna0808]

I am just thinking what you don't know in powerapps😊 This is truly amazing video Reza. Thank you very much.

[@RezaDorrani]

Wow, thank you

[@imanesennaria3264]

Reza You are the best. You know how to explain complicated things in simple way.

[@RezaDorrani]

Thank You so much. Happy to hear the feedback.

[@q2l867]

I am unable to usee the app from github since it is asking me for an office 365 users connections and approvals connection

[@RezaDorrani]

Those connections are needed when importing. I have not heard of anyone else run into this issue. I recommend posting your issue on forums at powerusers.microsoft.com

[@jray1429]

Thank you for using the magnifier…It is very helpful Keep it up with your great work!!

[@RezaDorrani]

Thank you

[@rajaamohammed6965]

Thanks for attaching sample app template for us to download and looking forward for your youtube live session

[@RezaDorrani]

you are most welcome

[@mastalayne]

this is one of the default templates in Powerapps. Is it because of you? Great video!

[@RezaDorrani]

I have not built the default template. I have only expanded it.

[@EuropasOcean]

Great tutorial. This tutorial contains the info I was looking for to customize the already existing Power Apps template

[@RezaDorrani]

Glad to hear that! Thanks for watching.

[@Soulebi03]

thank you so much Reza for your guidance and sharing of knowledge

[@RezaDorrani]

Welcome!

[@cbtjoe]

This is really great, Reza! I would love to see the next phase of this and this to add in a tracker for the manager to see the number of days already taken and days left before anniversary date in order for them to properly approve the request. Can you take the app there with us and and show some way of including a tracker. Since the number of days each employee earns is dependent on how long they have been with the organization, i suspect some formula would need to be included and the request form would need to know their hire date and work status (Part Time/Full Time) in order to make this calculation.

[@VANDIK01]

That would be a great if this application could do that 👋😁 thanks Joe and thank you Reza for this great video ✨🎈

[@RezaDorrani]

Will add it to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.

[@Maverick-uw1nc]

Yes I would also need this Reza good if you can add it. Thanks joe

[@casperlad84]

Another request for including a holiday balance as well!! 🙂

[@kennedyorr5249]

Another request as well! Would love to see some sort of tracker/ calculator of how many days they have left once approved!

[@yambodji]

Good job, excellent teacher !

[@RezaDorrani]

Thank You!

[@jpabal01007]

Reza, this is fantastic! Best tutorial and overview I have found! Is there an easy way to eliminate the HR role? or the Manager role? I am trying to deploy this for a graduate program for when our students apply for time off. In this case it would go to either one of two faculty (all within the same org, but they don't classify faculty as managers of students in O365), so could I just change the column for manager off? and then hard code the HR column to a choice of 2 different faculty whoever approves first? Also when I submit a request as a test it's sending it to MY manager lol and the flow is failing, so I am sure some adjustment is needed there too. Are you available for consulting on this? Any help is appreciated thank you!

[@RezaDorrani]

Thanks so much! This can be completely customized. The gallery part I set had 3 stages. You can change that whatever your scenario demands. This would require changes in both app and flow. I do not offer consulting support :)

[@SherSingh-bf1vf]

❤ 2:22 ❤😂🎉😢😮😅😊 2:44

[@0135827]

Thanks Reza, great video !

[@RezaDorrani]

My pleasure!

[@williamgondwe3842]

You are the genius of geniuses

[@RezaDorrani]

Wow! Thank You for your kind words.

[@Trysomieflexntjes]

Reza im hetero as fuck, but I fucking love you for this video!! I am in training for this new job and because of this video you gave me the extra push in my back to know what to do.

[@RezaDorrani]

Glad to know the video is helpful! Thanks so much for watching.

[@ramonlipparoni5515]

Hi Reza, thanks for a brilliant tutorial, being new to this whole thing, it's the perfect learning tool.. I have a few questions though, you refer to the SharePoint list, have you got a video on how to set that up first as I'm lost on how exactly to do that, and then, is there a way to link it to D365 F&O to update the HR module for the users leave applications and the last one I have, is how does one add the user's current leave balance onto the app to show how many actual leave days they have available to use?

[@RezaDorrani]

The list is a standard SharePoint list with columns. I do not have a video on how to set that up. Linking to D365 F&O is possible. I do not have that integration implemented though. My goal was to just show a prototype of what is possible.

[@brianofinch1]

Long time follower here. Your content is always so easy to follow. I am having an issue with the Leave Type radio buttons and text showing up on a New Request. I can see them when I preview the app via Power Apps studio. However when a user tries to input a new request all the Leave Type buttons are missing and unselect able. Any thoughts on where I should be looking for the problem?

[@RezaDorrani]

Thanks so much! Video description has link to download sample App. You can give that a try. As for the mentioned issue, I have not come experienced this and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@brianofinch1]

@@RezaDorrani Thanks for the reply. I did use the sample app but I will try and post to the forum and if I end up finding a solution I will post back. Thanks again and keep making great content.

[@brianofinch1]

Silly me. I did not republish the app after making the changes referenced on your How to sample app download. All works now! thanks again!

[@mails2jetti]

Thank you Reza for each video that you are going through the details. I would request you to do a video on custom connector in power apps if time permits.

[@RezaDorrani]

Thanks for the idea! I am planning KZbin live training sessions. I may do the custom connector as part of YT live (if people take to the YT live videos)

[@marounsader318]

hi reza, thank you for the clear guide, one question, can we create the approve and reject from withing the powerapp, rather than taking the user to flow screen and approve there again

[@RezaDorrani]

Can be done but will involve an unsupported method of updating the Approval Tables in Dataverse environment. Something that will require premium licensing for the App users as well. Best option would be to continue using flow.

[@marounsader318]

@@RezaDorrani thank you reza got it

[@Priya-ne2sw]

Thank you Reza for this wonderful video, can we add days available for each Leave Type option to show how many available leaves you have and how many taken. When create new leave request, it deduct from available days and show new balance?

[@RezaDorrani]

Possible but not something I have tried

[@segunajayi5360]

Thank you so much boss , you are easy to learn from. Pls ,the 2 buttons on the login screen to navigate to employees and manager approval screen, how do you define a role whereby if the manager button on the login screen Is clicked by users other than the manager,it wont be clickable except for the manager/ HR. Or make it invisible for other users except the manager. Thanks

[@RezaDorrani]

Most welcome. Please check my videos on role based power apps.

[@segunajayi5360]

Good job Sir, you are a Power app angel . Pls Sir ,do you have a video on power app approval without a flow. And if you don't, could you pls help with a tip of how to go abt it?

[@RezaDorrani]

Please Check my latest 2 videos.

[@segunajayi5360]

@@RezaDorrani thanks Sir

[@bdsnyderjr]

great video! is there a way to only allow a certain number of slots available per day based on another sharepoint list? For example: each day there are 5 time off slots, when someone puts in a request and is approved, there should only be 4 left and so on.

[@RezaDorrani]

Not sure about this requirement.

[@prijijohn1]

Hi Reza, Great videos, I followed this and created a similar app( Just a minor tweak to enter the time as well along with the date, for this I followed another video of yours). But surprisingly the SharePoint list is entering 1 hour behind the time which I had chosen from the power apps. I checked my Sharepoint Online time zone and it's the same as my local settings (UTC -6).Any comments will be appreciated.

[@RezaDorrani]

Nice! I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@DAVIDCYBERGURU]

Thank you Reza. I like your videos. They are all well done. How is it that i don't see membership to join here in Ghana?

[@RezaDorrani]

Most welcome! Not sure about region availability of memberships. Its a KZbin feature that channel owners can turn on.

[@DAVIDCYBERGURU]

@@RezaDorrani, Thank you. We will wait until KZbin turns on "join" for us in Ghana. Is there any other channel you have that I can join to get much of the membership option.

[@RezaDorrani]

@@DAVIDCYBERGURU This is the only channel I have

[@Gracecarragher-d5i]

Hi Reza, I love all your videos, especially when you and Mr. Christian team up. I hope I didn’t miss the answer to my question in the above comments, but what happens when a user has weekends in their request? My issue is that the weekend gets included and then it charges accrued time for those days. In my app, I added hours taken and so that gets messed up too. TL;DR - Is there a function that would only count days/hours that are not on weekends or holidays? Sorry for this Tome.

[@RezaDorrani]

Weekend logic would need to be coded in. This video was to give an idea as to what is possible. It can be expanded based on your needs. I do not have a video reference on the weekend scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@jamesanderson7346]

Another great tutorial, Reza. Much appreciated. Now that I have gotten this to work and look the way I want I would now like to have it work like an Outlook Calendar where you can select "All Day" for full and multiple day leave. I am struggling to find a way to make this work and think it might be over my head. Any suggestions? Thank you.

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@leetyler3102]

thanks Reza i'm actually looking to do something similar soon so this is great inspiration

[@RezaDorrani]

Glad to hear that

[@eduardoruiz973]

Thanks a lot Reza, one more question, how to develop the 'Login as an employee' and 'Login as an approver' interface?. Do you have another video where i can give me an idea?. Thanks

[@RezaDorrani]

I used the leave request power app template. It's just a screen with 2 buttons. You can show hide buttons based on user persona. I have done videos on user permissions. Check my Power Apps playlist - kzbin.info/aero/PLTyFh-qDKAiEIVlidnhELx5BusnzlDzkR

[@eduardoruiz973]

@@RezaDorrani , I see. I will follow your suggestions. Thanks again. :-)

[@JackCastro]

Thank you Reza! Great job and good information. So valuable :)

[@RezaDorrani]

Thank you for watching

[@muru4541]

Thank you so much Reza very informative

[@RezaDorrani]

Glad it was helpful!

[@Prkchps-N-Aplsaws]

Is it possible that you have another tutorial somewhere for adjusting the framework of this? For example, my needs don't require "HR Approval" as we don't have an HR

[@RezaDorrani]

I dont have plans to make an updated video on this one. I have video ideas in my backlog with 50+ requests

[@vivekmurli5137]

Nice one👍🏻

[@RezaDorrani]

Thanks ✌️

[@takis7gr]

Another excellent video! Two questions: 1. Is there any place to add day limitations? For example, an employee has 25 annual days and he should not be allowed to request for more than those days. 2. A manager should be able to have an overview of his team members and their leave days. I understand those are not implemented at the moment. is that right?

[@RezaDorrani]

Both are possible but I would have to try it out to know the steps for how it would be orchestrated.

[@mikemarsh7616]

Great videos Reza, thank you. May I ask how do you utilise a power app template and attach your data/list to it? I cannot see it on left pane? I may have missed a step. Thanks

[@RezaDorrani]

I built the App from scratch and copied pasted parts from the leave request app template. Even if you build app from a template there will be no indication on left pane about it. Video description has the link to download the sample App.

[@mikemarsh7616]

@@RezaDorrani thank you very much I really appreciate it

[@sangitapatil5075]

Thanks Raza for great video. Is it possible to cancel flow from Power App?

[@RezaDorrani]

Not sure. My guess is No.

[@liraspberry6966]

Thank you for another awesome video！

[@RezaDorrani]

Thanks for watching

[@SleepWalkerDhom]

Hi Rezza, amazing tutorial! I have followed your video but for the flow trigger, I just manually insert data in sharepoint list, instead of triggered the flow by using form in powerapps, In the video, you are not showing on how to create new request screen. Do you have similar video on that scenario?

[@RezaDorrani]

I did not build an end to end video on this. I believe I did make app available on my GitHub repo. Link is in video description.

[@SleepWalkerDhom]

@@RezaDorrani okay thank you Rezza!

[@uzairfarooq4622]

Awesome. Love it❤️

[@chadalthaus3866]

As always such a good walkthrough, Reza. Any idea if we can pass the comments into the approval link, too?

[@RezaDorrani]

For the comments, I did try with some random query param names but none worked.

[@chadalthaus3866]

@@RezaDorrani dang. I’m sure that will come, if not already available through some obscure method.

[@benseaburg9608]

Thank you Reza !

[@RezaDorrani]

Most welcome

[@vrindaradhakrishnan1798]

Hi @Reza. This was very useful. I have subscribed to your channel. However in this video, you have not showed how you filtered the gallery to only show "Approved" gallery items when you click the "Approved" button, and same way for other buttons "All", "Rejected", and "Pending". I could not find that information in this video, or your other linked videos in the description. Can you please provide link for the same, or help me with the logic?

[@RezaDorrani]

kzbin.info/www/bejne/mmXIYqqegLt9i5Y

[@JagatLearning]

Nice Example and video. Can you share me schema or any for the SharePoint table used

[@RezaDorrani]

This video was done long ago. I no longer have access to the table or its schema

[@Thebbk]

Thanks Reza. One question. How do you maintain approval flow URL in list?

[@RezaDorrani]

I think I showed it in a different video. Watch this kzbin.info/www/bejne/mmXIYqqegLt9i5Ysi=sVmPBRkssTJMeB3l

[@Thebbk]

@@RezaDorrani Thanks! It worked. One more question. After approve/reject the request and when I back to my app I have to refresh page to see changes. I mean in your video it immediately goes away. How to do it?

[@RezaDorrani]

@@Thebbk I have not come across the mentioned issue and hence not sure what the fix for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@pj.n6137]

Hi, I would like to ask some questions, if I have more types of requests not just "Leave request", HOW can I show or filter the status of all requests in just one gallery on the dashboard ////// OR could it BE POSSIBLE to filter the button to navigate to the dashboard that has pending requests like "A, B, C request" has the button "A, B, C" and "A and B have pending requests" so just show the button that has pending request? I just think this is interesting to make and could be useful. TY for great work 😄😄

[@RezaDorrani]

Idea would be to add filters to the gallery based on your types. Something like kzbin.info/www/bejne/a5W2nGifhMyHbJo I do not have a video reference on your exact scenario though and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@diegoramru1188]

Thank you so much Reza. I have a quiestion. When i published my APP, the images of people that create and aprove the request doesn't show (in edit it does). I used the formula: thisItem.'created by'.Picture..But not sure what could be the mistake.. Thaks a lot again

[@RezaDorrani]

That is an issue with the Picture property. We would have to take the long route and query the users image from their profile.

[@saiyash]

@@RezaDorrani Hi Reza, can you please guide us on how to get this, as without the picture, the card looks pretty dull

[@saiyash]

@Reza Dorrani i could make it work, by using Office365users Photo

[@RezaDorrani]

@@saiyash 👍

[@vandanpandya9587]

Thank you reza for a great video! Just one question, Could you please suggest any resources on how to maintain yearly leave balance? It would be great help. Thanks

[@RezaDorrani]

I do not have a reference video for that. I will recommend checking on the forums at powerusers.microsoft.com/

[@saiyash]

Hi Reza, thank you for another fantastic video. Love the way you structure and walk through the setups. One thing, am not able to get the picture of the manager or approver or created_by. I have used people group in SharePoint, and when I give the property of ThisItem.Manager.picture I get nothing. Not even the silhouette head. Any help on this please

[@saiyash]

@Reza Dorrani - i could make it work, by using office365 users Photo feature

[@RezaDorrani]

office365 users Photo

[@RezaDorrani]

👍

[@rogerbinny-e6h]

Hi Reza. Question: I am new to SharePoint and was hoping to follow your guidelines in creating the SharePoint list similar to your that is associated with this video. Please let me know. Thanks in advance.

[@RezaDorrani]

Hey, I did this video long while back and do not have access to that list anymore. The video is the only reference I have.

[@kkvideo99]

This is gold!

[@RezaDorrani]

Thank You

[@karladenisse6045]

Thank you so much Reza!! Great explanation. I have a question though, what happens when there are multiple people who need to approve the request? For example, If either manager A or B can approve, how can I put both images? Is there another video in which you address this? Thanks!

[@RezaDorrani]

You will need to add multiple image controls to showcase that information. I do not have a video on this specific use case. I have one with SharePoint formatting. Check kzbin.info/www/bejne/nZPCd4ibh8-anZY

[@NelsonONadal]

Hi Sir Reza, I downloaded this powerapps tutorial with power automate, the power automate in the link seems different from what used here (pls correct me if I'm wrong), I am trying to figure out when is the saving of HR and Manager is happening, what part of power automate, I am planning to just make it hard coded, thanks again for your videos and tutorials. - Nelson

[@RezaDorrani]

This video was done a long while ago. I do not remember the specifics. If you need certain changes, I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@paulpg9711]

HI Reza, excellent video, I have a little problem with the logic icon (status), in your demo you have 2 approvers, in my case i have 4 approvers, how can resolved for 4 approvers the logic icon, regards.

[@RezaDorrani]

Its been a long time since I’ve done this video. Do not remember the specifics. I would recommend posting your query on forums at powerusers.microsoft.com

[@blueoctober1]

Hi Reza, thanks once again for your detailed explanation! Is there any video you made about viewing pictures in a gallery on Android or ios mobile devices, pictures are stored in a SharePoint library, I'm struggling with that for a long time and I didn't find any clear answer on that, thank you so much once again

[@RezaDorrani]

Use the thumbnail property. Check kzbin.info/www/bejne/rKKuY2x8jMd_rrc

[@blueoctober1]

@@RezaDorrani Thank you so much for taking the time to answer me, very helpful video! Even though I've already resolved my problem with the thumbnail property for images , this will help a lot when playing with office documents!

[@olcsrilanka7005]

Hi Raza , Thanks a lot for excellent video. Any idea if we can pass the From and To date into the approval link ? currently it's only the leave type .

[@RezaDorrani]

You mean the approval email - Yes, we can define it in approval email action itself by using dynamic content.

[@Julian.Moreno87]

Thank you so much Sir!

[@RezaDorrani]

Most welcome!

[@fareedagbaje4920]

Great help! What if we want to add another party to the form like relief officer(s)?

[@RezaDorrani]

Im assuming you want to add another approver. You can add the approval logic to your flow and then make modifications in the App to show the additional approver in the status indicator.

[@fareedagbaje4920]

@@RezaDorrani Yes, and thanks for your reply. The relief officer can be one or two depending on the requestor.

[@fareedagbaje4920]

How can one automate the Title of the list items like automatically create a title say based on the initiator's name, date and time of creation

[@RezaDorrani]

@@fareedagbaje4920 You can do that by setting Default value of title data card in Power Apps. Give it a try and if you run into any issues then post it on the forums at powerusers.microsoft.com/

[@RezaDorrani]

@@fareedagbaje4920 Ok. You would need to handle your scenario in the app. Give it a try and if you run into any issues, then post it on the forums at powerusers.microsoft.com/

[@vvaassaanntthh]

Hi @reza in the list, you had two columns "manager" and "hr" as columns of type "people/group". In the flow it populates the managers using the "getnanager" step. But Can you please show how/where you defined the users and their managers? Did you have separate list for that, or you set it up in azure ad? Pls clarify in detail. Thanks a ton

[@RezaDorrani]

GetManager action in flow gets the users manager from AD.

[@beantlallh1743]

Can you add time to the "from" and "to"? Some individuals only take partial days.

[@RezaDorrani]

Possible but not something I have tried or have a video reference for.

[@maneenuchk6472]

Thank you so much

[@RezaDorrani]

Most welcome

[@anushyac6575]

Hi, Your videos are Amazing. Just want to ask a solution for PBIRS. Powerbi report server does not support email subscription(it does only for paginated reports and not for normal reports)Is there anything that can be done using Power automate to automatically send the reports from the powerbi report server to the user through mail.

[@RezaDorrani]

Hi, I have done very little work with Powerbi report server. I would recommend to check with Reza Rad. He has a KZbin channel named RADACAD.

[@princesathyaseelan.g1871]

Hi , reza bro is share point is important for this leave request app ? or, can we use any spread heet(like excell) please clarify my doubt

[@RezaDorrani]

You could use any sata source of your choice. SharePoint and Dataverse are better choices though as they can handle large data, provide security options etc.

[@WLEE100]

@10:00 where the status field is colored depending on the status. I'm trying to do that with the default record, but trying using Fill for the record with : If(ThisItem.Status.Value = "Submitted", Green, Red) errors with "Incompatible types for comparison. The left value is a Error and the right value is a Text"

[@WLEE100]

Found my answer in PowerApps User community, where it was answered by Mr Dorrani, who says that ThisItem isn't accessible in the Fill property BUT is in the TemplateFill... Who would know..... NOT me.... Thank you Reza !!!

[@RezaDorrani]

Looks like you got the answer from the forums by some Mr Dorrani 😊

[@RezaDorrani]

Glad you found Mr Dorrani 😃

[@mydwightstifler]

Reza, you are a GOD with this kind of things. I really enjoy learning by watching your tutorials. If I may ask, is this a series of tutorials? I watched the approval process tutorial. However, there are things I saw in here that I want to learn. Mainly, on how does the "Login as an employee" and "Login as an approver" works. How do I make sure that when an "employee" login, its his/her dashboard that would appear. I am also interested on learning how to put mini icons on those sharepoint list choices. Thank you!

[@RezaDorrani]

Most of my videos are more around learning specific features. The scenarios (leave request, work tracking etc.) are mostly from existing templates. I am planning KZbin live training and there we can do a lot more in terms of specific use cases.

[@rupaliborkar7372]

Can we have calculations at backend in sharepoint which will have balance leaves and Monthly leave accumulation

[@RezaDorrani]

Possible. But I do not have anh video references on it.

[@sukeshkumar7055]

Excellent video following step by step but facing an issue in generating approval link, how to do this, please help me...

[@RezaDorrani]

Check kzbin.info/www/bejne/mmXIYqqegLt9i5Y

[@itianypaolazaratediaz7028]

Hi! Excellent video. I have a question how do you get that link? 24:31 I don't know how to get that GUID

[@RezaDorrani]

Video description has link to download sample app. You can check the logic in it.

[@nguyenhuu2797]

Thanks for your great video Reza, how can i add more function like Leave balance in this template? it mean the total leave day each user can use, for ex: user A have 12days leave, user B have 14days per years.

[@RezaDorrani]

Possible. Depends upon your system of record where the leave balance info is maintained. My video is a basic sample of a leave request App that can be extended.

[@alexk7837]

A couple of questions. The data source SharePoint, how is it configured? Can anyone access it and see everyone else's leave requests and statuses? Any way to restrict submission to be accessible only by an employee who submitted it and subsequent approvers? Do you have to take your approvers to flow to approve? Why can't they stay in the app? Seems like a lot of user movements for a simple "approve/reject" action.

[@RezaDorrani]

I have done videos explaining SharePoint security and how it works with power apps. I would recommend checking them. I have also done a video on approval forms in power apps where approver can take decision in app (that technique does not use flow approvals though as flow approval decision requires user to go to flow)

[@alexk7837]

@@RezaDorrani Thanks for your reply. Do those videos explain how to achieve what I'm asking, or will they explain why this is not possible? If the latter, would you recommend exploring Dataverse/SQL backend instead of Sharepoint?

[@RezaDorrani]

@@alexk7837 I did not mention anything about it not being possible :) You will not find any video on the web on your exact use case. Videos are meant to share about a specific feature or how to achieve a generic task.

[@alexk7837]

@@RezaDorrani , good to know. You have a lot of content on the subject; maybe you can mention the one that closely matches the scenario I described - otherwise, I have to parse 30+ videos, which is a non-starter. Thanks for mentioning the power community somewhere in your reply. It is helpful but a UI or whatnot - searching for an answer is difficult there. I've also noticed many questions are left unanswered.

[@RezaDorrani]

@@alexk7837 Forums is a free platform where you may or may not get a response. If you need a definite response, then its better to get consulting help. A simple google search on “reza sharepoint security item permissions” would list out the video you are after. Here it is kzbin.info/www/bejne/e3vci5mPgs5npJIsi=WXUeUClo77bYIjig

[@sabrinafrancosafr.artisol4938]

Hi Reza, do you have a tutorial also on hot to setup sharepoint as first step? I would love it.

[@RezaDorrani]

I do not have a video on the list setup, but do have a post on the columns needed. Check github.com/rdorrani/PowerApps/tree/master/LeaveRequestApp

[@sabrinafrancosafr.artisol4938]

@@RezaDorrani thanks for answering, Indeed I found out checking the other comments. I followed all tutorial and the only issue now is taht when I try to submit a request it doesn't populare my sharepoint list.. any idea? thansk a lot Reza, I'm in HR (so not a techy but I managed to follow you in the process)

[@RezaDorrani]

@@sabrinafrancosafr.artisol4938 Thanks for following along. You need to remove the SharePoint connections in App and add new connections to your SP list. For your issue, I would have to look at your App in action. I will recommend you post your issue with screenshots on the forums at powerusers.microsoft.com/ You are techy since you installed the App :)

[@narmiazar]

Hello, Great video, but how about an option to withdraw a leave which has been approved? Please.

[@RezaDorrani]

This is an example of a leave request app based on a template that I extended. All other functions and processes can be added to it.

[@mystiquelassiter5972]

Hi! Thanks for creating this video. Question...for the emojis in the choice fields in the list...are you using JSON to add them? I haven't seen this format option demonstrated just yet. Do you have a video that covers it? Thanks again!

[@RezaDorrani]

The emojis are actually baked into the choice column values in SharePoint itself.

[@mystiquelassiter5972]

@@RezaDorrani I saw them, but thought yours were custom.

[@Gracecarragher-d5i]

@@RezaDorrani How did you add those choices with emojis?

[@Gracecarragher-d5i]

Sorry, I just figured out if I right click in the choice text it gives me the emojis. You're the best, keep it up!

[@RezaDorrani]

@@Gracecarragher-d5i Windows + . This will open the emoji keyboard

[@protocol12345]

hey Reza, thanks for the info. the sample app etc in your comments section and this be up loaded and modified on my own system ?

[@RezaDorrani]

Yes, you would need to build the backend SP list and connect your list to the app and flow.

[@caiquesantosbarbosa2517]

Good evening my friend how are you? I speak from Brazil and I would like some help to resolve some errors in the file you provided and I have several errors, the command (Filter('Leave Request', 'Created By'.Email = User().Email) does not work for some reason besides power apps detect multiple errors 30 accessibility, 1 performance and 21 formulas I'm new to power apps any study tips or support with this situation and validate thank you in advance for sharing this amazing material

[@RezaDorrani]

I’m doing well my friend. I did this video years ago and do not recollect any action with it. Accessibility are warnings and not errors. My data source and your data source can differ in column names, types etc. There could be various reasons for it. I recommend posting your issues with screenshots on the forums at powerusers.microsoft.com

[@caiquesantosbarbosa2517]

Good evening, Reza! I hope everything is great with you. I want to express my gratitude for your exceptional video. Inspired by your idea, I developed a purchase management system at the company where I work, incorporating three levels of approval: the manager at the first level, the controllership at the second, and the finance department at the third. The project has turned into something incredible, and I continue to add new features every day. Your video was a real turning point, leading me to dive into the world of Power Apps. Now, I find myself wondering how I managed to live so long without using it - it's truly a fantastic tool! Thank you so much for sharing your knowledge and for providing such enriching material. Your content is excellent. In Brazil, we have some resources on Power Apps, but none compare to the quality and depth of what you offer. Once again, thank you for making a difference with your work.

[@RezaDorrani]

@@caiquesantosbarbosa2517 Awesome! So happy to hear that! Congratulations on the success and welcome to the world of the Power Platform.

[@stephaniehalford-boudreau5456]

Is it possible after that to have a Leave tracking Board to go with this showing name of employee and date all the days in the month with green circle if in vacation that day or red circle if unpaid vacation, etc. ? Thank you :)

[@RezaDorrani]

Possible but not something I have tried

[@stephaniehalford-boudreau5456]

@@RezaDorrani ok thank you :)

[@stephaniehalford-boudreau5456]

@@RezaDorrani I will look at your video again, I start in Sharepoint, but I would love to have this feature in my SharePoint HR site ! Thank you

[@vvaassaanntthh]

Hi @reza thanks for this. However you did not show how you added the logic for the gallery to show only relevant items when the buttons below are selected All Pending Approved Rejected Can you add that details too, or point to the right video? I also didn't find that in your linked videos in the comments section.

[@RezaDorrani]

kzbin.info/www/bejne/mmXIYqqegLt9i5Y

[@charlene3490]

Hello, where can we find the video about those buttons on the top?

[@RezaDorrani]

which buttons? what time in the video is it shown?

[@kevinjoseph9023]

This is probably going to be a difficult question, but given your extensive experience in this space. I would benefit from anything you can offer. I’ve also built similar solutions as this and now I need to support this solution. How much do you charge a customer with regards to a service contract for the leave request power app solution. The customer is a public agency about 300 people.

[@RezaDorrani]

Its not a difficult question but one that I will not answer here on chat. About Tab of my channel has my email address information.

[@jhonnjcss6805]

Hi Reza, thanks for this fantastic tutorial keep up the excellent work. Can you help me out with an error, every time the app runs an error on the new request screen comes up saying " The specified user I:0#.f|membership| could not be found. Any idea what could it be? Thank you in advance.

[@RezaDorrani]

I would have to look at your App to know the reason for your error. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@jhonnjcss6805]

@@RezaDorrani thank you Reza

[@ferre4892]

What do I need to do with the collections in the template of power apps? When I add my sharepoint list, i only have errors?

[@RezaDorrani]

I have not come across this and hence not sure what the cause or fix for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@asmi3007]

Hi, i would like to know that in a list if a user apply for multiple sick leave how it will be recorded in a same sharepoint.

[@RezaDorrani]

I do not have a specific video on this scenario & would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@rosefall5541]

For the user to be able to fill out the form in the app they need permissions to add to the SharePoint list - which in turn gives them viewing permissions. Is there a way to prevent users from being able to find the SharePoint list and read everyone's leave requests?

[@RezaDorrani]

kzbin.info/www/bejne/e3vci5mPgs5npJIsi=hJjcToQ2wmL9UhGY

[@Ak07313]

Can you make video on real time project. In this project you can explain step by step in detail. i really need it

[@RezaDorrani]

Step by step real time is more on lines of training than a video. I have no plans to do that at this time. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@Ak07313]

@@RezaDorrani thanks

[@winterleong8467]

Hi Reza, thank you so much for this Leave request. i have a few quesitons. 1)due to the company organization chart, there is 2 departments that have 2 or more manager in the department. and they need to be approving this staff leave before going to our HR and Director. how can i do this?

[@RezaDorrani]

Not sure if I understood your question. If you need to update the approval process, you would need to make changes in the flow. You can query AD based on users department, grab approvers info and accordingly assign tasks.

[@umairfarooq3764]

Hi Reza, I have a question, how did you connected that picture because I cannot do it

[@RezaDorrani]

This video was done years ago. Video description may have link to download sample app or I may have shown that step in a different video as I remember doing 2 videos on this topic. You can search for that.

[@JFlogerzi]

Hi Reza, I am having trouble getting the data to show up from the SP List when looking at All, Pending, Approved, etc..... It shows loading data but nothing ever pulls. If I do a session Monitor of the app I can see it looking for data/rows but I get this info": "The number passed in is a blank value." even though I have submitted data :)

[@RezaDorrani]

I will recommend posting your issue with screenshots (of app in running, and edit mode along with formula for filtering) on forums at powerusers.microsoft.com

[@roshanperera292]

I need to include FROM and TO dates into the auto generated approval email notification . Currently it's only the details and the link . please share if any video on this . Thank you

[@RezaDorrani]

I do not have a video reference on that.

[@harveyroberts2274]

Reza, how did you add the emojis in your lists? Also are you using canvas app? This is exactly what I need. I have one created already, but needs you dated.

[@RezaDorrani]

Emojis are added as Choice values in my Choice column in SharePoint. Use Windows+. to launch the emoji keypad. Yes, I am using Canvas App.

[@harveyroberts2274]

@@RezaDorrani thank you for the information. I also would like to ask if you had a video on how you created the rest of the leave app? Mainly how did you create and link to the leave request form on the top right + symbol? Also the employee and approvor links to those pages. I'm trying to follow you to a "T" for we are using something similar, however yours is better. Thank you again.

[@RezaDorrani]

@@harveyroberts2274 This video on leave request + Approval flow dashboard video kzbin.info/www/bejne/mmXIYqqegLt9i5Y + Sample app in my GitHub repo github.com/rdorrani/PowerApps/tree/master/LeaveRequestApp

[@harveyroberts2274]

@@RezaDorrani thank you so much. I know have a good working leave app. One more question though.. how do I replace my existing leave request form on my list with this one? Meaning, when I click the New button in sharepoint I want it to open this new form and not the old one.

[@RezaDorrani]

@@harveyroberts2274 This is a standalone Power App. You are probably looking out for a SharePoint customized list form based Power App. There is no direct way to replace or transform the Power App.

[@hemangiektare8635]

Hi Reza, Thank you for this tutorial. I have a query, in my leave application I don't want the user to submit duplicate leaves/same days leaves. For example, if the user has submitted leaves from 1st to 5th Jan, then he shouldn't be able to submit leaves from 3rd to 5th Jan or any other overlapping days. Can you please help?

[@RezaDorrani]

For that, when user enters data and clicks the submit button - at this point you can query your data source and check if dates match data that’s already submitted and accordingly display error message. I do not have any video references on this scenario though. Give it a try and in case of issues - I will recommend posting the issue with screenshots on the forums at powerusers.microsoft.com

[@happymakkar5774]

Hi Reza I am new to powerapps . A project has assigned to create a travel approval powerapp with custom responses. What are screens and design that we can implement in travel approval app. Any help appreciated

[@RezaDorrani]

I may have done a video on travel request based scenario (I have 100+ videos so do not remember). I don't think I will have one with step-by-step guidance per screen. I will recommend you check on the forums at powerusers.microsoft.com/

[@krimsat]

Just wondering is it possible to make it for people who doesn’t have Microsoft account in your organisation. For example we have warehouse workers in our organisation who don’t have company email address but they have their own email. Would be it possible to have some sort of registration process for them to be able to login to this leave form request or they have to be registered under our company email address

[@RezaDorrani]

Power Apps (Canvas) requires users to have a Power Apps license. You could invite guest users for Power Apps however they would still need a Power Apps license.

[@krimsat]

@@RezaDorrani I see. Thank you.

[@ashiqhussain7396]

Hi Reza, When i am using Manager approval screen, Click on Approve or reject, its taking me to Approval link, as i am seeing your workflow taking your directly to the approval flow. need to your help to solve this. thank you

[@RezaDorrani]

I have not come across this issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@akpomideno2464]

Hi Reza, I'm trying to use the above video to create a leave request template. but every time I use the 'Created by' power apps complains about an invalid use of '.' when creating the sharepoint list, is 'created by' set to single line of text?

[@akpomideno2464]

Changed data type to person in the sharepoint list and it seems to have fixed the issue

[@RezaDorrani]

Looks like you got it to work based on your response comment.

[@akpomideno2464]

Hi Reza, Me again lol I'm having an issue with the approval link part of this. doesn't redirect me to the approval flow. Is this flow separate to the sharepoint list we created at the start?

[@RezaDorrani]

@@akpomideno2464 Should not be the case. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@2007pradipta]

How to manage different timezones issue if the power app environment in US and sharepoint in Europe timezone ? As power app show time in local so entering date and time might causes incorrect value. Can we force power app to work in US time zone ?

[@RezaDorrani]

Power Apps and SharePoint both store data in UTC time. SharePoint displays dates and times based on regional settings of site.

[@2007pradipta]

@@RezaDorrani thanks Reza..that's true. Can we convert to different timezone in powerapps?

[@RezaDorrani]

@@2007pradipta Yes, there are date time functions.

[@sumanaik5518]

Hi Reza Can we have some option to swap the already applied leave to some other employees name

[@RezaDorrani]

Possible by using formulas. I do not have a video reference on this scenario though.

[@sumanaik5518]

@@RezaDorrani can u let me know exactly how we can do pls

[@RezaDorrani]

@@sumanaik5518 I would have to try it out myself to know exact steps and I do not have the bandwidth to do that. I would recommend posting your query on forums at powerusers.microsoft.com

[@ashishbaranwal4044]

Have you created flow separately ?

[@RezaDorrani]

Here it is kzbin.info/www/bejne/mmXIYqqegLt9i5Y

[@KI_BHS]

ok. Nice but how to update your personal Calendar in Outlook. We are talking about an Office365 environment

[@RezaDorrani]

Use connectors. There are many available Office365Outlook,Outlook etc.