Skip to main content
Dynamics 365 general forum
Answered

Add unique field?

editSubscribe (0) ShareShare
ReportReport
Posted on by 477

Greetings,

Is there a way to add a unique (text) field on an existing talbe/entity in dynamics 365? In my case, the contact entity.

Regards,

HD

Attachments
  • Suggested answer
    Hedi Daneels Profile Picture
    Hedi Daneels 477 on at
    RE: Add unique field?

    Thank you very much for the detailed and precise answer.

  • Verified answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,317 on at
    RE: Add unique field?

    Hi,

    Thank you for your query.

    You can add an alternate key, which adds an index and acts as a unique key

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/define-alternate-keys-entity#:~:text=All%20Dynamics%20365%20Customer%20Engagement,unique%20identifiers%20defined%20as%20GUIDs.&text=This%20alternate%20key%20can%20be,unique%20identity%20for%20your%20records.

    Here are steps:

    • Go to Advanced Settings -> Customization -> Customize this System.
    • Expand Entities -> Contact -> Fields.
    • Create a new field (if you do not have already).
    • Now, click on Keys under Contact entity and create a key based on the column created (or use existing column).

    pastedimage1611828882869v1.png

    • Publish.

    pastedimage1611829274183v3.png

    Please note, you can add up to 5 Keys at max per entity.

    Another approach is to set Duplicate Detection rules to avoid duplicates (based on a a field or a combination of fields), but it won't force uniqueness:

    https://docs.microsoft.com/en-us/power-platform/admin/set-up-duplicate-detection-rules-keep-data-clean

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,080 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,601 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans