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.
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.
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.
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
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.
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.
Thanks for the idea! I am planning RUclips live training sessions. I may do the custom connector as part of YT live (if people take to the YT live videos)
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!
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 :)
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.
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
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?
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.
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
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 - ruclips.net/p/PLTyFh-qDKAiEIVlidnhELx5BusnzlDzkR
@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"
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 !!!
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 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?
@@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
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, Thank you. We will wait until RUclips 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.
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.
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.
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
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.
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.
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
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
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.
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?
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?
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.
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?
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?
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
@@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.
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.
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?
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!
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 ruclips.net/video/gb_FUeRjgg4/видео.html
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
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
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.
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.
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
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!
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 RUclips live training and there we can do a lot more in terms of specific use cases.
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?
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 😄😄
Idea would be to add filters to the gallery based on your types. Something like ruclips.net/video/5dSk5iOgT68/видео.html 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
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.
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 :)
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
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 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!
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 :)
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.
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)
@@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?
@@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.
@@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.
@@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 ruclips.net/video/EJyZfYMi4n0/видео.htmlsi=WXUeUClo77bYIjig
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
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
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.
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.
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
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!
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
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.
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
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 ?
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?
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?
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
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
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.
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
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
Is this only for tablet? I need an Employee Trade Request, Exemption request and crisis staffing shift pick-up app for Teams that’s accessible by phone. Do you have the mobile version video?
This App was built with Tablet experience. You can make Apps responsive by using the responsive containers. Check my playlist on responsive design - ruclips.net/p/PLTyFh-qDKAiHe6pHdlyBbRK1b44bNAAN_
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
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/
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 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/
@@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/
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
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.
@@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
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.
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
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.
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.
Hello Reza, I have an issue at my company where we manage 2 emails, and when filtering the galleries, it doesn't bring me the information because the two emails we manage do not match.
@@RezaDorrani Hello Reza, I have explored some solutions and I believe the answer is to have an additional field or column in the 'Leave Request' list where I can capture the email address. For example, when submitting the request, there should be a field called Email2 that contains my second corporate email address. How can I make this happen automatically without needing to enter the email manually?
I will have to look at your App in action to know the reason for your issue. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
can we auto fill/populate a few records of form when user is filling it. Ex If user is entering his employee ID, then His Dept, manager name, manger email should be auto filled. How can I achieved this?
You can query the user's information in AD or system of record in Power Apps and use the default property of the form controls to populate the data. I do not have a specific video on this scenario. I will recommend checking on the forums at powerusers.microsoft.com/
Looking for some help. The app is working in debug mode (all features works fine). But in production, the app doesn't display the leave info of the user and in the create leave application, the Leave Type option doesn't show.
I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@@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)
@@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 :)
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 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.
@@harveyroberts2274 This video on leave request + Approval flow dashboard video ruclips.net/video/d4e1whKVJU4/видео.html + Sample app in my GitHub repo github.com/rdorrani/PowerApps/tree/master/LeaveRequestApp
@@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.
@@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.
Video description has link to download sample App. As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
and you again nailed it with step by step video for us to follow ....Thank you so much Reza!!!
Thank You!
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.
Great to hear! Thanks so much for watching and liking the videos.
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.
Thank you for your kind words
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.
My lucky mascot :)
I am just thinking what you don't know in powerapps😊 This is truly amazing video Reza. Thank you very much.
Wow, thank you
I am unable to usee the app from github since it is asking me for an office 365 users connections and approvals connection
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
Reza You are the best. You know how to explain complicated things in simple way.
Thank You so much. Happy to hear the feedback.
this is one of the default templates in Powerapps. Is it because of you? Great video!
I have not built the default template. I have only expanded it.
Thank you for using the magnifier…It is very helpful
Keep it up with your great work!!
Thank you
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.
That would be a great if this application could do that 👋😁 thanks Joe and thank you Reza for this great video ✨🎈
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.
Yes I would also need this Reza good if you can add it. Thanks joe
Another request for including a holiday balance as well!! 🙂
Another request as well! Would love to see some sort of tracker/ calculator of how many days they have left once approved!
Great tutorial. This tutorial contains the info I was looking for to customize the already existing Power Apps template
Glad to hear that! Thanks for watching.
Thanks for attaching sample app template for us to download and looking forward for your youtube live session
you are most welcome
thank you so much Reza for your guidance and sharing of knowledge
Welcome!
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.
Thanks for the idea! I am planning RUclips live training sessions. I may do the custom connector as part of YT live (if people take to the YT live videos)
Thanks Reza, great video !
My pleasure!
Good job, excellent teacher !
Thank You!
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!
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 :)
❤ 2:22 ❤😂🎉😢😮😅😊 2:44
thanks Reza i'm actually looking to do something similar soon so this is great inspiration
Glad to hear that
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.
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
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?
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.
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
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 - ruclips.net/p/PLTyFh-qDKAiEIVlidnhELx5BusnzlDzkR
@@RezaDorrani , I see. I will follow your suggestions. Thanks again. :-)
@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"
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 !!!
Looks like you got the answer from the forums by some Mr Dorrani 😊
Glad you found Mr Dorrani 😃
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
Most welcome.
Please check my videos on role based power apps.
Thank you Reza! Great job and good information. So valuable :)
Thank you for watching
Thanks Reza. One question. How do you maintain approval flow URL in list?
I think I showed it in a different video.
Watch this ruclips.net/video/d4e1whKVJU4/видео.htmlsi=sVmPBRkssTJMeB3l
@@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?
@@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
As always such a good walkthrough, Reza. Any idea if we can pass the comments into the approval link, too?
For the comments, I did try with some random query param names but none worked.
@@RezaDorrani dang. I’m sure that will come, if not already available through some obscure method.
Thank you for another awesome video！
Thanks for watching
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
That is an issue with the Picture property. We would have to take the long route and query the users image from their profile.
@@RezaDorrani Hi Reza, can you please guide us on how to get this, as without the picture, the card looks pretty dull
@Reza Dorrani i could make it work, by using Office365users Photo
@@saiyash 👍
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?
Most welcome!
Not sure about region availability of memberships. Its a RUclips feature that channel owners can turn on.
@@RezaDorrani, Thank you. We will wait until RUclips 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.
@@DAVIDCYBERGURU This is the only channel I have
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.
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.
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
GetManager action in flow gets the users manager from AD.
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.
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.
You are the genius of geniuses
Wow! Thank You for your kind words.
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
I dont have plans to make an updated video on this one. I have video ideas in my backlog with 50+ requests
Thank you so much Reza very informative
Glad it was helpful!
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
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.
@@RezaDorrani thank you reza got it
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?
Possible but not something I have tried
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?
Please Check my latest 2 videos.
@@RezaDorrani thanks Sir
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.
Glad to know the video is helpful! Thanks so much for watching.
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?
ruclips.net/video/d4e1whKVJU4/видео.html
Nice Example and video. Can you share me schema or any for the SharePoint table used
This video was done long ago. I no longer have access to the table or its schema
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?
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
@@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.
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!
Awesome. Love it❤️
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.
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.
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?
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.
@@RezaDorrani okay thank you Rezza!
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!
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 ruclips.net/video/gb_FUeRjgg4/видео.html
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
@Reza Dorrani - i could make it work, by using office365 users Photo feature
office365 users Photo
👍
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
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.
@@RezaDorrani thank you very much I really appreciate it
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.
Not sure about this requirement.
Nice one👍🏻
Thanks ✌️
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
I do not have a reference video for that.
I will recommend checking on the forums at powerusers.microsoft.com/
This is gold!
Thank You
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!
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 RUclips live training and there we can do a lot more in terms of specific use cases.
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?
Both are possible but I would have to try it out to know the steps for how it would be orchestrated.
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 😄😄
Idea would be to add filters to the gallery based on your types. Something like ruclips.net/video/5dSk5iOgT68/видео.html
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
Thank you Reza !
Most welcome
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.
Hi, I have done very little work with Powerbi report server. I would recommend to check with Reza Rad. He has a RUclips channel named RADACAD.
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 :)
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
Can you add time to the "from" and "to"? Some individuals only take partial days.
Possible but not something I have tried or have a video reference for.
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
Use the thumbnail property. Check ruclips.net/video/vqK29FWbLxU/видео.html
@@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!
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 :)
Possible but not something I have tried
@@RezaDorrani ok thank you :)
@@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
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.
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)
@@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?
@@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.
@@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.
@@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 ruclips.net/video/EJyZfYMi4n0/видео.htmlsi=WXUeUClo77bYIjig
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
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
Thanks Raza for great video. Is it possible to cancel flow from Power App?
Not sure. My guess is No.
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 .
You mean the approval email - Yes, we can define it in approval email action itself by using dynamic content.
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.
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.
Hi! Excellent video. I have a question how do you get that link? 24:31
I don't know how to get that GUID
Video description has link to download sample app. You can check the logic in it.
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.
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
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!
The emojis are actually baked into the choice column values in SharePoint itself.
@@RezaDorrani I saw them, but thought yours were custom.
@@RezaDorrani How did you add those choices with emojis?
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!
@@shakesbeer23 Windows + .
This will open the emoji keyboard
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?
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
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.
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
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 ?
Power Apps and SharePoint both store data in UTC time. SharePoint displays dates and times based on regional settings of site.
@@RezaDorrani thanks Reza..that's true. Can we convert to different timezone in powerapps?
@@2007pradipta Yes, there are date time functions.
Hello, where can we find the video about those buttons on the top?
which buttons? what time in the video is it shown?
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?
Changed data type to person in the sharepoint list and it seems to have fixed the issue
Looks like you got it to work based on your response comment.
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?
@@akpomideno2464 Should not be the case. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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
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
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.
@@caiquesantosbarbosa2517 Awesome! So happy to hear that! Congratulations on the success and welcome to the world of the Power Platform.
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
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
Is this only for tablet? I need an Employee Trade Request, Exemption request and crisis staffing shift pick-up app for Teams that’s accessible by phone. Do you have the mobile version video?
This App was built with Tablet experience. You can make Apps responsive by using the responsive containers.
Check my playlist on responsive design - ruclips.net/p/PLTyFh-qDKAiHe6pHdlyBbRK1b44bNAAN_
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
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/
Great help! What if we want to add another party to the form like relief officer(s)?
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.
@@RezaDorrani Yes, and thanks for your reply. The relief officer can be one or two depending on the requestor.
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
@@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/
@@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/
Can we have calculations at backend in sharepoint which will have balance leaves and Monthly leave accumulation
Possible. But I do not have anh video references on it.
Thank you so much Sir!
Most welcome!
Hi Reza, just want to know can we trigger jenkins jobs from ms teams bots..please help me on this...
I have done no work with jenkin jobs connector (if there is one). I will recommend you check on the forums at powerusers.microsoft.com/
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
I do not have a video reference on that.
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 ?
Yes, you would need to build the backend SP list and connect your list to the app and flow.
Hi Reza.. can you explain how you generated the Approval Link in your Sharepoint link? I couldn't find where this is done in the patching process.
Here is the video link where I showcase how the flow was built
ruclips.net/video/d4e1whKVJU4/видео.html
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.
ruclips.net/video/d4e1whKVJU4/видео.html
Thank you so much
Most welcome
Hi Reza
Can we have some option to swap the already applied leave to some other employees name
Possible by using formulas. I do not have a video reference on this scenario though.
@@RezaDorrani can u let me know exactly how we can do pls
@@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
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
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.
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
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.
@@RezaDorrani I see. Thank you.
Hi Reza, I have a question, how did you connected that picture because I cannot do it
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.
Hello Reza, I have an issue at my company where we manage 2 emails, and when filtering the galleries, it doesn't bring me the information because the two emails we manage do not match.
I have not come across this scenario or issue. I would recommend checking or posting your query on forums at powerusers.microsoft.com/
@@RezaDorrani Hello Reza,
I have explored some solutions and I believe the answer is to have an additional field or column in the 'Leave Request' list where I can capture the email address. For example, when submitting the request, there should be a field called Email2 that contains my second corporate email address. How can I make this happen automatically without needing to enter the email manually?
@@cachacogames3769 I would have to try this out to know the steps. I would suggest checking or posting your query on forums.
hi reza. How will I connect the flow with the app to change status value pending
Done in a different video (I think) - ruclips.net/video/d4e1whKVJU4/видео.html
Excellent video following step by step but facing an issue in generating approval link, how to do this, please help me...
Check ruclips.net/video/d4e1whKVJU4/видео.html
Any reason why my approval dashboard does not filter data . Error "Getting your data" . but nothing get filtered.
I will have to look at your App in action to know the reason for your issue. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
can we auto fill/populate a few records of form when user is filling it. Ex If user is entering his employee ID, then His Dept, manager name, manger email should be auto filled. How can I achieved this?
You can query the user's information in AD or system of record in Power Apps and use the default property of the form controls to populate the data.
I do not have a specific video on this scenario.
I will recommend checking on the forums at powerusers.microsoft.com/
Looking for some help. The app is working in debug mode (all features works fine). But in production, the app doesn't display the leave info of the user and in the create leave application, the Leave Type option doesn't show.
I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi Reza, do you have a tutorial also on hot to setup sharepoint as first step? I would love it.
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
@@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)
@@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 :)
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.
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.
@@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.
@@harveyroberts2274
This video on leave request +
Approval flow dashboard video ruclips.net/video/d4e1whKVJU4/видео.html +
Sample app in my GitHub repo github.com/rdorrani/PowerApps/tree/master/LeaveRequestApp
@@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.
@@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.
Hi, I am having trouble selecting the card. It seems like the rectangle sent to the back is not clickable.
Video description has link to download sample App.
As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com