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

Mailchimp Audience data to Microsoft Dynamics 365

Hi All,

 

I'm trying to use Flow to push new subscriber details in a Mailchimp list ( now called Audience) to Microsoft Dynamics custom entity called HCP contacts, when every there is a new signup for the newsletter.

 

The issue is I cannot see all the Mailchimp signup form fields in Flow. Any ideas how I can pull all the data in a Mailchimp Audience and then map to the Dynamics fields.

 

*Mailchimp provides the option to setup a free account.

 

Below is the HCP form created in Mailchimp. I created a checkbox "Select Newsletter subscriptions" which is not visible in Flow. I also noticed that the Postal Code and State fields are not visible in Flow.

 

HCP_Form.JPG

 

Below is how I setup the Flow

 

Flow_Mapping.JPG

 

 

 

Thanks

Jag

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

Re: Mailchimp Audience data to Microsoft Dynamics 365

Hey @jasb81 

 

I just checked this and turns out that the custom fields that you create get created as a part of the Merged Fields attribute. You can first check this once by running the flow and in the run completed, expand the outputs of the trigger to check the attribute correspondant name:

ee3222.PNG

 

In mine it is MMERGE6 and so I used this expression to get that value:

triggerBody()?['merge_fields']['MMERGE6']

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Highlighted
Dual Super User III
Dual Super User III

Re: Mailchimp Audience data to Microsoft Dynamics 365

Hey @Jsb81s / @jasb81 

 

You can follow the sample screenshot below: 

 

ddde.PNG

 

Expression in the condition: 

triggerBody()?['interests']['cecbff563b']

 

Here, cecbff563b is the name of one of the checkboxes I have. 

 

Similarly, you will have 3 checkboxes conditions in the flow and then append the value to a variable only if the option is true. This way you will get the variable populated with the labels for checkboxes that have been selected. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

7 REPLIES 7
Highlighted
Dual Super User III
Dual Super User III

Re: Mailchimp Audience data to Microsoft Dynamics 365

Hey @jasb81 

 

Can you share more details on the fields that you are looking to access and are not appearing the dynamic selector? You can see the details on the available attributes for each action and trigger related to this connector here: https://docs.microsoft.com/en-us/connectors/mailchimp/#getmembersresponsemodel

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
Advocate V
Advocate V

Re: Mailchimp Audience data to Microsoft Dynamics 365

Hi Yash, 

 

I'm not able to see any custom fields created on the Mailchimp signup form. Below fields in the red box are not available  in the Dynamics selector.

 

HCP_Form.JPG

 

 

Jag

Highlighted
Dual Super User III
Dual Super User III

Re: Mailchimp Audience data to Microsoft Dynamics 365

Hey @jasb81 

 

I just checked this and turns out that the custom fields that you create get created as a part of the Merged Fields attribute. You can first check this once by running the flow and in the run completed, expand the outputs of the trigger to check the attribute correspondant name:

ee3222.PNG

 

In mine it is MMERGE6 and so I used this expression to get that value:

triggerBody()?['merge_fields']['MMERGE6']

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Highlighted
Advocate V
Advocate V

Re: Mailchimp Audience data to Microsoft Dynamics 365

That worked 😀. I'm now stuck on how to convert the selected interests field values as circled below to a single line and name them appropriately

 

"4c24d70a18" = Healthcare Newsletter
"13ed1102c2"= General Newsletter
"2539197c55"= Volunteer Newsletter

 

So in the below example i like to create a variable Active Subscriptions which will hold the value Healthcare Newsletter, Volunteer Newsletter based on the checkbox values 

 

activesub.JPG

 

hcpcontacts.JPG

 

newslettercheckbox.JPG

 

 

Thanks

Jag

Highlighted
Dual Super User III
Dual Super User III

Re: Mailchimp Audience data to Microsoft Dynamics 365

Hey @jasb81 

 

In that case, you can initialize a variable and use the condition control to check the "interests" part and see for each value if it is true then append the corresponding label to the variable and so on. These key value pairs are automatically generated based on unique IDs generated internally and you cannot change that on the trigger but in the flow, you can check the numeric value and correspond that to a string label accordingly. (makes sense?)

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
New Member

Re: Mailchimp Audience data to Microsoft Dynamics 365

Still new to flow and would really appreciate if you could help with step please.

Thanks
Jag
Highlighted
Dual Super User III
Dual Super User III

Re: Mailchimp Audience data to Microsoft Dynamics 365

Hey @Jsb81s / @jasb81 

 

You can follow the sample screenshot below: 

 

ddde.PNG

 

Expression in the condition: 

triggerBody()?['interests']['cecbff563b']

 

Here, cecbff563b is the name of one of the checkboxes I have. 

 

Similarly, you will have 3 checkboxes conditions in the flow and then append the value to a variable only if the option is true. This way you will get the variable populated with the labels for checkboxes that have been selected. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Users online (3,042)