Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

CDS View Filer "Owner is current user or his reporting hierarchy" not working

(0) ShareShare
ReportReport
Posted on by 82

I have custom entity "TS".

Users have manager and position fields are setup.

But the CDS views only returning records matches the current user, but nothing from the people who is reporting to that current user.

The "Owner is current user or his teams or his reporting hierarchy and their teams" only returns the current users record too.

 

note: the current user has a security role that can read all records of this entity in the same Business Unit. And there is only the default BU.

What have I missed? I hope this doesn't requires to switch on the "Hierarchy Security" model in the environment? or?

Many thanks in adv


Xun

  • Verified answer
    shennu Profile Picture
    82 on at
    Re: CDS View Filer "Owner is current user or his reporting hierarchy" not working

    well the Hierarchy Security model wasn't switched on as I stated in my original post...

    Therefor the hierarchy depth is irrelevant...

    Regarding the data, there is only 1 level depth I am expecting to see in the view (I am logged in as a line manager, and I am expecting to see all records own by the users who are reporting directly to me...)

     

    Anyhow I have now tested it by switch on the Hierarchy security model, and guess what. that make the view filter working.

    a bit annoying that this is not stated anywhere on the documentation regarding these view filters...or on the documentation regarding hierarchy security model...

  • Satish1024 Profile Picture
    279 on at
    Re: CDS View Filer "Owner is current user or his reporting hierarchy" not working

    What is the depth of hierarchy ?

  • shennu Profile Picture
    82 on at
    Re: CDS View Filer "Owner is current user or his reporting hierarchy" not working

    Further to the above.

    I have tried to use the related entity in the view filter see attached png.

    This does return all records that owned by the current user as well as the anyone who's manager is the current user.

     

    But still, this is not good enough. more later

  • shennu Profile Picture
    82 on at
    Re: CDS View Filer "Owner is current user or his reporting hierarchy" not working

    Hi @Satish-Reddy ,

    Yes, if you mean the Position field is filled in on users record.

     

    I guess the question is are these view filters relying on anything else to be setup?...

     

    cheers

  • Satish1024 Profile Picture
    279 on at
    Re: CDS View Filer "Owner is current user or his reporting hierarchy" not working

     Have you mapped users to different Positions after you created them?  (Assuming you are using the Position hierarchy)

     

    ...........

    Please mark it as answer if my post helps.

    Thanks
    Satish Reddy
    https://pascalcase.com

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

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

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 19

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 15 Super User 2025 Season 1

Overall leaderboard

Featured topics