I have a flow that does the following:
- when an item is changed in a specified column (a person is added/removed in a User column) on SP List 1, get all items from list 1
- create items for all items on SP List 1 in SP List 2 this way, I have a duplicate list with the information I need when changes are made.
I want to build out the automation so the next time SP List 1 is changed, and all the records are created in SP List 2, it goes through and removes duplicates. I have tried using Selet/compose but am unable to get it to remove any duplicate rows.
In short -- is there a simple way to use PowerAutomate to remove duplicate rows in a sharepoint list?