Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Is there a way of highlighting duplicates in MS Lists?



I've recently created a solution that comprises of:


  • 3x MS Forms to collate responses from third-party suppliers
  • 3x MS Lists for the data to be stored
  • 3x automated approvals, using PowerAutomate, for the responses from the suppliers to be reviewed and either approved, which then creates the entry in MS Lists, or rejected.


One of the questions I've had for the team that the solution is for is whether or not there's a function, like in Excel, where you can easily highlight duplicates in the MS List. The chain of thought is that once the solution is up and running and it contains lots of entries, they might miss entries that have already been submitted. They want an easy and quick way of finding apparent duplicates. Some examples I thought of asking if it's possible to do:


  • email notification to the approvers to say there's a duplicate entry in the MS List
  • similar to Excel where it highlights the cells to indicate duplicates
  • a filter
  • automation to remove the duplicates


Any advice or pointers you could provide would be much appreciated.


Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,192)