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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Dynamic values from lookup in email template crm 365

(0) ShareShare
ReportReport
Posted on by 2,667

Hi All,

I have Account entity email template in this i need to get dynamic values from custom entity like:

On Account entity one lookup field Primary Address (Address Master entity) is there & from Primary Address  lookup field District is available.

Here Can i get dynamic values of this District from Address Master entity in Account email template ?I have used below template but its showing null district value.

pastedimage1651230852334v1.png

pastedimage1651231157868v1.png

Is it possible ?

Anyone have any ideas ?

Thanks,

Jharana

I have the same question (0)
  • Suggested answer
    Amit Katariya007 Profile Picture
    10,409 Super User 2025 Season 2 on at

    Hello,

    Please refer below article where you will have information related with the Email Templates.

    darrelljacksonblog.com/.../

    Thank you,

    Amit Katariya

  • Jharana Baliyar Singh Profile Picture
    2,667 on at

    Hi Amit,

    I have followed the link u shared: I am using like below :

    Type am using Account email template not global.

    {!schemanameofprimaryaddressentity : districtschemaname/@name ;}

    {!new_address : new_district/@name ;}

    But its giving null value.

  • Suggested answer
    Amit Katariya007 Profile Picture
    10,409 Super User 2025 Season 2 on at

    Hello,

    Can you use Global Template type.

    Thank you,

    Amit katariya

  • Jharana Baliyar Singh Profile Picture
    2,667 on at

    Hi Amit,

    I have used global template also but no value.

    Thanks,

    Jharana

  • Suggested answer
    Bipin D365 Profile Picture
    28,983 Moderator on at

    Hi,

    Please try below blog.

    rawishblog.wordpress.com/.../

    make sure you are specifying the correct schema name and field name in lower case letter. And when you click on save it should turn into yellow color.

    Please mark my answer verified if this is helpful!

    Regards,

    Bipin Kumar

    Follow my Blog: xrmdynamicscrm.wordpress.com/

  • Jharana Baliyar Singh Profile Picture
    2,667 on at

    Hi Bipin,

    Thanks for your response.

    I have used correct scehmaname in lowercase & once save it will aitomatically set the field with display name what we are using in crm entity.

    But here what syntaxt should use to get lookup value district  present in the primary address entity & primary address is avilable in Account entity.

    Thanks,

    Jharana

  • Verified answer
    Bipin D365 Profile Picture
    28,983 Moderator on at

    Hi,

    At the moment its not supported. You can just take value of the lookup record. however cannot go inside that record to get its other field values.

    You can create new custom field in Account entity and auto populate this with Workflow/JS/Plugin and use that in your email template.

    Please mark my answer verified if this is helpful!

    Regards,

    Bipin Kumar

    Follow my Blog: xrmdynamicscrm.wordpress.com/

  • Jharana Baliyar Singh Profile Picture
    2,667 on at

    Thanks for response Bipin. Yes I was assuming the same & taking other field by populating value from primary address lookup.

    Thanks,

    Jharana

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 83 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 49 Most Valuable Professional

#3
#ManoVerse Profile Picture

#ManoVerse 40

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans