Flow - Dynamics Update Record

[jasb81]

Hi All,

I have a flow that receives updates from a Mailchimp webhook when members update their profile. I then want to update the member respective record in Microsoft Dynamics but get the error below on record id.

I'm not sure why the flow is failing and what value should go in the record id field when a record is updated in Dynamics?

RecordID: I have another Create Member Flow which uses the Mailchimp Flow connector to create a new record in Dynamics, when someone signs up for a newsletter via the mailchimp form. As part of this flow, I capture the unquie_email_id and saved in Dynamics when a new record is created

Thanks

Jag

[CollabTechie]

Hey @jasb81 
You are trying to update a Dynamics record so you need to get the record(s) with Flow and then pass the ID to the update record action. A mailchimp ID won't work because Flow doesn't know what record it should grab and update in Dynamics.


----------------------------------------------------------

If this post was help and solved your issue, please give a thumbs up or mark as solution

[KirshanthanJ · Accepted solution]

Hi

You need to pass the Dynamics Record ID (unique Identifier) to update the Record in step 2.

If you don't have the Dynamics Record ID then information you need to use the "List Records" step before the update record step to pass any identifier from Mailchimp webhook to match D365 Record and get the Record Identifier to update. 

In my case I am passing the Twitter Name to Dynamics Record Contacts Last Name to get the record Id.

----------------------------------------------------------

Hope this post was helpful, please give a thumbs up or mark as solution

Thanks!

Kirsh

[rvdstelt]

Goodafternoon, @jasb81 

I have a problem and i can see it is working with you. How did you get the trigger to work. Mailchimp webhook first sends you a get to verify the url and the a post. But when i input the url into mailchimp i get the folowing message We couldn't verify the URL is working. Please double check and try again. HTTP Code: 400. Can you please help?