Share via

Can a Microsoft List reference data from an Excel sheet to identify duplicates?

Anonymous
2023-12-13T20:55:48+00:00

We use a Microsoft List for applicant tracking at my company. We currently utilize the "Enforce Unique Values" function to identify duplicate names, but that only works on names already on that current list. I would like to use a formula that can reference Excel data (applicant names) from a separate Excel sheet to identify when a duplicate name has been entered in our Applicant tracker on Microsoft Lists.

I have not been able to find an option in workflows or using the Formula input function in Lists.

Appreciate any info. Thanks.

Microsoft 365 and Office | SharePoint | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dillon Silzer 60,931 Reputation points
    2023-12-13T21:29:59+00:00

    Hi Joe,

    Have you attempted to create a custom Power Automate automation for a solution? I don't think this can be accomplished with the standard workflows provided by flows in SharePoint.

    I'd recommend posting this ask in the Power Automate forums for better help:

    https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    Was this answer helpful?

    0 comments