Cloud Flow with MySQL DB and Dataverse

[MarcusBrueckman]

Hello to all

I think i posted my last question in a wrong board.

I know double post are  ugly but I don't know how to move the post.

Please apologize for this.

I have the following challenge.

I use Dynamics365 Sales there we mantain our customers additionally we have an Webshop (MySQL DB) containing also our customers.

Both systems can only be merged over the field accountnumber.

Now i want some  MySQL Database fields shown in Dynamics365 Sales.

For that i installed an onpremised Datagateway.

Connection are configured and functional and i can connect to the Database

My idea now was to create a Cloud Dataflow

But I can't get it to say take the field "lastlogin" and "customer number" from the mysql database and write the value of "lastlogin" to the corresponding record in Dynamics365 based on the field "accountnumber".

My squence in the flow looks like that

• Recurrence 1day
• GetRows from MySQL Database table fe_users Connector : MySQL
• Update a row ( in Dynamics365  Entity Account) Connector : Dataverse Microsoft
  • in RowID i want to use the field accountnumber from the entity Account from Dynamics, but when i use "add dynamic content" I only can chosse fields from the MySQL DB (because the field "kundennummer" in MYSQL DB is equal to "accountnumber" in Dynamics365.

What are my missing Steps ?

Or what else can i do ?

My idea was inserting a step that will be evaluated for every record coming from  MySQL but then all records  Dynamics are read and i get an Buffer overflow.

I can't filter : ( accountnumber from Dynamics equal to accountnumber coming from mysql . Or Í don't know how.

Every idea is helpful and welcome.