Hi,
Could you please help me combine multiple rows in Gallery list into a row with the same item name and date.
Two rows:
NOV 30 | D 002 | 12:00 PM to 1:15 PM
and
NOV 30 | D 002 | 1:15 PM to 1:45 PM
should be
NOV 30 | D 002 | 12:00 PM to 1:45 PM
Below is my code.
SortByColumns(
Filter(
'Desk Reservations',
'Reserved By'.Email = currentUser.Email && 'Check Out From Number' >= Value(
Text(
Now(),
"yyyymmddhhmm"
)
)
),
"CheckOutFromNumber",
Ascending
)
Upper(Text(DateTimeValue(ThisItem.'Check Out From Text'),"[$-en-US]mmm"))
Upper(Text(DateTimeValue(ThisItem.'Check Out To Text'),"[$-en-US]mmm"))
Upper(Text(DateTimeValue(ThisItem.'Check Out From Text'),"[$-en-US]dd"))
Upper(Text(DateTimeValue(ThisItem.'Check Out To Text'),"[$-en-US]dd"))
Text(DateTimeValue(ThisItem.'Check Out From Text'), DateTimeFormat.ShortTime) & " to " & Text(DateTimeValue(ThisItem.'Check Out To Text'), DateTimeFormat.ShortTime)
ThisItem.'Desk Text'

Report
All responses (
Answers (