Answered

Gallery filter on manager

(0) Share

Report

Posted on by Abhilash M abi

106

i'm trying to filter gallery.... when the manager logged in, the gallery should list user details only those users who are direct reportie of logged in manager.. anybody has idea?please share..

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Follow this post
https://powerusers.microsoft.com/t5/Building-Power-Apps/Getting-records-created-by-a-Direct-Report/m-p/542656#M166819
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Abhilash M abi 106 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm not storing Manager details.. It directly coming from Azure...
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Abhilash ,

Do you want to only list items that manager is current user?

Do you mean that the manager information is set in azure ad profile?

Could you tell me

1)the gallery's Items?

2)what is your data source?

I need to know which column in your table is stored manager email.

I assume that your data source is sharepoint list, you have a person column with user's data.

I've made a similar test for your reference:

1)you could get user's email from this:

personfield.Email

2)you could get user's manager's Email by using office365 users connector

Then use Manager_V2 function to get user's manager's Email.

Try to set your gallery's Items:

Filter(listname,Office365Users.ManagerV2(personfield.Email).mail=User().Email)

//please replace with your listname and personfieldname.

Best regards,
Abhilash M abi 106 on at

Like
a
(0)

Report
Copy link

Link copied!

yes, data source is sharepoint only and i just achieved that by saving manager's id in sharepoint... Thanks for your info..