Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Dynamics 365 View creation based on condition.

(0) ShareShare
ReportReport
Posted on by 2

Hello All Experts,

I have to create a view in which i have to apply filter for.

1. active records.

2. the record belongs to users territory.

first point is doable, but how to check for the other point as a filter in the advanced find.

*This post is locked for comments

  • Suggested answer
    StefanS365 Profile Picture
    StefanS365 3,573 Most Valuable Professional on at
    RE: Dynamics 365 View creation based on condition.

    Hi there,

    Better late than never ;-)

    Here's your dynamic view to show (in this case) Opportunities) that belong to the user's territory.

    MyTerritory.png

  • Suggested answer
    Goutham A Profile Picture
    Goutham A on at
    RE: Dynamics 365 View creation based on condition.

    yes, you can acheive it using 2 views. I had a similar requirement

    If i understand your requirement correctly, you need to get all opportunities assigned to users who are in the same territory as Current User.Let me know if wrong

    First create a view under territories to get and save the current users's territories as shown below. lets say we save the view as "Current User Territories"

    aa234.jpg

    Then go to opportunities, and query using the  as below. this would give you desired results.

    aa234.jpg

    <<Please mark my answer as verified if it resolved your query>>

  • EmployeeOcta Profile Picture
    EmployeeOcta 2 on at
    RE: Dynamics 365 View creation based on condition.

    Hello saad,

    In my case I have two custom entity and one user entity.

    Say in place of opportunity c1 entity.

    In place of territory c2 entity and the same above work I need to do.

    Will it be feasible.

  • RE: Dynamics 365 View creation based on condition.

    Hi,

    Have you tried above approach. it will fetch you the all the opportunities of current user's territory .

  • EmployeeOcta Profile Picture
    EmployeeOcta 2 on at
    RE: Dynamics 365 View creation based on condition.

    Hello Saad,

    I want to fetch record based on loggin user's territory is equal to the entity record territory.

    i believe i am able to put my question correctly.

  • RE: Dynamics 365 View creation based on condition.

    Hi,

    Please try this:

    5050.1.PNG

  • EmployeeOcta Profile Picture
    EmployeeOcta 2 on at
    RE: Dynamics 365 View creation based on condition.

    Hello Rawish,

    Is it possible to set territory dynamically, that means, in the above case i want to fetch Opportunities records based on logged in user's territory.

  • Suggested answer
    Rawish Kumar Profile Picture
    Rawish Kumar 13,756 on at
    RE: Dynamics 365 View creation based on condition.

    Hi,

    you could look or created by ( user from the dropdown by going related fields) and from there select the user territory?

    just an example below:

    teritory.JPG

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans