Notifications
Announcements
Hello
Is it possible to remove duplicate lines in a string variable? The content of the variable is a csv file.
I would prefer not to convert it to an array.
Thanks!
Converting it to an array is the easiest way to do it. You can convert it back after the duplicates are removed fairly easily too probably.
Pat
@mahoneypat thanks what would be the most efficient way to convert a string or csv into array? I have seen online some processes like getting the headers, then separating the lines, then separating each comma separated value etc but it seems quite inefficient and I need this to run fast. Btw, I cannot use premium flows!
I use the approach shown in this video. Works well.
How to Parse a CSV in Microsoft Power Automate Super Fast, Free and Easy. - YouTube
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 522 Super User 2025 Season 2
Tomac 364 Moderator
abm abm 243 Most Valuable Professional
