Answered

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

All responses (10)

Answers (1)

Tbabe 81 on at

Like (1)

Report

Re: Avoid Duplicate values in Semi Column Delimiter

Thank you it worked
Tbabe 81 on at

Like (0)

Report

Re: Avoid Duplicate values in Semi Column Delimiter

sorry the compose3 wasn't suppose to be there
Verified answer

Expiscornovus 31,643 Most Valuable Professional on at

Like (0)

Report

Re: Avoid Duplicate values in Semi Column Delimiter

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 81 on at

Like (0)

Report

Re: Avoid Duplicate values in Semi Column Delimiter

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
Tbabe 81 on at

Like (0)

Report

Re: Avoid Duplicate values in Semi Column Delimiter

Thanks i will try it now
Expiscornovus 31,643 Most Valuable Professional on at

Like (0)

Report

Re: Avoid Duplicate values in Semi Column Delimiter

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 81 on at

Like (0)

Report

Re: Avoid Duplicate values in Semi Column Delimiter

sure... its quite lengthy,😊
Expiscornovus 31,643 Most Valuable Professional on at

Like (0)

Report

Re: Avoid Duplicate values in Semi Column Delimiter

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 81 on at

Like (0)

Report

Re: Avoid Duplicate values in Semi Column Delimiter

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 31,643 Most Valuable Professional on at

Like (0)

Report
Re: Avoid Duplicate values in Semi Column Delimiter

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