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
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?
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