web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Option Set field Mapping
Customer experience | Sales, Customer Insights,...
Answered

Option Set field Mapping

(0) ShareShare
ReportReport
Posted on by PS10 8

Hi Experts, 

I have  two entities say A and B with relation of (A)1:N(B).

I have an option set O with values 1, 2, 3, 4 and sits on entity A. This value of O can change anytime on a particular record.

Now i want same option set on entity B, and want to map and change the value of O on B with the same value as on A.

eg. 

Say on a record to begin with, A--> O = 2 then I want on all related records of B to be set as O = 2

When on the same record, value changes to say 1, A-> O = 1 then all related records of B--> O must change to 1.

Any suggestions please. 

Note: we are d365 on-premise

Thanks,

PS

I have the same question (0)
  • Suggested answer
    Charan Raju C R Profile Picture
    Charan Raju C R 7 Moderator on at

    Hi PS10,

    Create plug-in steps which triggers on update of option set field O on entity A and on create of entity B.

    Plug-in step which triggers on update of field on entity A sets the option set field O on all child records of B entity from parent record of entity A.

    Plug-in step which triggers on create of entity B record will set the option set field O on record of B entity (which is being created) from parent record of entity A. This create plug-in step can also be replaced by field mapping under the N:1 relationship on entity B.

  • Verified answer
    dian74 Profile Picture
    dian74 2,477 Most Valuable Professional on at

    It looks like the option set of the B table needs to have the same value as the option set on the A table. Instead of building a separate option set on the B table and having to update the value, why don't you create a quick view form with the optionset field from the A table and place the form on the 'B' table? This way you'll be able to see the value. You can also create views for the 'B' table where you pull in the option set from the 'A' table. 

  • Suggested answer
    PS10 Profile Picture
    PS10 8 on at

    Hi Dian,

    Thank you for your reply, that's what i did and it worked.

    Thanks,

    PS

  • PS10 Profile Picture
    PS10 8 on at

    Thanks for your reply Charan, keeping it out of box, Quick view form worked.

  • dian74 Profile Picture
    dian74 2,477 Most Valuable Professional on at

    Great! You're welcome!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
ManoVerse Profile Picture

ManoVerse 197 Super User 2026 Season 1

#2
CU11031447-0 Profile Picture

CU11031447-0 100

#3
NeerajPawar Profile Picture

NeerajPawar 70

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans