How do I get rid of Lookup Column Duplicates

MindfulMike 1 Reputation point
2022-03-03T20:35:18.547+00:00

Say I created a list with two columns, "Clients" and "Agency" as a choice column for the two different Agencies we have "X" and "Y"

I then created two extra list for each Agency. These two Lists have lookup columns to look up "Clients".

Client "ABC" has items in both X and Y Agencies so their names is coming up twice when I look it up on both Agency Lists.

My two questions are:

  1. How can I get rid of duplicates in my look up columns?
  2. Or if there a way for each Agency List to only lookup Clients that have items in that Agency?

Thanks in advanced!

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,868 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,715 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 42,596 Reputation points Microsoft Vendor
    2022-03-04T09:15:56.783+00:00

    @MindfulMike

    As a workaround, in the first list, you should create two records about agencies X and agencies Y for client ABC. For example:

    In the first list:

    180010-1.png

    Choose one ABC in the lookup column:

    180083-2.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.