Text field to see who reserved before & after my reservation

[Drastaa]

Hello,

I would like to request a little help with my request here. I would like to add two text fields to the Reservation screen that would show who has the same desk reserved BEFORE you and AFTER you.

I tried the following syntax:
FirstN(
SortByColumns(
Filter(
'Desk Reservations';
DeskText = varSelectedReservation.DeskText &&
'Check Out From' >= varSelectedReservation.'Check Out From'
);
"Check Out From";
SortOrder.Ascending
);
1
).'Reserved By'

But it doesn't work; I can't get the filter function to work, nor the SortByColumns. In my local version of PowerApps "," are replaced by ";" for some reason.

Can anyone help, please?

Thank you!

[christheninjapirate]

I wonder if it would work using the Check Out From Number-type syntax shown in this post?

#100 (comment)