web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Can't get this working...

Power Apps

Answered

Can't get this working: remove duplicate lines from text string

(0) Share

Report

Report

Posted on by gerrysr6omfg

37

I tried Monitor but it doesn't show variable values.

I have a string of lines (_emailBody) that might include duplicates (because users). So to remove the duplicates I have:

Set(_lines, Split(_emailBody, Char(10)));
Set(_distinct, Distinct(_lines, Text));
Set(_concated, Concat(_distinct, Char(10)));
Set(_emailBody, _concated);

But it doesn't work, and I have no idea why not because I can't see what any of it is actually doing because there is no debugger. Trace() doesn't help either, because these are objects and I don't know how to convert them to strings.

This would take like 30 seconds in C# but in PowerApps I'm an hour into it and completely stuck.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

AaronKnox 514 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @gerrysr6omfg ,
It seems you were close to the solution. Add this code to a button, play the app, click the button, then close the player and highlight _emailBody. This will let you know the data type and provide a mini preview:
Set(_emailBody, "User Generated Data Line1 User Generated Data Line2 User Generated Data Line3 User Generated Data Dupe User Generated Data Dupe User Generated Data Line4 User Generated Data Line5" )

Then add this code in another button, no need to play, highlight the code to see the outcome:
Distinct(Split(_emailBody, Char(10)),Result)

You might ask, what's going on here with 'Result'? Both Split() and Distinct() return a single column table with Result as the name of the column.

Keep in mind that Distinct() is GroupBy()'s sidekick. Complex distinct/grouping requires GroupBy, but from what you mentioned Distinct will probably work OK for this scenario.

The GroupBy formula, to do the exact same thing, is:
GroupBy( Split(_emailBody, Char(10)), "Result", "_myGroupTable" )
It is superior to Distinct in that it provides the distinct column as well as the rest of the columns in a table within the record:

Hope this helps.
Cheers!
Verified answer

gerrysr6omfg 37 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks, that helps a lot. But it returns a table, I got ChatGPT to show me how to convert the table to a String and got the final working code:

Set(_emailBody, Concat(GroupBy(Split(_emailBody, Char(10)), "Result", "_myGroupTable"), Result, Char(10)));

Join the conversation