Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

No way to search for all related contacts of an account based sorted by industry field

Posted on by Microsoft Employee

My marketing team needs to generate a marketing list based off industry. In this list they want all contacts that are part of certain industry. I can easily get all primary contacts however unable to get all related contacts. Am I missing something or is this a limitation of CRM Online. Please advise. 

2016_2D00_10_2D00_18-15_5F00_18_5F00_46_2D00_Advanced-Find-_2D00_-Microsoft-Dynamics-CRM-_0E202D00_-Microsoft-Edge.png

*This post is locked for comments

  • Suggested answer
    Harish Das Profile Picture
    Harish Das on at
    RE: No way to search for all related contacts of an account based sorted by industry field

    Hi As suggested by Tim, you can use the company name (account) to get all the related contacts. for more clarification please find the attached snaps.

    query 

    KB1.JPG

    Result

    KB1.JPG

    Please Verify this Ans, if it helps to resolve your query.

    Regards

    Harish

  • Verified answer
    Tim Dutcher Profile Picture
    Tim Dutcher 2,100 on at
    RE: No way to search for all related contacts of an account based sorted by industry field

    Where you've selected "Accounts (Primary Contact)", do you not have an option "Company Name (Account)"?  That relationship will give you contacts joined to accounts by the contact's parent account field. You can then filter the account type by industry.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: No way to search for all related contacts of an account based sorted by industry field

    I have updated my post with a picture. Industry field is not exposed under Contacts. So if I want results based of industry, I will need to go through Account entity and the only option available is Accounts(Primary Contact).

  • Suggested answer
    Harish Das Profile Picture
    Harish Das on at
    RE: No way to search for all related contacts of an account based sorted by industry field

    All contacts need to fetch if all the records maintained in same entity. Please share your query for more clarification if it is possible.

    Regards

    Harish

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans