Unanswered

List column manipulation (columns to rows) into collection

(0) Share

Report

Posted on by Community Power Pla...

Good morning, all.

I'm looking to create a collection from a SharePoint list, where the list columns equate to rows in the collection. Here is a simple example:

I can easily create a collection that mirrors the SharePoint list (single row with multiple columns), but I haven't been able to figure out how to flip the data around so to speak to get the desired result show above.

As always, thanks in advance for ideas and assistance!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

eka24 20,923 on at

Like (0)

Report

Do you expect the column names to be part of the output or converted to record as well?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Yes, that is the goal.

I've been playing around with that piece a bit and am getting close with something like this:
Collect(colUserTrainingTEST,AddColumns('DU Module List'.TrackingName,"TrackingName2",TrackingName))

Was this reply helpful? Yes No
rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report
hey hey @Anonymous , this is one of those where you want to say "fix it at the data source" :).

You could do the following (not the cleanest tho but to give an idea).

Collect Bim and SharePoint in two collections and then add these two for e.g.

ClearCollect(colBim,ForAll(yourDatasource,{tracking:"BIM", value:BIM})); ClearCollect(colSharePoint,ForAll(yourDatasource,{tracking:"SharePoint", value:SharePoint})); ClearCollect(colTransposed,colBim,colSharePoint)

What you will get are these things

Bim collection

SharePoint collection

Combined

Hope this gives some direction.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@rubin_boer , thanks. Yeah I know changing the source is probably the best option, but this is an existing list with about 65-70 columns tracking attendance/completion of training classes for all employees, so it's what I have to work with atm.

That said, your solution appears to work but may not scale well (or easily at least) given the number of columns mentioned above but the end result is definitely what I need.

Was this reply helpful? Yes No