Creating collection of users from Office 365

Like (0) Share

Report

Posted on 1 Aug 2022 16:54:06 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:

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (4)

Answers (1)

_sigmaNot_ 49 on 05 Apr 2023 at 19:21:41

Like (0)

Report

Re: Creating collection of users from Office 365

@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
shoog 2,164 on 05 Apr 2023 at 14:25:32

Like (0)

Report
Re: Creating collection of users from Office 365

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 04 Apr 2023 at 16:13:56

Like (0)

Report
Re: Creating collection of users from Office 365

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
Verified answer

shoog 2,164 on 01 Aug 2022 at 18:48:24

Like (0)

Report

Re: Creating collection of users from Office 365

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