Open nstrain17 opened 1 year ago
I think the issue is solved in this post - https://github.com/aprildunnam/PowerApps/issues/100#issuecomment-1471463426. The ReservedBy.Email syntax doesn't seem to work as provided in the app download (at least for me and others)
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