Unanswered

Avoid Duplicate values in Semi Column Delimiter

(0) Share

Report

Posted on by 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

Categories:

Using flows

I have the same question (0)

All responses (10)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
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'), ';'), ','), ',')), ';')

Was this reply helpful? Yes No
Tbabe 81 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Tbabe 81 on at

Like (0)

Report

sure... its quite lengthy,😊

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Tbabe 81 on at

Like (0)

Report

Thanks i will try it now

Was this reply helpful? Yes No
Tbabe 81 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Tbabe 81 on at

Like (0)

Report

sorry the compose3 wasn't suppose to be there

Was this reply helpful? Yes No
Tbabe 81 on at

Like (1)

Report

Thank you it worked

Was this reply helpful? Yes No