Is it possible to create a collection having Job Titles per Department from Office365Users?
Thanks a lot!
Solved! Go to Solution.
@cgarib
Here is some code you can plug into your Power Apps to create a unique list of departments and titles.
ClearCollect(
colDeptTitles,
SortByColumns(
ForAll(
Distinct(
ShowColumns(
Office365Users.SearchUserV2({top: 999}).value,
"Department",
"JobTitle"
),
ThisRecord
),
ThisRecord.Result
),
"Department",
Ascending,
"JobTitle",
Ascending
)
)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
@cgarib
Here is some code you can plug into your Power Apps to create a unique list of departments and titles.
ClearCollect(
colDeptTitles,
SortByColumns(
ForAll(
Distinct(
ShowColumns(
Office365Users.SearchUserV2({top: 999}).value,
"Department",
"JobTitle"
),
ThisRecord
),
ThisRecord.Result
),
"Department",
Ascending,
"JobTitle",
Ascending
)
)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Works really fine!... tnaks a lot!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
183 | |
71 | |
43 | |
34 |
User | Count |
---|---|
338 | |
267 | |
117 | |
67 | |
66 |