web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to create a collec...

Power Apps

Answered

How to create a collection to retrieve all the departments from the office365user connector in a comobox?

(0) Share

Report

Report

Posted on by CU16021406-1

1,042

Hi,

How to create a collection to retrieve all the departments from the office365user connector in a comobox?

and using Distinct to get only the unique values and sort them using the Sort command.

Gr.P

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (11)

Answers Img

Answers (1)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
hey @PeKi72

you can try this:

// Replace 'YourCollectionName' with the name you want to give to your collection ClearCollect(YourCollectionName, Office365Users.SearchUser({searchTerm: "", top: 999}).department); ClearCollect(SortedUniqueDepartments, Sort(Distinct(YourCollectionName, Value), Result, Ascending));

Set its Items property to the collection that holds the sorted and unique departments, which is SortedUniqueDepartments in this example:

SortedUniqueDepartments

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

Was this reply helpful? Yes No
CU16021406-1 1,042 on at

Like (0)

Report

Where should i put the ClearCollect sentences?

Was this reply helpful? Yes No
CU16021406-1 1,042 on at

Like (0)

Report

I would like to leave the name YourCollectionName as it is. But i get an error !

Gr. P

Was this reply helpful? Yes No
Yogesh Murugan 443 Moderator on at

Like (0)

Report
Try this code

ClearCollect( YourCollectionName, Office365Users.SearchUser({searchTerm:"",top:999})); ClearCollect( DepartmentCollection, YourCollectionName.Department ); ClearCollect( SortedUniqueDepartments,Sort(Distinct(DepartmentCollection,Department),Value))

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

what does the error say?

Was this reply helpful? Yes No
CU16021406-1 1,042 on at

Like (0)

Report

The problem is i do not know how to create a collection or am i even aloud to create a collection. Even as simple as this below i get an error:

P

Was this reply helpful? Yes No
CU16021406-1 1,042 on at

Like (0)

Report

Frustrating 😫

Was this reply helpful? Yes No
CU16021406-1 1,042 on at

Like (0)

Report

Found the error: the comma should be ;

Was this reply helpful? Yes No
CU16021406-1 1,042 on at

Like (0)

Report

Now the only thing i need is to get the Department values of the Office365users connector into that Collection.
Which i have declared in the OnStart event of the app

Collect(
BookCollection;
{
BookName: "The Testaments";
Author: "Margaret Atwood"
}
)

Was this reply helpful? Yes No
Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

put the curser on the red underlined collection name and show me what the error says

Was this reply helpful? Yes No

Join the conversation