Desks booking/ desks booked for hours are not showing in the list

[RandallMoraAlfaro]

Describe the bug Desk selected for a period of time is nos available for the day for other users

To Reproduce Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior if I am booking a desk from 9-10 should appear available in the gallery when I am selecting the same day with a diferent schedule

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: windows
• Browser chrome and edge
• Version latest

Smartphone (please complete the following information):

• Device: [e.g. iPhone6]
• OS: [e.g. iOS8.1]
• Browser [e.g. stock browser, safari]
• Version [e.g. 22]

Additional context this is the filter in the gallery

Filter( Sort(col_Desks,Title), Not( Title in col_Reservations.DeskText ) && Active = 1 && Or(DeskSearchFilter.Text in Title , DeskSearchFilter.Text in Description) ) // 'Check Out From' >= startTime && 'Check Out To' <= endTime || 'Check Out From' <= endTime && 'Check Out To' >= endTime /* Filter( col_Desks, Not( Title in col_Reservations.DeskText ) && Active = 1 ) */

[mausiku]

It is the Date & Time Format setting. When in SharePoint "Desk Reservations" list, go to Settings in the top right corner and choose List settings. Under Columns, click on the "Check Out From" column. Under Date and Time Format, choose "Date and Time" instead of "Date Only". Do the same for the "Check Out To" column.

[MikeBetts44]

Depending on your company (my company is a joint ventures meaning 3 suppliers of laptops). One of the partners has sent out all their laptops with default edge browser as US. Not great in the UK. I've added a trouble shooting screen with links to the videos to change the browser. Also the default times in the template are incorrect format and I've set these to 08:00 and 17:00. Lastly make sure your screens navigate back to the date selection screen not the new booking screen. Reason for this is that this has a reset for the date. You will get 00:00 to 00:00 which can be booked over and isn't a time frame. US Browsers also default to 12:00 to 12:00 in the UK - again same issue. My advice is then test to death. I had to go back to a spreadsheet while I sorted these issues, which is not great for your credibility. Also build a PowerBi dashboard to show seats that are booked. Add this link to your app. Saves on the searching.

[RayanRe]

@mausiku Thank you it helped! But now I have another problem. In the 'Check Out From' column, my startTime variable assigns the date and time -8h from the one selected in the calendar. Although when I check the value of the startTime variable in the application it is correct. Do you have any idea what I set wrong? :-)

[MikeBetts44]

@mausiku Thank you it helped! But now I have another problem. In the 'Check Out From' column, my startTime variable assigns the date and time -8h from the one selected in the calendar. Although when I check the value of the startTime variable in the application it is correct. Do you have any idea what I set wrong? :-)

It's a great piece of work from April. However there are issues. I would forget check in and out, people forget or don't use it. Keep it simple. The date issue if not consistent with all your users is their language settings on their pcs. I created a power automate notification when that happens that has a link how to correct your pc settings. Easier to use someone's file and adapt to your needs.