how to get created record from dynamics and insert into azure sql service using microsoft flow.

[rocky5]

HI, in Microsoft flow don't know is it possible or not can anyone say is it possible or not if possible can you explain. i want to get created record from dynamics 365 if the record is create i need to insert a record to azure sql. i want to get update a record from dynamics 365 if the record is update i need to update a record to azure sql i.e it will have guid which is same as dynamics but i want to get update guid and need to search in sql and update. i want to get deleted record from dynamics 365 if the record is deleted i need to deleted a record to azure sql i.e it will have guid which is same as dynamics but i want to get deleted guid and need to search in sql and delete.

[v-alzhan-msft · Accepted solution]

Hi @rocky5 ,

You could create three flows with the below triggers to achieve the requirement:

When a record is created in the dynamic 365, create the record in the sql server.

When a record is updated / deleted, check the same item in the sql server, update/ delete the record.

Best Regards,

Alice

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