Avoid Duplicate values in Semi Column Delimiter

[Tbabe]

I have this flow that is running but the issue now is how to get rid of the duplicate values in my column 3;8,3,3, . I do not want it to keep repeating the id and where do i insert the logic? Below is a Screenshot. Thanks3 appears three times, i want to be able to see just one 3my flow 1my flow 2

[Expiscornovus]

Hi @Tbabe,

It looks like you have two delimiters, is that correct? In the example are we evaluating two or four items?

If it is four items you could use some intersection, split and join functions to get the unique item values.

Below is an example with a couple of compose actions.

join(intersection(split(join(split(outputs('Compose'), ';'), ','), ','), split(join(split(outputs('Compose'), ';'), ','), ',')), ';')

[Tbabe]

Thank you for your response, so the project is to append the Id( column) from a sharepointlist (target list) to another column (destination list) . which that is working fine but just need it to be perfect by not repeating same id's when it is rerun. so i tried this and i got the following errors.

[Expiscornovus]

Hi @Tbabe,

Thanks for the clarification. My example was to clean it up afterwards.

If you want to prevent the flow appending an existing id in that string value it probably is easier to use an indexOf function in an expression to search if the id already exists in the string value.

Can you show me the configuration of how you append the id? This way I can share a specific example for your situation.

[Tbabe]

sure... its quite lengthy,😊

[Expiscornovus]

Hi @Tbabe,

Thanks for sharing the screenshots.

You can add a nested condition action in the If No section of your Condition 3 action. In this new condition action check if the appendeddataId variable contains the documentId. If not, append. If Yes, do nothing.

[Tbabe]

Thanks i will try it now

[Tbabe]

Hi, I did what you asked , but got an error, I'm new to Power Automate, is there anything i should add to the flow? please find below an attachment

[Expiscornovus · Accepted solution]

Hi @Tbabe,

I see you added the row to the existing condition with an AND operator. The evaluation of that condition will probably always be false since appendeddataId can't be empty and contain data at the same time. 

What I proposed was to add another condition action. Can you try this setup instead?

Btw, can you also share a screenshot of the config the Compose 3 action with the union function?

[Tbabe]

 sorry the compose3 wasn't suppose to be there

[Tbabe]

Thank you it worked