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 :
Microsoft Dynamics CRM (Archived)

How to get the value of a field from one Entity to another Entity

(0) ShareShare
ReportReport
Posted on by 108

Hi...I want to know some detail about getting a field value from one entity to another entity.

Eg: I have a field called "Currency" in Opportunity. There is only one record in Currency entity, lets say USD. Now, I want to get the value of that Currency Value in Opportunity to be populated in to field called "Currency" in Quote entity. Currency is a lookup field. I heard, we can get this using Relationships. 

I want to get the value of that field to populated once I moved from Opportunity to Quotation. Sales BPF.

Please help me in getting out of this.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahadeo Matre Profile Picture
    17,021 on at

    Hi,

    you need to define attribute mapping in relationship.

    here are some links

    crm.fullscope.com/save-time-entering-data-into-crm-by-mapping-fields-between-records

    msdn.microsoft.com/.../gg334512.aspx

    When you are using relationship mapping, child record must be created from parent, then only values are transferred to child.

    If you selected lookup in child record, then relationship mapping will not work.

    Another option is to write Javascript to populate values from another entity.

    Hope this will help.

  • Suggested answer
    PS Profile Picture
    23,577 on at

    You can do it by following methods:

    1. Entity Attribute Mapping (which I guess you have already tried)

    crm.fullscope.com/save-time-entering-data-into-crm-by-mapping-fields-between-records

    2. Create a real time workflow

    Trigger workflow on quote creation

    Check condition- quote's opportunity contains data

    Update quote-currency=opportunity currency

    Activate

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    33,628 on at

    Hi,

    Scenario 1 : user create quotation within opportunity form, immediately user need to see the result after form completely loaded.

    1. JavaScript ( CRM 2016 = web api else Odata )

    - by using this feature, user must create the Quote record from opportunity

    - web api reference url : https://msdn.microsoft.com/en-us/library/gg334767.aspx

    2. Entity Mapping ( the field must be same data type  Eg: Lookup to Lookup)

    - by using this feature, user must create the Quote record from opportunity form, else this will not work.

    34562.1.png

    Scenario 2 : User create Quote Record outside opportunity form,immediately user need to see the result after select opportunity in Quote record.

    1. JavaScript ( CRM 2016 = web api else Odata )

    - by using this feature, user need to select opportunity in Quote entity.

    - web api reference url : https://msdn.microsoft.com/en-us/library/gg334767.aspx

    Scenario 3: The result is insert after user save the Quote record.

    - You can do it using workflow.

    Background Workflow

    - delay few seconds

    - will use the workflow owner privilege to update the record.

    - in audit history, recorded as workflow owner name.

    Real Time workflow (CRM 2013 and above)

    - immediately update after save

    - either run as workflow owner or user who triggered the workflow (configurable)

    -in audit history , either recorded as workflow owner or user who triggered the workflow ( based on the second configuration you set).

  • SaiKrishnaGudluru Profile Picture
    108 on at

    Hi Mahadeo, Thank you. But I have already

    done this mapping but it didnt help me getting my requirement. I have a relation N:1 in Opportunity to Quote, as I need to get the value of currency field from that.  There i mapped Currency in Opportunity with Currency in Quote. But not getting populated ;-( .

  • SaiKrishnaGudluru Profile Picture
    108 on at

    Hi Fun Wei Jie, Thank you for your quick response. I guess as you mentioned we can get it through JS then. But I want to get it done by OOB features only.

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    33,628 on at

    you need to create the Quote record within opportunity form, else mapping does not work. refer to the post i replied earlier 

  • SaiKrishnaGudluru Profile Picture
    108 on at

    Hey Prashant, thank you yar. 1. Mapping I have tried already.

    2. have to try with workflow

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans