Adding SQL External table to Contacts Table Dynamics 365

(0) Share

Report

Posted on by Community member

In the CRM, specifically in the Dynamics 365 > Customers > Contacts table that I would like to add a column to that table. This column would already be created in my SQL server from a table in my database. Is there a way to be able to link this existing table to my table in CRM through some means directly or an Azure database connection. I already tried clicking on 'add existing columns' but that only links to tables on Dynamics 365. The only was I able to do what I needed was to manually create a blank column from that table and use a Power Apps flow to populate it with a SQL flow. If there is a way to do this directly so I don't need to keep creating a flow that would be much easier. Thank you for your time.

I have the same question (0)

All responses (1)

Answers (0)

Haig Liu Microsoft Employee on at

Like (0)

Report

Hi Partner,

Please refer to the following link:

https://www.simego.com/blog/dynamics-365-import-custom-entities-and-related-data

Regarding the external tables, I'm not sure if you're using a dynamic NAV application, but if so, it's recommended that you seek more specialized help on the NAV forum.

Best Regards,

Haig Liu

Was this reply helpful? Yes No