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.
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?
1 answer
Sort by: Most helpful
-
MarkKromer-MSFT 5,206 Reputation points Microsoft Employee
2022-08-26T08:14:22.69+00:00