Power Platform Community Forum Thread Details

Hello professionals

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 "customer number".

My squence in the flow looks like that

Recurrence 1d
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 ?

Categories:

Using connectors