Power Platform Community Forum Thread Details

Hey everybody
Me and a collegue are just starting up trying to make an app that people can book the training room. (The training room is a fitness room so more then one person can train at the same time.

I have set up the page like this (Photo). So when you push a date for the time you should train you should then choose the time in and the time out and then it should be a button under it that you have to klick to book the room. But- I dont know how to connect the date and the time together. Can somebody push me in the right direction?

Thank you so much!

Categories:

Building Power Apps

When using anything that needs a date/time picker in conjunction with SharePoint I like to use a form to get the Date pickers that I need. This makes it much more easy in the long run as it gives you dropdowns for date, hour, and min. To do that:

Insert an edit form into the app.
On the right hand side set the data source to your SharePoint List. This will import the fields of the list into the form for you.
Remove all the fields you dont want and just keep the 2 date pickers for start and end time.
Now you have to decide if you want to deal with 12 hour time or 24 hour time. By default you will have 24 hour time so if you are ok with that then you are able to skip the next few steps. If you want 12 hour time then:
- Set the item property for both Hour pickers to the following:
  - ["12","01","02","03","04","05","06","07","08","09","10","11"]
- Insert a new drop down in both data cards and set the items property to the following:
  - ["AM","PM"]
- Now for the hard(er) part. The update property of the data card itself needs to be set to the following (both):
  - DateValue1.SelectedDate+Time(If(Dropdown1.Selected.Value="PM",12,0)+Mod(Value(HourValue1.Selected.Value),12),Value(MinuteValue1.Selected.Value),0)
- You will have to change the names to the names that are in your app. This will do the math and calculated what the 12 hour time is that corresponts to the 24 hour time. The SP list is expecting 24 hour time so this update value will be what is pushed to your SP List when you submit the form.
- Add an Icon/Button and set its OnSelect property to:
  - SubmitForm(YourFormName);
- Test and update with what you get and I will try to help you get to where you want to be 🙂