cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate V
Advocate V

Flow - Dynamics Update Record

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?

 

mappingfield.JPG

 

Dynamics_RecordID.JPG

 

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

 

create_new_record.JPG

 

Dynamics_Contact.JPG

 

 

Thanks

Jag

1 ACCEPTED SOLUTION

Accepted Solutions
Frequent Visitor

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.

Annotation 2019-11-07 171354.png

 


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

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

 

Thanks!

Kirsh

View solution in original post

4 REPLIES 4
Responsive Resident
Responsive Resident


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

Frequent Visitor

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.

Annotation 2019-11-07 171354.png

 


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

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

 

Thanks!

Kirsh

View solution in original post

Frequent Visitor

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?

Responsive Resident
Responsive Resident

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.

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (4,665)