Hi, thank you for sharing this video I have followed along but seem to have got lost at 10:41 is there another video I should be watching to link the work carried out when creating booking screen demo to the booking screen?
Hi and thank you for this. I am new to power apps and when I am trying to add the formula ThisItem X and Y to the waypoint in the gallery I have to select either street, name, zip code etc and not able to use just XCoor. Can you help please? I assume the app has been updated and wonder where there is an alternative? Thanks for any support
Collecting the latest information to the Collection like ClearCollect( colOfficeBookingForThisDate, Filter( OfficeBooking, BookDate = BookingDate.SelectedDate ) ); Refresh(OfficeBooking);
Thank you for this very helpful video and for being so kind to share the codes in github. I would just like to ask, how can I add an option of work shifts. Lets say in the workplace there are 3 shifts, morning, mid afternoon, and night shift, can I add a column in the booking information and also add another line in the code to check if its available based on the work shift selected together with the date and seat number?
Yes, please add a new column titled "Shift" with three options. Validate that the shift is already booked when the user selects the date. Display an error message if the shift is already booked. For example, allow the reservation if the shift is not booked for the same date and desk/position. Let me know if you need any help, and I can set up a time to discuss further.
Hello, thank you for your time to create this video it´s what i was looking for. I am just starting on this new world to create apps, on this momment I got stuck on to connect the data source 5:46. After create all sharepoint data I am not able to find the officeinfo inside the field search. Could you please give me a hint to to do that. Thanks!
Hi @Ma Inacio You need to add your SharePoint as Data Source to the PowerApps. 1. Open the PowerApps 2. On the Left Navigation, Click "Data" or Click "View" on the menu bar and click "Data Sources" 3. Click "Add data" 4. Connect your Sharepoint (Both Sp List)
The reason is screen size is different when we measure and run the app. So adjust the X or Y coordination by using a small formula to align it properly. like X --> ThisItem.XCoor - 5 (In my layout, I used 5 to adjust the x coordination) You may need to adjust either Plus or minus.
thanks for the helpful video. I have similar kind of things to do. Instead of Reservation I have to find out the desk. but the desks are in in aligned they are scattered throughout the office. Any help ? I have Visio file too.
We can do this with some boolean field with x and Y coordination. Can you reach me @stalinponnusamy@gmail.com. I will set up some time to discuss this.
Hello, Thank you so much for the video! it is really helpful! But I am having an issue with the "Change" Button, even in your attached code, it doesn't switch from Book to change! do you only have a code for it into the Icon or somewhere else as well! if we can have a very quick chat anytime I would highly appreciate it! Huge Thanks!
Should have zip files and other supporting files. Import the zip files for the app reference. The code is in Git Repo. github.com/AntonyStalin/DeskReservation
Hello, thank you for your video, it's a very clever way. Implementing it for my project so far. However I've encountered an issue with the cancel button. It on grey(disabled) all the time, even if no reservation is done or once reservation is done. I won't delete the booking created. Any ideas? Thank you!
@@learntoilluminate This is a nice project i hav tried to do it step by step but seems like there are syntax errors, do you a step by step function commands for first time learners for such project
@@MrPherez Did you download the copy of the PowerApps for reference? Please refer to the description for the git repo URL. If you still have questions then reach me I will set up a meeting with you to go through it.
@@learntoilluminate Managed to get everything up and running quite some good work you have done here, im learning power apps and been lookin at adding the function of time since not every one work the whole day so would be nice to get the time function not necessarily the whole day reservatoin
Hi Vijay, I have uploaded the complete PowerApps and Sharepoint list to the Repo. Refer to the description for the URL. Please reach me if you still have any questions.
@@learntoilluminate can i set a meeting date so that you can see my codes and assist, i like to get the details by doing codes by myself not getting from repos though its a short cut, a full video is much better.
Hi @tonhomza I've included the information below for your request. This application is added to repositories. Ref the video description. 1. Collect existing reservations of the selected date in a collection 2. Change the Lable Name based on whether the current user has already booked for the selected date 3. Display the Icon color (Purple, Green, and Red) based on whether this selected desk is booked by a current user or a different user. (Purple - Booked by the current user, Green - Available, Red - Booked by someone) 4. Booking - If the current user is not booked for the selected date, then book it; otherwise update it (It means the user is changing the desk) 5. Cancel the booking
@@learntoilluminate Thanks, Regards to SP list OfficeBooking, column name "Office" what is the "Select a list as a source" and "Select a column from the list above"?
Hi, That you for this video..... I'm facing one error when I try to build exact app and need your assistance please. For the WaypointIcon.Color, when I try to add the formula, I'm getting error in the below section "Office.ID = ThisItem.ID && Employee.Email = UserInfo.Email" Error : "Name isn't valid. 'Employee' isn't Recognized" Can you please assist me fix this error. I'm trying and unable to fix this issue.
Hello!
Thank you for sharing this template and all the work and help you have done.
This is exactly what i have been looking for.
I'm glad it helped you
Hi, thank you for sharing this video I have followed along but seem to have got lost at 10:41 is there another video I should be watching to link the work carried out when creating booking screen demo to the booking screen?
Hi Lauren,
Could you let me know if you downloaded the copy from the repo for reference? The link is described in the description.
Love your content, Can you specify which collumn type is use in OfficeBooking?
Thanks @AMindGame. Please refer to the description for the copy and related reference materials. Let me know if you still any questions.
Hi and thank you for this. I am new to power apps and when I am trying to add the formula ThisItem X and Y to the waypoint in the gallery I have to select either street, name, zip code etc and not able to use just XCoor. Can you help please? I assume the app has been updated and wonder where there is an alternative? Thanks for any support
Brilliant tutorial! I have one question regarding the book button, what was the remaining part of the formula under ClearCollect? At 13:53
Collecting the latest information to the Collection like
ClearCollect(
colOfficeBookingForThisDate,
Filter(
OfficeBooking,
BookDate = BookingDate.SelectedDate
)
);
Refresh(OfficeBooking);
Thank you for this very helpful video and for being so kind to share the codes in github. I would just like to ask, how can I add an option of work shifts. Lets say in the workplace there are 3 shifts, morning, mid afternoon, and night shift, can I add a column in the booking information and also add another line in the code to check if its available based on the work shift selected together with the date and seat number?
Yes, please add a new column titled "Shift" with three options. Validate that the shift is already booked when the user selects the date. Display an error message if the shift is already booked. For example, allow the reservation if the shift is not booked for the same date and desk/position. Let me know if you need any help, and I can set up a time to discuss further.
@@learntoilluminate Thank you so much. I will give it a try and will let you know if I will need more help. Thanks.
Hello, thank you for your time to create this video it´s what i was looking for. I am just starting on this new world to create apps, on this momment I got stuck on to connect the data source 5:46. After create all sharepoint data I am not able to find the officeinfo inside the field search.
Could you please give me a hint to to do that.
Thanks!
Hi @Ma Inacio
You need to add your SharePoint as Data Source to the PowerApps.
1. Open the PowerApps
2. On the Left Navigation, Click "Data" or Click "View" on the menu bar and click "Data Sources"
3. Click "Add data"
4. Connect your Sharepoint (Both Sp List)
This is good! Cant wait to see more!
Thank you
4:12 when I try this trick on a mobile view, the X Coordinate and Y Coordinate are way off from the layout. Any advice?
The reason is screen size is different when we measure and run the app. So adjust the X or Y coordination by using a small formula to align it properly.
like X --> ThisItem.XCoor - 5 (In my layout, I used 5 to adjust the x coordination)
You may need to adjust either Plus or minus.
@@learntoilluminate Thanks, I'll try it
thanks for the helpful video. I have similar kind of things to do. Instead of Reservation I have to find out the desk. but the desks are in in aligned they are scattered throughout the office. Any help ? I have Visio file too.
We can do this with some boolean field with x and Y coordination. Can you reach me @stalinponnusamy@gmail.com. I will set up some time to discuss this.
Its a nice thought but it wouldn't fix the indention issues on X coordinates per row.
Let me know if there are any issues.
Hello, Thank you so much for the video! it is really helpful!
But I am having an issue with the "Change" Button, even in your attached code, it doesn't switch from Book to change!
do you only have a code for it into the Icon or somewhere else as well!
if we can have a very quick chat anytime I would highly appreciate it!
Huge Thanks!
Sure, I will set up a call with you. Send an email to me @ stalinponnusamy@gmail.com and time zone.
Hello, thank you for sharing ❤. I have an error on Patch function with ur code 😢.
PLS help
Is there any way I get the code? I downloaded the files but not having anything than just 2 list settings file. Thank you
Should have zip files and other supporting files. Import the zip files for the app reference. The code is in Git Repo. github.com/AntonyStalin/DeskReservation
Hello, I wonder if there a way to see all the code in this app. Thanks
I have added the code to the repo and shared it.
github.com/AntonyStalin/DeskReservation
Hello, thank you for your video, it's a very clever way. Implementing it for my project so far. However I've encountered an issue with the cancel button. It on grey(disabled) all the time, even if no reservation is done or once reservation is done. I won't delete the booking created. Any ideas? Thank you!
Please verify the DisplayMode property for the cancel button. This button should enable if the current user has booked on that selected date.
@@learntoilluminate This is a nice project i hav tried to do it step by step but seems like there are syntax errors, do you a step by step function commands for first time learners for such project
@@MrPherez Did you download the copy of the PowerApps for reference? Please refer to the description for the git repo URL. If you still have questions then reach me I will set up a meeting with you to go through it.
@@learntoilluminate Managed to get everything up and running quite some good work you have done here, im learning power apps and been lookin at adding the function of time since not every one work the whole day so would be nice to get the time function not necessarily the whole day reservatoin
@@MrPherez Currently working with the time. It will be added this week.
Hi Sir, is it possible to mentor me personally to create this app on my enviroment ?
Hi Vijay, I have uploaded the complete PowerApps and Sharepoint list to the Repo. Refer to the description for the URL. Please reach me if you still have any questions.
@@learntoilluminate can i set a meeting date so that you can see my codes and assist, i like to get the details by doing codes by myself not getting from repos though its a short cut, a full video is much better.
Can you please go through step by step instructions from min. 10:40 .... ?
Hi @tonhomza
I've included the information below for your request. This application is added to repositories. Ref the video description.
1. Collect existing reservations of the selected date in a collection
2. Change the Lable Name based on whether the current user has already booked for the selected date
3. Display the Icon color (Purple, Green, and Red) based on whether this selected desk is booked by a current user or a different user. (Purple - Booked by the current user, Green - Available, Red - Booked by someone)
4. Booking - If the current user is not booked for the selected date, then book it; otherwise update it (It means the user is changing the desk)
5. Cancel the booking
@@learntoilluminate Thanks,
Regards to SP list OfficeBooking, column name "Office" what is the "Select a list as a source" and "Select a column from the list above"?
hey could u help me ?
Let me know what help you are looking for. Reach me at stalinponnusamy@gmail.com
Hi, That you for this video.....
I'm facing one error when I try to build exact app and need your assistance please.
For the WaypointIcon.Color, when I try to add the formula, I'm getting error in the below section
"Office.ID = ThisItem.ID && Employee.Email = UserInfo.Email"
Error : "Name isn't valid. 'Employee' isn't Recognized"
Can you please assist me fix this error. I'm trying and unable to fix this issue.