Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications


Dynamic Marketing Lists in CRM 2011 – No Results in Advanced Find?

Post Author: Joe D365 |

Hello intrepid CRM adventurers! Today we'll talk a little bit about Dynamic Marketing Lists. They are one of the most useful features of Microsoft Dynamics CRM 2011.

One of the hassles in the 'old days' of CRM was that your only option was to have a Static marketing list. This meant that you had to re-run your marketing list query to pull new data each time you want to use the marketing list.

Unlike their static cousin, Dynamic marketing lists continuously update. So, as an example, if you have a dynamic marketing list that has all your contacts in Minnesota, any new contact you add that is in Minnesota will automatically be added onto the list! Pretty handy, eh?

However, an issue arises when you want to do an advanced find that returns all the contacts that are on a specific dynamic marketing list. The search seems very straight-forward; we just want to look for contacts where the related marketing list = Test List.

Here is the advanced find query we would use. Looks fine right?

Dynamic Marketing Lists in CRM 2011

When you look at the results of this search, we do not have any data retrieved.

The reason? Dynamic marketing lists in CRM 2011 do not store the 'membership' of the list like the static marketing lists do. Dynamic marketing lists are essentially saved Advanced Find Views, and the 'list membership' is created when the marketing list is used in a campaign, not before. This makes it impossible to see dynamic marketing list membership in an advanced find or report.

One of the solutions to this issue is quite simple: Rather than creating the advanced find based on membership of the marketing list, use the same query that we used when we set up the dynamic marketing list. Since the dynamic list is using the same search, the information it returns should be the same!

That's it!

Let the CRM experts at PowerObjects know if you have some reporting question that you cannot get solved. As always, happy CRM'ing!

Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

2 comments on “Dynamic Marketing Lists in CRM 2011 – No Results in Advanced Find?”

  1. This marketing lists in CRM 2011 has issues. This is great. Thanks for sharing this information

    1. Hi, This is not issue. This is working as per CRM functionality. When create static list and add list members, it actually creates relationship between marketing list and member. Using same relationship CRM is able to pull data in advanced find.

      However in dynamic list contains only query and not making any relationship between members and list reason not able to see data in advanced find

PowerObjects Recommends