Power Platform Community Forum Thread Details

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)