Answered

Creating collection of users from Office 365

(0) Share

Report

Posted on by mqcp

109

I'm trying to form a collection of users from the "Office 365 Users" connector dependent on their email address. The issue I'm running into is I'm not sure what the second input of my Collect() function should be. I want to be able to add the "whole user" to my collection and not just their display name, email, etc. For example the, the following code produces a collection of just the users display names.

ForAll(
 Office365Users.SearchUser(),
 If(
 Last(Split(Mail, "@")).Result = "companyEmail.com",
 Collect(users_collection, DisplayName)
 )
)

The problem arises when I want to populate a gallery pulled from this collection and display more than just their name in each cell, such as an email or location. So is there any way to make a collection of the user objects themselves?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

shoog 2,164 on at

Like (0)

Report

To answer your question: replacing DisplayName with ThisRecord will do the trick.

However, I would recommend passing {searchterm: <at> companyname.com} to the searchuser function to prevent having to use ForAll, which is known to be slow with large datasets. You can then just collect the entire output of that function.

Was this reply helpful? Yes No
_sigmaNot_ 49 on at

Like (0)

Report
Hi @shoog ,

I'm not able to get this to work. Does searchterm look in any part of the value or only the beginning?
Is it possible to add wild cards into the actual searchterm?
Example:
Office365Users.SearchUser({searchTerm: "*@mydomain.com"})
Sorry if this has been answered somewhere else before. I haven't had luck finding any detailed documentation for the Office365Users connector and it's methods 🙁

Was this reply helpful? Yes No
shoog 2,164 on at

Like (0)

Report
It only looks at the beginning, so you would have to use a Filter expression around SearchUser, like this:

Filter(Office365Users.SearchUserV2({isSearchTermRequired: false}).value, "@mydomain.com" in Mail))

Was this reply helpful? Yes No
_sigmaNot_ 49 on at

Like (0)

Report

@shoog - Thanks for getting back to me on this.

I had tried this approach before but unfortunately doesn't work in my case as there's probably close to 100K users in the tenant I'm working with.

I ended up using PowerAutomate and Azure AD connector to meet my requirements.

Was this reply helpful? Yes No