Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

Contact Insights - populate custom fields from standard email fields

(0) ShareShare
ReportReport
Posted on by 431

Hi All,

How to populate custom fields displayed on Page - "Create Interaction" with standard fields from Outlook e-mail message? I mean auto-populate.

I have a below case:
Business Case: As email message is received, Sales Manager reads the received email message and creates an interaction, where the process should be automatized as much as possible.
Solution: BC Outlook Add-in is going to be used to insert a contact and create an interaction where custom fields are exposed ("Mail From", "Mail To", Mail Received On", etc.) and where procedure is going to automatically populate custom fields from fields of the email message ("From:", "To:", "Subject", "Sent") and the body text of the email message is going to be imported in the field "Comments" (blob datatype).   
Could you please point me in the right direction on extending the Contacts Insights (BC Outlook Add-in) for BC SaaS?

I have extended standard tables (interaction log entry, segment line, etc.) and displayed those fields on required pages, and created/extended procedures to populate the data. Everything works as expected, except my knowledge is limited regarding the extension of BC Outlook Add-in.


I have read the documentation here:
https://community.dynamics.com/business/b/businesscentraldevitpro/posts/extending-the-business-inbox-in-outlook-part-1-creating-a-custom-add-in
and here:
https://community.dynamics.com/business/b/businesscentraldevitpro/posts/extending-the-business-inbox-in-outlook-part-2-customizing-the-add-in

I understand how it works, but I cannot figure out how to map field ("Subject", "From", "Sent") of the email message to custom field ("Mail From", "Mail To", Mail Received On", etc.).

And I need to insert the email body text to the comments field, that is of type Blob (using Azure Blob Storage) - I think I can use here InStream, OutStreams, right?

Also the signature part would be nice to include in some custom fields of the interaction.

Schema of email message and custom fields:
pastedimage1648796399403v1.png

Thank you

BR Damjan

  • Verified answer
    Damjan Zakojc Profile Picture
    Damjan Zakojc 431 on at
    RE: Contact Insights - populate custom fields from standard email fields

    Hi,

    I would like to update you that I managed to get the data out of the email message as requested.

    I created a procedure to fill data inside OnInitializeContext in CU:"Office Host Management"

    Thanks

    BR Damjan

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Contact Insights - populate custom fields from standard email fields

    Thank you.

    Hope you will get a few answers. There is an event in Orlando, so it may take a while before you receive an update.

    Thanks.

  • Damjan Zakojc Profile Picture
    Damjan Zakojc 431 on at
    RE: Contact Insights - populate custom fields from standard email fields

    Hi,

    I already posted same question on Yammer - https://www.yammer.com/dynamicsnavdev/#/Threads/show?threadId=1674761414254592.

    Thanks Damjan

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Contact Insights - populate custom fields from standard email fields

    Hello,

    We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

    www.yammer.com/dynamicsnavdev

    dynamicsuser.net/.../developers

    I will open this up to the community in case they have something to add.

    Thanks.

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans