Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested answer

User lookup filtered by specific team

(0) ShareShare
ReportReport
Posted on by 342

Hey, Everyone

I need to add a user lookup on the opportunity form that shows only the members of a specific team.  I tried to create a view that shows the users but I was not able to create a system view that can do this.  I create a personal view, but that's not what I need.  Any ideas?

Thanks.

  • Suggested answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at
    RE: User lookup filtered by specific team

    Joe,

    Can you please explain what is the blocker? I checked my environment and I had no issues creating the view. Here are steps I used:

    1. Open System - Customizations.

    2. Click Customize the System.

    3. In solution window popped up expand Entities and scroll to User entity.

    4. Expand "User" node and click on Views.

    5. Click "New", in the window appeared click "Edit Filter Criteria".

    6. In the dialog choose criteria and click "OK".

    7. Save view and publish changes.

    8. Use this view in the settings of lookup field you mentioned.

  • jgspitler Profile Picture
    342 on at
    RE: User lookup filtered by specific team

    That is what I tried first but I was unable to create a successful system view that uses the teams entity.  A personal view worked just fine but when I tried to create the system view it would not save with the specific team identified in the filter.  I struck me very odd.

  • Suggested answer
    ajyendra Profile Picture
    1,738 on at
    RE: User lookup filtered by specific team

    Use this Fetch Xml and create Custom View for that filter using javascript . How to do that please refer this forum 

    https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/203026/creating-custom-view-using-javascript

    Hope it helps

  • Suggested answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at
    RE: User lookup filtered by specific team

    Hello,

    Here is what you can do:

    1.  Create the correspond views through customization - that will create a system view, not the personal view.

    2. Add a lookup and limit the list of views available to the one you created on the step 1.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daivat Vartak (v-9davar) Profile Picture

Daivat Vartak (v-9d... 225 Super User 2025 Season 1

#2
Vahid Ghafarpour Profile Picture

Vahid Ghafarpour 78 Super User 2025 Season 1

#3
Sahra Profile Picture

Sahra 43

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans