Desk Booking - Main Dash Board
nstrain17 opened this issue · 1 comments
nstrain17 commented
Hello
I have downloaded the newest version of your desk booking template but I am getting an error for the formula that retrieves any bookings for the user. I can see the data being populated in the SharePoint list when a booking is made so I'm happy that the list has been set up correctly.
FirstN(
SortByColumns(
Filter(
'Desk Reservations',
ReservedBy.Email = currentUser.Email && 'Check Out From Number' >= Value(
Text(
Today(),
"yyyymmddhmm"
)
)
),
"CheckOutFromNumber",
Ascending
),
2
)
Any help would be appreciated.
Thank you
christheninjapirate commented
I think the issue is solved in this post - #100 (comment). The ReservedBy.Email syntax doesn't seem to work as provided in the app download (at least for me and others)