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!
User | Count |
---|---|
247 | |
103 | |
82 | |
49 | |
43 |