Hello,
I need help troubleshooting my issue here. I'm using some 'off the shelf' desk reservation app I found on the internet and modified it for our specific use case. The request now is to see who has the desk reserved before & after the specific user.
As a "database" of these reservations a List is used. This list is named 'Desk Reservations'.
This list has following columns: 'DeskText' which can be used as a idenfitifier for the specific desk; 'Reserved By' as to see who reserved the desk and 'Check Out From' a 'Check Out To' which mark the start & end of the reservation. The formate is 'DD/MM/YYYY HH:MM'
Variable is also used 'varSelectedReservation' which is defined as Set(varSelectedReservation;ThisItem);;Navigate(Reservation)
Now I want to create a formula that'd would show in a field an output ('Reserved By') of the closest person that has the reservation of the same spot before the ThisItem reservation.
Problems:
1. If I use varSelectedReservation.'Reserved By' it says that there's an error in this formula and outputs nothing - in the source, this column is Office365 user; If I input varSelectedReservation.'Check Out To' it works as intended
2. Now the main issue, I've tried creating a formula that makes sense in Excel but doesn't work in Power Apps and I can't tell why.
FirstN(
SortByColumns(
Filter(
'Desk Reservations';
DeskText = varSelectedReservation.DeskText &&
'Check Out From' >= varSelectedReservation.'Check Out From'
);
'Check Out From';
SortOrder.Ascending
);
1
).'Reserved By'
Note: Local PowerApps use ";" in arguments instead of international ",".
I'm thinking there's only something wrong with the syntax or logic I use.
I'd really appreciate if anyone could help.
