Showing results for 
Search instead for 
Did you mean: 
New Member

update contact id with sql record



I'm bit new to the Microsoft Flow. Currently, I'm trying to add a record to contact entity in D365 from sql DB. Lets assume that there is a table called customer in sql and primary key is customer id. This field is having a guid and I need to map it with contact id. But in the CRM create record connector not showing this coulmn under the parameter list. Can anyone please help me.


Thank you so much

Community Support
Community Support

Hi @AkilaCham ,


Do you want to create a new record in Dynamics 365 Contacts entity using with SQL records?


Per my certain test, I found that the returned Contact Id of a contact is a GUID which is generated automatically.


There is no field for Contact Id in the action Create a new record.


I have made the following test for your reference.



Best regards,



Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (32,551)