Hello, I've recently created a solution that comprises of: 3x MS Forms to collate responses from third-party suppliers3x MS Lists for the da

Is there a way of highlighting duplicates in MS Lists?

Hello,

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.

Categories:

Business Process Flows

Quick Links

Leaderboard > Power Automate