insert dynamic text tab in email template

(0) Share

Report

Posted on by Community Member

i am not able to fetch data of foreign key entity in email template.

i am trying to show the name of the business unit trying this syntax {!evtech_ticketrequest:ownigbusinessunit/@name;}

and to show start date of event i am trying {!evtech_ticketrequest:evtech_eventid/@evtech_stratdate;}

not getting any output from these

if somebody can help me with this shall be very thankful , I am kind of stuck in here need urgent help

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Nya 29,060 on at

Like (0)

Report

Hi,

It seems you’re using a custom entity whose logical name is evtech_ticketrequest.

The syntax of the dynamic content for Lookup field should be

{!EntityLogicalName:FieldLogicalName/@name;},

and for Date field should be

{!EntityLogicalName:FieldLogicalName/@date;}.

Here is an example:

(+) Insert dynamic values in Email Templates from Custom Entities - Microsoft Dynamics 365 Community

So your syntax for start date need to be changed to something like:

{!evtech_ticketrequest: evtech_stratdate/@date;}

(Please comfirm if the name of the field is stratdate ore startdate here.)

Please have a try to see if it works.

And for Business Unit, the field is a bit special. Please refer to the next article to know more about it.

The mystery of the OwningBusinessUnit, or how can we use Advanced Find to locate all records in a particular BU? | It Ain't Boring (itaintboring.com)

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Nya

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hii Nya,

evtech_startdate is not a field in evtech_ticketrequest

evtech_eventid is the foreign key placed in evtech_ticketrequest

evtech_startdate is the field of evtech_eventid

is it possible to fetch it using {!evtech_ticketrequest: evtech_startdate/@date;} ?

Was this reply helpful? Yes No
Suggested answer

Nya 29,060 on at

Like (0)

Report

Hi,

I’m sorry for the misunderstanding.

If the Start Date is the field in the other entity, it cannot be fetched with {!evtech_ticketrequest:evtech_startdate/@date;}

Unfortunately, the lookup field can only fetch the name with GUID by

{!EntityLogicalName:FieldLogicalName/@name;}

If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.

Best Regards,

Nya

Was this reply helpful? Yes No

Join the conversation

Community site session details

insert dynamic text tab in email template

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

insert dynamic text tab in email template

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates