Joining two columns in a single column

(0) Share

Report

Posted on by kgiles123

224

I have two columns in my SharePoint List 'State_Mandates':
Role1 Role2 ID

Apples Grapefruit 1

Bananas Oranges 2

Pears Grapes 3

I would like to create a collection that will stack all of these items into a single Column and return their corresponding ID number as well. Here's an example:
Role ID
Apples 1

Bananas 2

Pears 3

Grapefruit 1

Oranges 2

Grapes 3

Please help and thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @kgiles123,

You could use the following code to achieve this:

ClearCollect( colMerged, Ungroup( ForAll( 'State_Mandates', [ { Role: Role1, ID: ID }, { Role: Role2, ID: ID } ] ), "Value" ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
kgiles123 224 on at

Like (0)

Report
Copy link

Link copied!

Thank you!!!

Was this reply helpful? Yes No