Getting the list of all available departments in Office 365

(0) Share

Report

Posted on by Adrian_Celis

1,652 Moderator

Hi All,

I am using this formula to get the list of departments in the active directory. This works for tenants with few users, but the problem is that we have more than 10k users and the Office365Users function can only retrieve up to 999 users, I believe. Is there a workaround for this?

Distinct(
 Filter(
 Office365Users.SearchUser(),
 Len(Department) > 0
 ),
 Department
)

@WarrenBelz this is a follow up to the previous post that I asked.

Thanks

Adrian

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

@Adrian_Celis ,

No - Distinct() is not Delegable

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Adrian_Celis. I've hit the exact same problem, where the non-delegable nature of Distinct() is preventing me from producing a complete department list. Do you mind me asking if you found a way around it in the end, please?

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like (0)

Report

Hi @Anonymous
Sorry. Haven't found a way using this method.

Ended up using another data source for our active directory.

Was this reply helpful? Yes No