Create a collection (Job Titles per Department) from Office365

[cgarib]

Is it possible to create a collection having Job Titles per Department from Office365Users?

Thanks a lot!

[mdevaney · Accepted 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]

Works really fine!... tnaks a lot!