Unanswered

Combobox - show direct reports for current user

(0) Share

Report

Posted on by 12strikes

I have a gallery that has records entered by the current user and their direct reports.

I want to create a combo box that has the current users' name, and the names of their direct report. I'm then going to use the combo box to farther filter the gallery.

So...I can't figure out how to populate a combo box with the user name and the names of all their direct reports....

help Please.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-albai-msft on at

Like (1)

Report
Hi @12strikes,
To populate a combo box with the current user name and the names of all their direct reports, you can create a collection using below formula(you can use below formula on OnSelect property of a button or on OnStart property of App):

ClearCollect( myTeam, {DisplayName: User().FullName}, Filter( Office365Users.DirectReports(User().Email), AccountEnabled = true ) )

Here is the collection:

Then on your combo box, set its Items property to:

myTeam.DisplayName

Best regards,
Allen

Was this reply helpful? Yes No
12strikes 83 on at

Like (0)

Report

Thank you VERY MUCH!.... Worked exactly as I needed

Was this reply helpful? Yes No
v-albai-msft on at

Like (0)

Report

Hi @12strikes ,
If my solution is helpful to you, please mark my answer as a solution. This will benefit other community members who stuck with the same question.
Thanks for your understanding.
Best regards,
Allen

Was this reply helpful? Yes No