Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Create a Dashboard with Marketing lists or multiple Y/N

Like (0) ShareShare
ReportReport
Posted on 21 Apr 2021 08:45:29 by 55

I have a list of dynamic Marketing lists and I wanted to put a dashboard together to highlight how many members are on those marketing lists.

 

Or if it would be easier I have 5-7 Yes No fields on a contact how could I combine all of these on to one chart so I can basically see how many Contacts are ticked for each marketing list?

 

Please help if you could kindly provide some screenshots also

Categories:
  • EricRegnier Profile Picture
    8,714 Most Valuable Professional on 23 Apr 2021 at 21:03:03
    Re: Create a Dashboard with Marketing lists or multiple Y/N

    Hi @Justin365,

    To keep it simple you probably don't need marketing list and would stay away if possible. You can easily create a chart to see how many contacts per tick and then drill down to these contacts. You can display that chart in a dashboard or in table list or forms with the "Show Chart" button.

    Hope this helps!

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 22 Apr 2021 at 00:07:03
    Re: Create a Dashboard with Marketing lists or multiple Y/N

    Hi @Justin365,

     

    Just came across another link that discusses some of the Dynamic marketing list approaches you could use as well:  https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/197338/crm-online---field-to-count-marketing-list-number-of-members-for-static-and-dynamic-list-with-more-than-50000-members/922854 

     

    Thanks!

     

    Drew 

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 22 Apr 2021 at 00:01:05
    Re: Create a Dashboard with Marketing lists or multiple Y/N

    Hi @Justin365,

    I was thinking through this and did some more research and have some additional thoughts.

    1.  If the Marketing Lists were "Static" vs. "Dynamic" from a membership perspective there is already a "Member Count" field on the Marketing List table that would be populated with the total members in the list.  

    Screen Shot 2021-04-21 at 6.49.18 PM.png

    If you have this you can create a chart in the Marketing List entity like the following:

    Screen Shot 2021-04-21 at 6.56.07 PM.png

    From here you can create your own dashboard like the following adding this chart:

    Screen Shot 2021-04-21 at 6.58.30 PM.png

     

    Let me know if this is what you are looking for...  If your Marketing Lists are Dynamic in membership well, then we have another discussion as some of the steps above will not work because the counts are not populated for Dynamic Marketing Lists...

     

    Hope this helps.   Please mark accepted if solved your question and Like if helped at all.

     

    Thanks much,


    Drew

     

     

  • Justin Wilkinson Profile Picture
    55 on 21 Apr 2021 at 20:16:08
    Re: Create a Dashboard with Marketing lists or multiple Y/N

    @dpoggemann  thank you for the reply. Is there a simplistic way to do this using some y/n checkboxes against a contact

    For example I have 5 Y/N Tickboxes against a contact which reference the Marketing lists. Is there a way to easily create a D365 Chart with that on one chart if your able to provide some screenshots or examples would be super appreciated.

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 21 Apr 2021 at 10:15:10
    Re: Create a Dashboard with Marketing lists or multiple Y/N

    Hi @Justin365,

     

    The relationship here is a N:N relationship in Dynamics 365 between the Marketing List and the List Member (listmember) table.  There is no out of the box way in Dynamics 365 that you will be able to create a dashboard for this.  The following is a link to an article about extracting with FetchXML:  https://syncratec.com/marketing-list-member-details/ 

     

    You are not able to create a rollup field on the Marketing List because it will not show you the N:N relationships either to the listmembers.

     

    One option here might be to utilize Power BI to create the report / dashboard you are looking for.  This link discusses what tables to go after when connecting...

    https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=16b818ef-f307-4bd9-a21b-adf10604f8e9&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer 

     

    The Marketing lists can also be dynamic vs. static which would be very tough to create a dashboard as the membership is evaluated based on a query.  

     

    Sorry, not an easy ask with Dynamics 365.

     

    Hope this helps.  Please accept if answered your question or Like if helped.


    Thanks,


    Drew

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
SadFox Profile Picture

SadFox 2

Overall leaderboard

Featured topics