cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ClintRB
Helper I
Helper I

Get Items - Combine (Union) multiple names (same field) and add to Excel Table

Hi,

 

I have flows that work for when an item is created or modified that combines (union) multiple names in the same row/field.  I guess because this is always just one instance. 

 

Applying the same logic to an existing list and filtering by date and then trying to combine (union) the names which are applicable under one field for each row is not.  I have tried multiple scenarios none with the desired outcome.

 

I end up with either an individual row with only one name, the last name of the combined or the names keep adding for each new row.

 

Clearly this is not the way to do it so if anyone could shed some light onto which way I should be doing this I would appreciate it.

 

I have looked at this link however I cannot get it to work this way either. 

https://powerusers.microsoft.com/t5/General-Power-Automate/Microsoft-Flow-combining-Multiple-Values-...

 

One example below

Flow 1.jpg

 

Thank you 

ClintRB

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @GeoffRen ,

 

Thank you for your reply, I had tried more than 10 different combinations and finally worked it out.  One of the keys was using a skip step.  Originally I had skip set to one but tried increasing it with the right combination and managed to get it to work.

 

 

Flow Example Page 001.jpgFlow Example Page 002.jpg

 

Cheers,

 

ClintRB

View solution in original post

2 REPLIES 2
GeoffRen
Microsoft
Microsoft

If you want all the unioned names in just one row, move the Add a row operation out of the apply to each loops. What you're doing is adding a new row to the table for every individual assignee (possibly multiple times per assignee, hard to tell with only a picture of the Flow and without knowing what your structures look like).

Hi @GeoffRen ,

 

Thank you for your reply, I had tried more than 10 different combinations and finally worked it out.  One of the keys was using a skip step.  Originally I had skip set to one but tried increasing it with the right combination and managed to get it to work.

 

 

Flow Example Page 001.jpgFlow Example Page 002.jpg

 

Cheers,

 

ClintRB

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,652)