Update 2 columns in Dynamics 365 sync using Mapping data Flow and mapping question

drhorg 61 Reputation points

In Dynamics 365/Dataverse I need to update 2 columns based on the ID column. so I have a parquet source file with 3 columns (ID + 2 columns) .the Dynamics destination there are (ID + 2 columns that need updating based on common ID column) + another 17 columns that will not need to be updated.

Can I do that in the data flow? or how else can I do?

Also when I create the Dynamics sync I can preview the dataset fine but when doing the mapping there is nowhere to import the mapping? So I see the same columns in output and input as the source columns. Can you please help?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,444 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. MarkKromer-MSFT 5,186 Reputation points Microsoft Employee

    Have you created a Dataverse dataset and included that in your sink? You should be able to import the target schema in the dataset and then map only the columns you wish to map inside the Sink mapping tab by including that dataset in the sink.