Share
Report
13Hello 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 ?
All responses (
Answers (
