email subject line dot walked field not populating after email being triggered

[Adil a]

Hi,

I have a requirement wherein I have to create an email notification from sc_request(Request) table. On the request table I have a field called customer organization (this field is dot walked from custom table request_info table). On the subject field of email notification I kept like this New Onboarding Request - ${number} submitted for ${x_request_info.u_customer_org}. On service portal there is customer organization field is there from there it is mapping to request_info table using flow designer. So for some request the customer org name is populating and for some request it is not populating. (though on request form which is dot walked the customer org is populating but not on the subject field of email.  

[Amit Verma]

Hi @Adil a 

Have you checked the system logs for any errors in cases where the data doesn't pops out ? Also, you should try the suggestion given by @Mark Manders

Thanks & Regards

Amit Verma

[Mark Manders]

So you have a custom application to store variables? That really sounds like a overkill, but maybe there is a good reason for it. Cost wise, I have my doubts, since it's all data in the base platform you can access easily.

For the issue: Can you set your email notification to 'triggered' and add the notification as 'send notification' in your flow, below the part where the info gets created in the custom table. Maybe even a wait of 10 seconds before the email is send and then see if it keeps working. If not, it may be a data issue.

[Adil a]

thanks @Mark Manders  will try this and keep you posted.