Microsoft Dataflow to update CRM records

(0) Share

Report

Posted on by LMata

Using Microsoft Dataflow I have created a flow to integrate data from a SQL table that creates records in CRM. I am needing to have the records in CRM be updated and not new records created. Can I have records updated using Microsoft Dataflow instead of creating a new record?

I have the same question (0)

All responses (4)

Answers (0)

meelamri 13,216 User Group Leader on at

Like (0)

Report

RE: Microsoft Dataflow to update CRM records

Please verify my answer to close this thread.

Was this reply helpful? Yes No
LMata 60 on at

Like (0)

Report

RE: Microsoft Dataflow to update CRM records

Yes, thanks that did work.

Was this reply helpful? Yes No
meelamri 13,216 User Group Leader on at

Like (0)

Report

RE: Microsoft Dataflow to update CRM records

Any news ?

Was this reply helpful? Yes No
Suggested answer

meelamri 13,216 User Group Leader on at

Like (0)

Report

RE: Microsoft Dataflow to update CRM records

Hi,

First you need to create an alternate key in the CRM.

Then, map your source key field to the newly created alternate key.

Please check this excellent blog, you will all the details:

https://nishantrana.me/2020/07/07/load-data-from-sql-on-premise-to-cds-common-data-service-using-power-platform-dataflows-in-power-apps/

Was this reply helpful? Yes No