web
You’re offline. This is a read only version of the page.
close
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.

I have the same question (0)
  • Suggested answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at

    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.

  • Suggested answer
    ajyendra Profile Picture
    1,738 on at

    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

  • jgspitler Profile Picture
    342 on at

    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
    a33ik Profile Picture
    84,331 Most Valuable Professional on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 33 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans