web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Combining Multiple Row...
Power Automate
Unanswered

Combining Multiple Rows with one idential Column (Hard to explain) - Driving me crazy

(0) ShareShare
ReportReport
Posted on by 2

Hi Everyone, 

 

I have spent the day on this and should have come here much sooner. I am trying to do what seems like a simple task and I can't work it out. 

 

I have a very simple list, it has Project Managers and their associated Project Numbers. There are other elements but I have filtered these. 

I have created an array and have removed duplicates.

 

What I am trying to do now, is simply take where I have one Project Manager who appears against multiple projects, transpose this so the resulting table will show their name and all the corresponding projects alongside. Thus reducing total rows in my table and looking smarter.

 

My Data comes from a sharepoint list. I then use a filter and then select to create the array with only the relevant items.

I considered using union on each to remove duplicates but then you lose the link between the two items and have to create further code to look back and match up to the original. Surely there's a better way I am missing?

 

Example - Original

PM       PN

David 12345

David 67890

Mike 1113

Stacey 1092

Stacey 8775

Zach 18228

 

Desired Result

PM          PN(s)

David 12345, 67890

Mike 1113

Stacey 1092, 8775

Zach 18228

 

I've tried a lot of things and cant' see an easy way of taking the data and transposing it in this way with Power Automate

Any help is welcome. Happy to post code!

Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,598 Super User 2026 Season 1 on at

    Please post the code for the original array (the output of the sharepoint list step)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard