Answered

Export Form Filter

(0) Share

Report

Posted on by bachthang309

I plan to create a MS form to collect staff's information in some departments. How can I export an Excel file of employees below me? I mean, I am a manager and want to filter a list of employees in my department, not other departments. Will PowerApp allow me to do that? My company used office 365 and added all staff position.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

he @bachthang309

if you use the office365users connector in powerapps there is a Office365Users.DirectReportsV2 function.

So yes, technically there is a way to do this

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
bachthang309 on at

Like (0)

Report
Copy link

Link copied!

Could you please instruct me use which action for each step? a picture is a good idea in this case.

Was this reply helpful? Yes No
Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
go to the datasource tab on the left hand side of your power aps studio

search for office365users connector and connect it

Put this code in your onvisible of first screen of your app

ClearCollect(Employees, Office365Users.DirectReportsV2(User().Email).value);

Insert a gallery and set the item property to Employees (which is your collection)

It should show you all direct reports in that gallery

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
bachthang309 on at

Like (1)

Report
Copy link

Link copied!

Many thanks!

Was this reply helpful? Yes No