Combine rows from column "B" based on value of row in column "A"

[SonnyBlack]

Hi Guys,

The purpose of the flow is to get data from excel table, convert it to html table, send it via email to people mentioned in the table and then remove data from the table. Email will be sent on daily basis, data to table are update via different flows.

I am struggling recently with a final touch of the flow that will combine rows from one column based on value of rows in another column. Let me share some screenshots.

So basically I want that content of this table in Excel:

in the final version look like this, but in html table which I will be able to paste into email and send it on daily basis.

So basically I would like to check the flow if values in "Person" column are the same and if so then check value in "Incident" column. Then if values in rows are in the same in both columns, then it should remove duplicates and keep only one "ABC" and "INC0123" row, however if values in "Incident" column are different then it should merge these values like:

Before:

Person   Incident

ABC       INC0123

ABC       INC0123

ABC       INC4578

After:

Person   Incident

ABC       INC0123, INC4578

So far I managed to get to this stage in HTML Table (on screenshot below example of table that is in email) and theoretically flow works more or less as expected and send data correctly.

However it looks more tidy when specific person is listed only once as below:

The whole flow looks like this:

Can someone please advise how to sort this out?

[Matthy79 · Accepted solution]

Hello @SonnyBlack,

I would do it like this:

1.) Select only Incident, Person, Mail

Here is the rest:

[SonnyBlack]

Hi @Matthy79 !

Thank you very much for your reply and help!

I have two questions:

1. Could you maybe share expression that you used in "Select Incidents" action in "From" field? I used "sort part" of expression from "Compose Incidents xml" and it worked, but not sure if it is correct one.

2. I managed to get html table with merged incidents, but right now I am getting unwanted characters like [, ], ". So data in Incident column look as below:

[“INC0123”]

[“INC0123”, “INC45678”]

Is there any way to remove unwanted characters?

[SonnyBlack]

Ignore post above, managed to get rid of them 🙂

Thank you once again @Matthy79 !

[Matthy79]

Perfect. Glad everything is working fine now.

[EBelmonte]

Can someone please explain the solution for this? I tried it but I think I'm missing some steps