Remove Duplicates in SharePoint Lists: Power Automate Flow Tutorial

Learn how to use Power Automate, to create a flow that will iterate through all of the items in a SharePoint list, to find duplicates in a column, and remove them. This is helpful if you'd like a column to have only unique values for that column.
Fill out this form if you're joining our live discussion for the first time bit.ly/2u68Dze
Check out my free Microsoft Teams Basics course: www.iwmentor.c...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - -
Join the newsletter to vote for topics: iwmentor.ck.pa...
Free Power Hour every Wednesday at 11am CST
Laura's Blog: www.wonderlaura...
IW Mentor (Information Worker Mentor)​

[@TheScurlocker]

EXACTLY what I needed. I love how simple you make this and the beginning explanation was awesome too. This video is amazing and it allowed me to create my flow and it ran successfully first time. I watched so many other videos that made it complicated and didn’t work!Thank you!

[@WonderLaura]

Wow, thanks for letting me know it worked well for you.

[@davew1285]

Hi there. Why did you place one of the set variables before the condition and the other after?

[@jdvelasquezr]

Hey Laura - This come very timely to a flow I built involving names and unique ID values coming from an external system via API. In my case, I didn't need to use the trim function because my values are not user-generated. Thus, they always come in the same way. Thank you for sharing this knowledge with us, Power Automate enthusiasts.

[@WonderLaura]

Perfect!

[@TracyWork]

Great video as usual! Love your videos! Just wanted to mention one other scenario that creators would need to consider, if there is a space at the beginning of the word. If there is a space, the word " stapler" would be at the top of the list and "stapler" would be later in the list. Just need to keep that in mind when sorting and comparing one item to the next item in the list, these would not be in succession in the list. Hope that makes sense.

[@WonderLaura]

Thanks, good point!