Answered

Adding a Contact Point in Contact Point Consents via created Lead

(0) Share

Report

Posted on by Community member

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

Categories:

Consent and Compliance

All responses (2)

Answers (1)

Community member 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