Is there a way to use a Process / Workflow to remove all related records from a table? Specifically, I want to clear all the Members (they are Leads) from a Marketing List as part of a process. I don't want to delete the Leads, just remove them from the Marketing List.
We have a third party solution that syncs Marketing Lists for bulk email operations. We'd like to be able to select one or more Leads and add them to that list (easy), but also clear out any older, existing members.
If I can't do this via a process, what is the jscript approach to doing this?
Hi GBarkin,
So you still want to achieve it through flow? Or accept the function of the "Manage Members" button in the answers above?
If you have found the answer, don’t forget to click Yes under "Did this answer your question?" to close this thread.
Thanks.
"Workflow does not have the function of searching records, we will have to use Power Automate (flow) to achieve it."
That's what I figured. Thanks.
Hi GBarkin ,
As mentioned in the answers above, the easiest and fastest way is through Manage Members > Remove using Advanced Find in the command bar, then click Find and Remove all.
If you want to use workflow or flow to achieve, then this will be more troublesome.
First of all, Lead and Marketing List have an N:N relationship, and they are connected through the listmember entity.
If you want to remove all the leads form the current Marketing List, then we need to search out the listmember records related to the current Marketing List record first, and then delete these listmember records.
Workflow does not have the function of searching records, we will have to use Power Automate (flow) to achieve it.
So, the easiest way to quickly remove all members is by Remove using Advanced Find within D365.
Hi,
As suggested you can achieve your requirement with Manage Member ->Remove using Advanced find ribbon button.
This will work if Marketing list type is Static.
Hi,
I think you can use the Manage Members ribbon button on Marketing list if the list is not locked.
Best Regards
PG
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156