Hello Andrew. Thanks very much for your valuable video and happy new year. Your videos has really helped me a lot. I was wondering if you could give me a tip on how to solve an issue. The perfix after Claims always appearing in the app UI itseld and no picture appear as in the video. Thanks
Hi there !! Loved the video ! I was able to create the structure but don’t know how to automate the approver based on the org structure set up in teams. Do you have any videos on that ?
Hi Danielas! Currently I do not have any videos on that exact topic, but it may be on worth revisiting and creating a new video. Thank you for watching!
Thank you for great video! Only problem the People Picker script is not working ... any idea what i have to check ? ( we have new setup of office 365 Business Premium )
Thanks for the Video. Just a few questions. I would like to track the total number of days taken for leave of each user as a Colum in SharePoint. How do I also book out the leave in the users calendar? (Example if I want to book them for a meeting I can see the user is out of office or busy)
Hi HollowBl4de, So tracking the number of days would need to be a formula you would create when they book. You could probably find a date equation that subtract end date from start date and removes weekends and holidays. A tough one though as most "date math". And so for the second part, my only app that has done something similar was related to the template for "Book a Room" provided from Microsoft... but instead o seeing when the user was out it just would not let them book at that time. Here is that template it's worth a look: www.microsoft.com/en-us/power-platform/blog/power-apps/office-template-book-a-room-now-available/
What's your formula? I'm guessing your fields dont match up to "DataCardValue9" are you on a different DataCardValue? Use the color coding too that Power Apps gives you to double check.
Hi Andrew, watching this from the UK. Just a quick question. This functionality mostly now exists within Microsoft Shifts which I'm sure you've seen. However, what Shifts doesn't have is a limit to the amount of requests, or lets say an entitlement, nor a tracker which shows the staff what days they have already booked off and how many they have left. How easy would it be to create something to show this that integrates with Shifts functionality? is it possible? I am quite a newbie to all of this so your help would be greatly appreciated!
Hey Alexander, good question. I do know there is a connector to Shifts, but I have not used that much. Could checking out these actions in the connector help? learn.microsoft.com/en-us/connectors/shifts/
If you can find a good action from the connector that matches your requirements I bet you could implement something whether in Power Apps or Power Automate.
Thanks for the video - any suggestions on how to approach having quotas visible to users and approved requests subtract from these quotas? We have a number of different leave categories where I am and such a solution needs to accommodate them. Thanks again!
Most likely if you wanted to do this you may need to go to dataverse or something just a suggestion, not 100% necessary. But if you have a field "total quota" just whatever your leave time is subtract from that total column after an approval through Power Automate. This could add a good bit of complexity for a large app/workflow.
Very nice instruction as always. Thanks! For the Sharepoint intergration to work, all users would need read/write access to the Sharepoint list, correct? Or are the permissions done via the service account that creates the app? Just asking because our users are not allowed to see vacation requests of other users. Only way around would a flow, triggered by the power app I guess?
Yes they would need read/write access to SharePoint this way. You could go to dataverse instead and build security that way. Or like you said, yes, you could use Power Automate instead to write to the list using a service account.
Hi Steven, in Power Automate there is a Get Manager action that you can pull in, you just populate that step with the current user email or ID and it will get the managers metadata necessary to send them an email.
I’ve used the exact formula to make the button non-clickable, and it references the correct field name. However, when I add .Value, I encounter an error. Without .Value, the formula doesn’t produce an error, but it also doesn’t function as expected.
@@ChrissyRamirez-x3l Instead of .Value, is there something else the intelli-sense that it's expecting... maybe it's not .Value... It's .StartDate? .EndDate? .Name? .Address? What is the value in your datacard? The intelli-sense should guide you.
I found this issue. My Card Title and the Vaue holders did not have the same name. For example, my first field was named TitleDataCard1 but the text field was DataCardValue1
Thank you Andrew for showing this again! Love seeing Lists in SharePoint!
Oh yeah those Forms in SharePoint are slick! Thanks for watching beecee!
Hello Andrew. Thanks very much for your valuable video and happy new year. Your videos has really helped me a lot.
I was wondering if you could give me a tip on how to solve an issue. The perfix after Claims always appearing in the app UI itseld and no picture appear as in the video. Thanks
Exactly what I've been working on! Thanks for the timely content, looking forward to finishing this up. 👍
Nice! Perfect! 😁
Nicely explained Andrew 👍. I’m enjoying your content and have learned a great deal-thanks!
Thanks so much mw! Hope you can make an ever better app than me 😀
Hi there !! Loved the video ! I was able to create the structure but don’t know how to automate the approver based on the org structure set up in teams. Do you have any videos on that ?
Hi Danielas! Currently I do not have any videos on that exact topic, but it may be on worth revisiting and creating a new video. Thank you for watching!
Thank you for great video! Only problem the People Picker script is not working ... any idea what i have to check ? ( we have new setup of office 365 Business Premium )
Did you add the connector as a Data Source learn.microsoft.com/en-us/connectors/office365users/
Thanks for the Video. Just a few questions. I would like to track the total number of days taken for leave of each user as a Colum in SharePoint. How do I also book out the leave in the users calendar? (Example if I want to book them for a meeting I can see the user is out of office or busy)
Hi HollowBl4de, So tracking the number of days would need to be a formula you would create when they book. You could probably find a date equation that subtract end date from start date and removes weekends and holidays. A tough one though as most "date math". And so for the second part, my only app that has done something similar was related to the template for "Book a Room" provided from Microsoft... but instead o seeing when the user was out it just would not let them book at that time. Here is that template it's worth a look: www.microsoft.com/en-us/power-platform/blog/power-apps/office-template-book-a-room-now-available/
can someone help, I've copied the exact formula but the Submit button still appearing even if fields are blank
What's your formula? I'm guessing your fields dont match up to "DataCardValue9" are you on a different DataCardValue? Use the color coding too that Power Apps gives you to double check.
Hey Andrew, would like to check how to do the inverse? Availability Calendar?
Hi Fanyuan, there is an old template that uses room reservations that does this. Would need to reverse engineer that template.
Hi Andrew, watching this from the UK. Just a quick question. This functionality mostly now exists within Microsoft Shifts which I'm sure you've seen. However, what Shifts doesn't have is a limit to the amount of requests, or lets say an entitlement, nor a tracker which shows the staff what days they have already booked off and how many they have left.
How easy would it be to create something to show this that integrates with Shifts functionality? is it possible? I am quite a newbie to all of this so your help would be greatly appreciated!
Hey Alexander, good question. I do know there is a connector to Shifts, but I have not used that much. Could checking out these actions in the connector help? learn.microsoft.com/en-us/connectors/shifts/
If you can find a good action from the connector that matches your requirements I bet you could implement something whether in Power Apps or Power Automate.
Thanks for the video - any suggestions on how to approach having quotas visible to users and approved requests subtract from these quotas? We have a number of different leave categories where I am and such a solution needs to accommodate them. Thanks again!
Most likely if you wanted to do this you may need to go to dataverse or something just a suggestion, not 100% necessary. But if you have a field "total quota" just whatever your leave time is subtract from that total column after an approval through Power Automate. This could add a good bit of complexity for a large app/workflow.
Nicely done!
Thank you Michael!
Very nice instruction as always. Thanks! For the Sharepoint intergration to work, all users would need read/write access to the Sharepoint list, correct? Or are the permissions done via the service account that creates the app? Just asking because our users are not allowed to see vacation requests of other users. Only way around would a flow, triggered by the power app I guess?
Yes they would need read/write access to SharePoint this way. You could go to dataverse instead and build security that way. Or like you said, yes, you could use Power Automate instead to write to the list using a service account.
@@andrewhess123 awesome, thanks for confirming!
how do you make it so sends email to the manager?
Hi Steven, in Power Automate there is a Get Manager action that you can pull in, you just populate that step with the current user email or ID and it will get the managers metadata necessary to send them an email.
Great content, thanks a lot!
Thanks Patrick!
I’ve used the exact formula to make the button non-clickable, and it references the correct field name. However, when I add .Value, I encounter an error. Without .Value, the formula doesn’t produce an error, but it also doesn’t function as expected.
If(IsBlank(TitleDataCard1.value) Or IsBlank(StartDateDataCard1.value) Or IsBlank(EndDateDataCard1.value),DisplayMode.View,DisplayMode.Edit)
@@ChrissyRamirez-x3l Instead of .Value, is there something else the intelli-sense that it's expecting... maybe it's not .Value... It's .StartDate? .EndDate? .Name? .Address? What is the value in your datacard? The intelli-sense should guide you.
I found this issue. My Card Title and the Vaue holders did not have the same name. For example, my first field was named TitleDataCard1 but the text field was DataCardValue1
@@ChrissyRamirez-x3l Makes sense, nice!