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?
Solved! Go to Solution.
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.
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.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
32 | |
31 | |
24 | |
24 | |
20 |
User | Count |
---|---|
60 | |
57 | |
43 | |
37 | |
28 |