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

[ClintRB]

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

Thank you 

ClintRB

[GeoffRen]

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).

[ClintRB · Accepted solution]

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.

Cheers,

ClintRB