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.
