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.
Many thanks!
ClearCollect(Employees, Office365Users.DirectReportsV2(User().Email).value);
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
Could you please instruct me use which action for each step? a picture is a good idea in this case.
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