Unanswered

Remove duplicates from string

(0) Share

Report

Posted on by Scott_UK

Hi,

I hope someone may be able to help me. I get the feeling this one is quite simple for some reason I just cannot get my head around the logic and formulas. Maybe I am still mentally stuck in Excel mode.

Anyway, I have a long string which is delimited by commas. I need to split it out, remove duplicates and put it back as a string again.

Any ideas? It is case-sensitive, if that matters?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

BhargavPatel 660 Moderator on at

Like (3)

Report
@Scott_UK Try this:

Concat(Distinct(Trim(Split(TextInputCanvas1.Value,",")),Value),Value,",")

In my case, the input for TextInuptCanvas1.Value is:
1,1,1,2,2,2,3,4,5,6,7,8,9,9,9,0,0,0,1,1,3,3,4,5,6,7,8,9,10,11,12,13,14,11,11,12,and,AND,aND,And, And,And

And my output using the code I posted is:
1,2,3,4,5,6,7,8,9,0,10,11,12,13,14,and,AND,aND,And

Was this reply helpful? Yes No
Scott_UK 28 on at

Like (0)

Report

Hi,

Thanks for the steer 🙂

However, I get an error 'there is an error in this forumula' but oddly it doesnt highlight in red or say what part is wrong. Any ideas?

Was this reply helpful? Yes No
Scott_UK 28 on at

Like (0)

Report

No matter, was operator error lol.

Thank you for the formula, that works perfect 🙂

Was this reply helpful? Yes No
Gochix 1,935 Moderator on at

Like (1)

Report
@Scott_UK ,
You might have an error because the code that @BhargavPatel provided is for textInput field, but you require the solution for the Text field?
Then the code would be
Concat(Distinct(Trim(Split(Text.Text,",")),Value),Value,",")

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

Was this reply helpful? Yes No
Scott_UK 28 on at

Like (0)

Report

Yes it was that lol.. must have needed my morning coffee. Thanks both.

Was this reply helpful? Yes No