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 / Power Automate to buil...
Power Automate
Unanswered

Power Automate to build unique records of different variations of a single record?

(0) ShareShare
ReportReport
Posted on by 20

Hello and Thank you

 

I would like to take the information in Column 1 (Name) and create multiple new unique records concatenated with the info within column 2 (A, B, C)

 

To visualize:

Column 1 - "Name"

Column 2 - "A, B, C"

 

Result"

Record 1 - "Name_A"

Record 2 - "Name_B"

Record 3 - "Name_C"

 

 

Categories:
  • Rhiassuring Profile Picture
    8,692 Moderator on at

    Hi there, 

     

    You can use a Compose and split() for Column 2, splitting on ",". That will turn it into an array, with A, B, and C, as separate records. 

     

    Then all you'll need to do is create another Compose (or a Create Item - or whatever you need) and, in the title (or wherever you'd want Name_"A" to appear), just say concat(Column1,'_',Compose)

     

    Where Column 1 is the Dynamic Content for it, and the Compose points at the Compose where you used "split()". It will turn into a "For Each", and do it for each A, B, and C.

  • takolota1 Profile Picture
    4,980 Moderator on at
    If you have a lit of rows, there is a way to split a column on delimiters to multiple records using only 6 actions & it will work for any number of records.
    https://community.powerplatform.com/galleries/gallery-posts/?postid=b4b53bc0-0e9a-ef11-8a69-6045bdee0f9b

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 426

#2
11manish Profile Picture

11manish 308 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 159

Last 30 days Overall leaderboard