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

(0) Share

Report

Posted on by madiri

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.

All responses (1)

Answers (1)

Verified answer

v-alzhan-msft on at

Like (0)

Report

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

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.