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?

[Jronash]

Hi rvdstelt, In case you're still working on this...

MailChimp verifies your webhook URL by sending a GET request.  So when you set up your Flow with the 'When a HTTP request is received' trigger, you need to go to the advanced options on your trigger and set the method to 'GET'.  Then go back to MailChimp and go through the process of creating your webhook subscription.  After the webhook is created, go back to your Flow and change the method to 'POST' so that you will be able to receive the webhook events.

Hope that helps.

[amh15]

@Jronash Changing the request type to GET before validating the webhook URL in mailchimp totally fixed the Mailchimp 400 problem for me! Thanks so much!