cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cjanow
Helper I
Helper I

Remove contact from all marketing lists they are a member of

I'm building on top of a workflow that runs when an email bounces within the D365 Marketing App.  After setting the do not bulk email field, I want to remove the contact from all marketing lists they are a member of.   I'm having trouble building the query to retrieve only the lists a particular contact is a member of.  I would rather not retrieve all marketing lists, go through each list to see if the contact is a member, and if they are remove them due to runtime reasons.  

 

Can anyone provide some insight?

1 ACCEPTED SOLUTION

Accepted Solutions
edgonzales
Super User
Super User

@cjanow 

It's been a while since I've worked in this, but I think there is an entity called "Related Records" or something close, which would have the two entity types (contact : marketing lists in your example) and then a GUID for the contact, and a corresponding GUID for the appropriate list.  

So, if your contact was on four lists, I would expect to find four rows once I narrowed the related entities to contact and lists.

If I can find an instance to log into, I can double check and get more specific, but I thought that might be enough to get you started.

 

Keep us posted.

-Ed

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

View solution in original post

1 REPLY 1
edgonzales
Super User
Super User

@cjanow 

It's been a while since I've worked in this, but I think there is an entity called "Related Records" or something close, which would have the two entity types (contact : marketing lists in your example) and then a GUID for the contact, and a corresponding GUID for the appropriate list.  

So, if your contact was on four lists, I would expect to find four rows once I narrowed the related entities to contact and lists.

If I can find an instance to log into, I can double check and get more specific, but I thought that might be enough to get you started.

 

Keep us posted.

-Ed

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,530)