cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarcusBrueckman
Frequent Visitor

Cloud Flow with MySQL DB and Dataverse

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.

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,043)