Adding a Contact Point in Contact Point Consents via created Lead

(1) Share

Report

Posted on by MA-01051425-0

Hi all, is it possible to add a Contact Point into the entity Contact Point Consents from a newly created Lead when a certain field is populated? If so, how would we do that (we are thinking Power Automate Flow) and do we use the msdynmkt_contactpointconsent4? Thanks

All responses (5)

Answers (1)

CU15101452-0 4 on at

Like (0)

Report

Adding a Contact Point in Contact Point Consents via created Lead

Hi, may I ask if this approach was working also for Leads? As this process was meant to be for new created Contact. Thank you
MA-01051425-0 43 on at

Like (0)

Report

Adding a Contact Point in Contact Point Consents via created Lead

Hi Hugh Cui,

Thank you for your great response.

I have one last question.

How would I enable the Flow to match the subscriber with the Topic, if I had several Topics representing different newsletters?

Thank you.
Cui Hao on at

Like (1)

Report

Adding a Contact Point in Contact Point Consents via created Lead

Hi,

The following changes were made to the previous flow：

1.Delete the contents of this Filter rows field.

2.Nesting conditions within conditions.

subscriber : represents the subscription field newsletter.

3.topic: fill in the lookup field, representing the topic, and fill in the id inside.

This one is for the changes made to the last flow, you may refer to it.
MA-01051425-0 43 on at

Like (0)

Report

Adding a Contact Point in Contact Point Consents via created Lead

Thank you, Hugh Cui!

I need to now add a Contact Point into Contact Point Consents from a newly created Lead where the field subscriber contains "newsletter" so that it matches the Topic in the Active Contact Point Consents?
Verified answer

Cui Hao on at

Like (0)

Report

Adding a Contact Point in Contact Point Consents via created Lead

Hi,

Power Automate Flow can fulfil this requirement for you and the table used is msdynmkt_contactpointconsent4.
The operation is as follows:
1. The field we are testing with is the fullname field. This flow is triggered when fullname is not null.

2.Commerial Consent : This is a dynamic expression { if(and(equals(triggerBody()?['donotemail'], false), equals(triggerBody()?['donotbulkemail'], false)),534120001,534120002)}

3.Filter rows：msdynmkt_contactpointvalue eq '@{triggerOutputs()?['body/emailaddress1']}' and
_msdynmkt_purposeid_value eq '@{variables('''Purpose Guid ''')}' and
msdynmkt_contactpointconsenttype eq 534120000 and
msdynmkt_contactpointtype eq 534120000

4. content type must be selected.

5. After testing, this is working successfully.

You can do what I did above. The reference documents are as follows: Create a consent record using a cloud flow - Dynamics 365 Customer Insights | Microsoft Learn.

Best regards,
Hugh Cui