Reservations are not showing up

[grb33]

Hello,

This app looks very good. But I have a problem with showing my reservation. I created list looks like that in the FAQ. Reservations work very well. I can make a reservation and I see it in my list (but status column is empty). But the booking is not showing up for me in the main dashboard and booking tabs.

Can You hel me?

[MrTij]

I have same issue too

[kraemjo]

And me too ☹️
No solution in sight

[MrTij]

I'm by no means an expert but with a little trial and error was able to get it populating. Hopefully this might work for you.

From your SharePoint list, copy the internal name of the "Check Out From Number" Column, from after the "=" sign. Something similar to this, Check_x0020_Out_x0020_From_x00200

On the items property of the "gallery gallMyReservationsPreview_1", in the formula below, Replace the line CheckOutFromNumber, Ascending, with your list column internal name.

Repeat the same process on items property of the "gallUpcoming" gallery under the "MyAppts" Screen and replace with the internal name of the column.

FirstN(
SortByColumns(
Filter(
'Desk Reservations',
ReservedBy.Email = currentUser.Email && 'Check Out From Number' >= Value(
Text(
Today(),
"yyyymmddhmm"
)
)
),
"CheckOutFromNumber",
Ascending
),
2
)

[kraemjo]

Thank you very much for your feedback. Unfortunately, this did not fix the problem. could it be the format of the numbers in the SharePoint list? These are displayed with thousands separator in the SharePoint list.
A problem with the German layout?

[MrTij]

Sorry it did not work. Re number format, I'm not sure. The Checked Out From Number column type in your SP list is "Number" and not "Single or Multiple Line Text" correct? Run your "App Checker" again and hover over the underlined red formula error and see what the error is saying, Maybe delete the formula and copy and paste back in. Can't think of anything else

[kraemjo]

I have now found the following solution that works for me the Dashboard Screen

FirstN(
SortByColumns (
Filter
'Desk Reservations;
ReservedBy. Email = Office365Users.MyProfile() .Mail && 'Check Out From' >= Today ()
);
"Check_×0020_Out_×0020 _From";
Ascending
);
2
)

[kraemjo]

But now I have another problem with the reservation of the desks. When I make a second reservation, it automatically suggests the date of the previous reservation. If I do not change this, it suggests desks that are not available at all and I can even complete the reservation. However, no Share Point entry is made. So the reservation does not exist. If I change the date or confirm the same day again, then the registration is successfully.

[MikeBetts44]

Having been playing around with this for about a month, I have a solid zipfile that I know works. The issues are many I'm afraid but this is how you learn for sure. You may also want to check out my replies to other queries.

[ChrisRRadford]

I found a fix (for me at least) to get the appointments to show up in the correct location (Upcoming, previous).

I noticed that the date format is being converted at yyyymmddhmm and I think it should be yyyymmddhhmm (notice the second "h"). Changing this across the board has both cleared up my 'Check out To/From Number' to be stored as intended as well as made the Filters work.

FirstN( SortByColumns( Filter( 'Desk Reservations', ReservedBy.Email = currentUser.Email && 'Check Out From Number' >= Value( Text( Today(), "yyyymmddhhmm" ) ) ), "CheckOutFromNumber", Ascending ), 2 )

I also noticed that the Today() function is not grabbing the time as well. I changed it to the Now() function to ensure that it was capturing the exact "current" time

FirstN( SortByColumns( Filter( 'Desk Reservations', ReservedBy.Email = currentUser.Email && 'Check Out From Number' >= Value( Text( Now(), "yyyymmddhhmm" ) ) ), "CheckOutFromNumber", Ascending ), 2 )

[halilgithub]

@ChrisRRadford In how many and which places should we do that change ?
(Today() -> Now() && "yyyymmddhmm" -> "yyyymmddhhmm")

[HEXAKILLZTX]

also have same problem