Unanswered

Combine multiple rows in SharePoint list into a row

(0) Share

Report

Posted on by kinghnvn

Hi,

I am wondering if anyone has a solution for this issue that I am facing.

I have a SharePoint list with multi rows with the same value in A, B, C column and different time value in a time range.

I want to combine multiple rows into a row, looks like below:

Does anyone here know if there is a way to do this?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (0)

WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report
HI @kinghnvn ,

You need to use GroupBy

GroupBy( YourListName, "Name", "StartDate", "EndDate", "StartTime", "EndTime", "Data" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report

@WarrenBelz

I'm sorry, sir. I still don't quite understand. Could you please explain detail steps?
Thanks.

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report

Hi @kinghnvn ,

The code I posted would be the Items of a Gallery to produce what you have at the right. You do not need to display the last column, but is it needed for the syntax to work.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report

thank you @WarrenBelz
It's still not working.

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report

@kinghnvn ,

That is the correct syntax (there are no others) - can you please post the Items of the gallery in your example as it is should not be possible to produce that result with the code.

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report

@WarrenBelz
Please find my code in the Items of the gallery below. Thanks.

SortByColumns(
Filter(
'Desk Reservations',
'Reserved By'.Email = currentUser.Email && 'Check Out From Number' >= Value(
Text(
Now(),
"yyyymmddhhmm"
)
)
),
"CheckOutFromNumber",
Ascending
)

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report

@kinghnvn ,

That does not resemble what I posted - where did you put that code?

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report

@WarrenBelz
I put the code in the Items of the gallery

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report
@kinghnvn ,

I meant the code I posted as the Items of the gallery

GroupBy( YourListName, "Name", "StartDate", "EndDate", "StartTime", "EndTime", "Data" )

you probably need something like this

SortByColumns( AddColumns( GroupBy( Filter( 'Desk Reservations', 'Reserved By'.Email = currentUser.Email && 'Check Out From Number' >= Value(Text(Now(),"yyyymmddhhmm")) ), "Name", "StartDate", "EndDate", "StartTime", "EndTime", "Data" ), "SortNo", First(Data).'Check Out From Number' ), "SortNo", Ascending )

but again I must ask (as per your previous post) why are you converting dates to numbers (this was necessary some time ago before dates were Delegable, so maybe you have an old template)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
kinghnvn on at

Like (0)

Report

Noted with thanks. I tried your group by code in gallery but it's still not working. I guess because I have many titles in gallery. Should I set a flow to edit value in SharePoint list? Please advise.

Was this reply helpful? Yes No