Thanks for this another great tip! Min 10:19 building on top of what you taught in this video, I was able to configure with nested DateAdd Dropdown end Time so that the items property always got a timevalue greater than than dropdown start Time. Thank you Again.
Great video! I had to build something very similar recently. After fighting and fighting with using Bookings and then Resource Calendars as the datasource, I opted to store the bookings in Sharepoint as well.
Hi Shane, awesome video, very helpful video. I have question, how to prevent overlapping date? For example, if a room (room A) booked from 1pm - 2pm, and another user wants to book same room from 12:30pm - 2:30pm, how to prevent that? Thanks
Hi Shane, I work for a company that offers employee transportation services. Currently, ten drivers handle these requests, scheduled through phone calls and emails. As the company undergoes workflow changes, we're encouraging everyone to use Microsoft Teams. After a phone or email booking, an employee creates a task(to do planner) in Teams and assigns it to a driver. Being new to the transportation sector, I noticed the potential of using bookings for appointments. However, since our company culture prioritizes Teams, I'm working on a Power Automate flow. Ideally, after an employee books a transport through MS Bookings, the flow would automatically create a Teams task for the assigned driver (chosen randomly based on availability). Unfortunately, I'm facing challenges. While I can create a Teams task upon booking, it lacks automatic driver assignment and content, leaving it blank. I sincerely appreciate your cooperation! Thank you for your time and effort.
This is exactly what i need right now. Following the steps and failing with the first steps of adding a column? has this function now changed? Ill keep trying! Thanks for all the videos, i have learnt so much!
I have the same problem. Can't get "AddColumns(Sequence(12,0), "MyTime", DateTimeValue("12:00 AM"))" to work, and it's such an important first step, not really sure where to go from there
Hey Shane I have a query. I want to make a vehicle servicing app. This is easy enough but where I’m stuck is my work has opening hours, lunch hours and other activities that take time away from the normal working day. What I was thinking was having the servicing broken into total hours from a Sharepoint table in the background to complete. So the person picks the date and the service type. The power app automatically knows the hours that are not working hours and populates the calendar and the date the vehicles would be available for collection. Hope this makes sense
Hey Shane - another great video highlighting some lesser-used functions and the importance of core skills. Thanks! Question, for the Sequence in the ForAll Patch, could you use Countrows(Gallery)? Or do you not have them appearing in the gallery UNTIL you patch?
Hi Shane, Thank you for all your videos. This has helped me a lot in my work. I have a question about the time slots. Is it possible to tweak this to have slots available for multiple days with different start time and end time on each day? For e.g., I am hosting a show from Monday to Friday. I start at 8am and end at 4pm on Monday and Tuesday and for the rest of the days its from 9am to 3pm. Any ideas on how to accomplish this?
Vishnu I don't have any videos that would help other than this. Sorry. You will just have to iterate on this video. If I was you, I wouldn't try to do it all at once though. Baby step through the process and solve a bunch of small problems instead of the one big problem.
Great Video, anyway can you make another tutorial of how to make the room booking system automatically available if the user forgets to checkout the room? Thankyou
Hi Shane, This is great, really. I am desperate to create a calendar/schedule/event like this for my school IT Rooms. Is there an downloadable example that can be used to edit?
Hey - do you have a movie on how multiple people can book a traingroom ... and when they are going to the room they check in and check out and then the booking time should delete the booking and put in the absolute time for check in and check out. People can also se who is training ... live... if they let them or just anonym.
HI Shane, I have found this very useful and I think it is exactly what I am after, however is it possible to have multiple people book on to the same time slot. For example if i had an event and there were 5 spaces for that slot, could it be open until the limit has been reached?
Yes, you would have to create logic that tracks how many people have booked the slot and the logic that locks out when the number is full. OR Would it be easier to create 5 slots for each time slot and then have them fill in more like we did in this video? But either way you should be able to get there. :)
Hi@@ShanesCows I followed your video but the button i created to submit all the data is returning an error message. The Value '04/10/202300.00' cannot be converted to a date or time value. any help?
Can you make a tutorial for an app that can track employees breaks, employees can click on break button also see how much break is pending and manager can view which employee is currently on a break also approve break requests ?
Hello Shane, is there a tutorial to display an overview of all meetings from multiple meeting rooms? So list the calendar events of the day? We've had this configured with a Digital Signage Solution but development stopped recently so now we want to use Powerapps to accomplish the same. Thank you in advance! W.
Hi Shane, this helped me a kot. But I am still stuck. I need your help. I have a gallery with my calendar on it and I am not able to filter my time slots gallery with the selected date. Could you please help me with this
I'm struggling to get 'TimeSlot' to populate as a date/time in my SharePoint list and the galleries its tied to. Its only populating the date and I've checked my work/compared it to yours and I can't find the obvious problem. Any thoughts?
Hello Shane - Thank you for all the help with your videos. at 9:03, I'm able to make the dropdown for time selection but in my case I'm using date and time in single date/time column instead of separate column for date and time. How do update my date/time column to get the time from this dropdown selection? I tried the "DateValue3.SelectedDate + (Dropdown4.Selected.myTime)" in the update property of my date/time column. But no luck.
@@ShanesCows thank you I found it love the library. Slowly getting through it. I meet Daniel Christian and showed him one of my apps I created that is now going national. Inspired by you him and Reza. Mention showing casing on Power Addicts. The app is changing my organization culture.
Hello Shane - Thanks for the wonderful video. i want to add one more option for create event. while creating event i need to add 5 rows for each time slots instead of one slot. can you please help me with this ?
Hi Shane, is it possible to create date ranges for time slot? e.g. business hours Create time slot For 3/23/2023 - 3/30/30/2023 8:30 AM - 11:00 AM 30 min sessions time slots Thank you
Yes, I have done that for a customer. Took this concept and just added to it. Sorry, I don't have a video but I built from here by loop through the other days. Showed each day in its own gallery to make it look nice.
Hi Shane, Do you have a video on transport booking system. I need to create an app for users to book transport for a particular day and time and also consider the seat available for each transport. Any ideas will be highly appreciated
Thanks for this another great tip! Min 10:19 building on top of what you taught in this video, I was able to configure with nested DateAdd Dropdown end Time so that the items property always got a timevalue greater than than dropdown start Time. Thank you Again.
High five! Great job. 🤩
Thanks so much. I learned and am learning a lot with your information videos and demos. Saludos desde Costa Rica. Pura Vida.
My pleasure!
Great video! I had to build something very similar recently. After fighting and fighting with using Bookings and then Resource Calendars as the datasource, I opted to store the bookings in Sharepoint as well.
Sad when build it yourself is the best answer. Glad you got it. :)
This is great! This is like Microsoft Bookings but better
Thanks! 😃
Another great video and has given me a few ideas for a few things I have been working on.
Awesome. Good luck on your project 😎
Awesome video Shane, Thank you
Glad to help and always I appreciate your support here and on Twitter. Thanks 🐶
Hi Shane, awesome video, very helpful video. I have question, how to prevent overlapping date? For example, if a room (room A) booked from 1pm - 2pm, and another user wants to book same room from 12:30pm - 2:30pm, how to prevent that? Thanks
Hi Shane, I work for a company that offers employee transportation services. Currently, ten drivers handle these requests, scheduled through phone calls and emails.
As the company undergoes workflow changes, we're encouraging everyone to use Microsoft Teams. After a phone or email booking, an employee creates a task(to do planner) in Teams and assigns it to a driver.
Being new to the transportation sector, I noticed the potential of using bookings for appointments. However, since our company culture prioritizes Teams, I'm working on a Power Automate flow.
Ideally, after an employee books a transport through MS Bookings, the flow would automatically create a Teams task for the assigned driver (chosen randomly based on availability). Unfortunately, I'm facing challenges. While I can create a Teams task upon booking, it lacks automatic driver assignment and content, leaving it blank. I sincerely appreciate your cooperation! Thank you for your time and effort.
Thanks for another great video! :)
My pleasure!
Love this one!
Thanks Shawn. :)
Awesome!
1. Can multiple people register for a time-slot?
2. And where does the creator get a notification?
Are teams-meetings created by this?
🔥 thanks for Guide 💙
Happy to help!
Thanks Shane
Happy to help.
This is exactly what i need right now. Following the steps and failing with the first steps of adding a column? has this function now changed?
Ill keep trying!
Thanks for all the videos, i have learnt so much!
I have the same problem. Can't get "AddColumns(Sequence(12,0), "MyTime", DateTimeValue("12:00 AM"))" to work, and it's such an important first step, not really sure where to go from there
@@crmudrick same problem, anyone know how to fix this?
Hey Shane I have a query.
I want to make a vehicle servicing app.
This is easy enough but where I’m stuck is my work has opening hours, lunch hours and other activities that take time away from the normal working day.
What I was thinking was having the servicing broken into total hours from a Sharepoint table in the background to complete. So the person picks the date and the service type. The power app automatically knows the hours that are not working hours and populates the calendar and the date the vehicles would be available for collection.
Hope this makes sense
As always the best!
Hey Shane - another great video highlighting some lesser-used functions and the importance of core skills. Thanks! Question, for the Sequence in the ForAll Patch, could you use Countrows(Gallery)? Or do you not have them appearing in the gallery UNTIL you patch?
Never mind - answered my own question. Sorry, too early for an old brain...
Glad you got it figured out. :)
Hi Shane,
Thank you for all your videos. This has helped me a lot in my work.
I have a question about the time slots. Is it possible to tweak this to have slots available for multiple days with different start time and end time on each day?
For e.g., I am hosting a show from Monday to Friday.
I start at 8am and end at 4pm on Monday and Tuesday and for the rest of the days its from 9am to 3pm.
Any ideas on how to accomplish this?
Vishnu I don't have any videos that would help other than this. Sorry. You will just have to iterate on this video.
If I was you, I wouldn't try to do it all at once though. Baby step through the process and solve a bunch of small problems instead of the one big problem.
Great Video, anyway can you make another tutorial of how to make the room booking system automatically available if the user forgets to checkout the room? Thankyou
Hi Shane, This is great, really. I am desperate to create a calendar/schedule/event like this for my school IT Rooms. Is there an downloadable example that can be used to edit?
Hey - do you have a movie on how multiple people can book a traingroom ... and when they are going to the room they check in and check out and then the booking time should delete the booking and put in the absolute time for check in and check out. People can also se who is training ... live... if they let them or just anonym.
HI Shane, I have found this very useful and I think it is exactly what I am after, however is it possible to have multiple people book on to the same time slot. For example if i had an event and there were 5 spaces for that slot, could it be open until the limit has been reached?
Yes, you would have to create logic that tracks how many people have booked the slot and the logic that locks out when the number is full.
OR Would it be easier to create 5 slots for each time slot and then have them fill in more like we did in this video? But either way you should be able to get there. :)
Hi@@ShanesCows I followed your video but the button i created to submit all the data is returning an error message. The Value '04/10/202300.00' cannot be converted to a date or time value. any help?
Can you make a tutorial for an app that can track employees breaks, employees can click on break button also see how much break is pending and manager can view which employee is currently on a break also approve break requests ?
Hello Shane, is there a tutorial to display an overview of all meetings from multiple meeting rooms? So list the calendar events of the day? We've had this configured with a Digital Signage Solution but development stopped recently so now we want to use Powerapps to accomplish the same. Thank you in advance! W.
Hi Shane, this helped me a kot. But I am still stuck. I need your help. I have a gallery with my calendar on it and I am not able to filter my time slots gallery with the selected date. Could you please help me with this
I'm struggling to get 'TimeSlot' to populate as a date/time in my SharePoint list and the galleries its tied to. Its only populating the date and I've checked my work/compared it to yours and I can't find the obvious problem. Any thoughts?
Hello Shane - Thank you for all the help with your videos. at 9:03, I'm able to make the dropdown for time selection but in my case I'm using date and time in single date/time column instead of separate column for date and time. How do update my date/time column to get the time from this dropdown selection? I tried the "DateValue3.SelectedDate + (Dropdown4.Selected.myTime)" in the update property of my date/time column. But no luck.
@ShaneYoung This is nice is this available on the power 911 as a subscriber I havent seen any of your newer videos and demos there.
It is Gary. Feel free to email if you are having a hard time finding things. :)
@@ShanesCows thank you I found it love the library. Slowly getting through it. I meet Daniel Christian and showed him one of my apps I created that is now going national. Inspired by you him and Reza. Mention showing casing on Power Addicts. The app is changing my organization culture.
Is it possible to have weekly/monthly reoccurrence while booking such slots?
Hello Shane - Thanks for the wonderful video. i want to add one more option for create event. while creating event i need to add 5 rows for each time slots instead of one slot. can you please help me with this ?
Hi Shane, is it possible to create date ranges for time slot? e.g. business hours
Create time slot
For 3/23/2023 - 3/30/30/2023
8:30 AM - 11:00 AM
30 min sessions time slots
Thank you
Yes, I have done that for a customer. Took this concept and just added to it. Sorry, I don't have a video but I built from here by loop through the other days. Showed each day in its own gallery to make it look nice.
Hi Shane, Do you have a video on transport booking system. I need to create an app for users to book transport for a particular day and time and also consider the seat available for each transport. Any ideas will be highly appreciated
I don't. But you could probably combine this video with another one czcams.com/video/HTY8AnMz5rw/video.html and get a lot of the mechanics/ideas.
@@ShanesCows thank you very much, Shane. Will give it shot.
Can a set an max attendees function??
You would add conditional logic that says hey if the amount is 3 then disable button assuming you wanted only 3 attendees.