CRM Online - Field to count marketing list number of members, for static and dynamic list, with more than 50000 members

(0) Share

Report

Posted on by Community Member

Hello all,

I have to create a field on marketing list to count the number of members. This field needs to count the members for both types of marketing list : static and dynamic. A marketing list can contain more than 50 000 members.

How can i do that?

I was recommended to use fetchxml with javascript, or create a workflow, but i don't know how to do this.

Thank you!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

ScottDurow 21 on at

Like (0)

Report

There is already a Member Count field for Static lists. For dynamic lists it is harder. You can't use a rollup field and so you'd need to get a developer to write a workflow activity that can total the number of members on a scheduled basis. This is not a simple task!

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Dynamic list stores the FetchXML to retrieve the list of members at the time of use. You can write a workflow activity/plugin to get the fetchXML and use it to count the number of members. Run that workflow on demand to get the latest count.

Was this reply helpful? Yes No
Inogic 709 on at

Like (0)

Report

For dynamic Marketing list you have to retrieve query (query attribute for marketing List) for the marketing List. Later you can execute retrieved query to find members for the marketing List you can use field Members Count from Marketing List to get static members count.

Fetch XML to retrieve query attribute for marketing list is as below.

Thanks,

Sam

Was this reply helpful? Yes No
M.V 35 on at

Like (0)

Report

Hi Vikas,

could you please provide the steps of creating a workflow in order to retrieve the FetchXML showing the number of members within dynamic Marketing Lists.

Was this reply helpful? Yes No
Suggested answer

Sreevalli 3,256 on at

Like (0)

Report

Hi,

Query expression will be easy to use for list member retrieval.

see some help links,

community.dynamics.com/.../retrieve-marketing-list-members

community.dynamics.com/.../learning-how-to-query-for-marketing-list-members

Was this reply helpful? Yes No