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)

Sort by

Suggested answer

meelamri 13,218 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

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
meelamri 13,218 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Any news ?

Was this reply helpful? Yes No
LMata 64 on at

Like (0)

Report
Copy link

Link copied!

Yes, thanks that did work.

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

Like (0)

Report
Copy link

Link copied!

Please verify my answer to close this thread.

Was this reply helpful? Yes No