web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Joining two columns in...

Power Apps

Answered

Joining two columns in a single column

(0) Share

Report

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 Img

All responses (2)

Answers Img

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

Join the conversation