Answered

Office365Users.SearchUserV2 return the full results

(0) Share

Report

Posted on by Mattpst

201

Hi,

I am trying to return a list of AD Domain synchronised users, using the Office365Users.SearchUserV2 function and are experience some unintended results. I am trying to return a subset of users based on the following criteria:

Account is enabled
The account is not a guest account
The company name is "Acme" (substituted for post).

This is the code I am using:

ClearCollect(
    colAllUsers,
    Filter(Office365Users.SearchUserV2({isSearchTermRequired:false}).value, CompanyName="Acme" && AccountEnabled = true && !("#EXT#" in UserPrincipalName))
);

There should be circa 80 users returned, but I only get back 61. Examining the collection it shows the expected results in alphabetical order - but only up to the letter M.

If I try and widen the search by only including the company name in the search terms, I expect to get back circa 250 users, but only get back 119 - only up to a few entries that start with the letter N.

I have checked some synchronised users outside the returned results and can't see a reason why they would be excluded.

Has anyone seen this behaviour before?

Thanks in advance,

Matt

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Mattpst

How many users do you have ? The best you can do is search the top 999 like this
ClearCollect( colAllUsers, Filter( Office365Users.SearchUserV2({isSearchTermRequired: false, top: 999}).value, CompanyName = "Acme" && AccountEnabled && !("#EXT#" in UserPrincipalName) ) );

However this may also work for you if your data set is bigger
ClearCollect( colAllUsers, Filter( Office365Users.SearchUserV2({SearchTerm: "Acme", top: 999}).value, AccountEnabled && !("#EXT#" in UserPrincipalName) ) );

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No
Mattpst 201 on at

Like (0)

Report
Copy link

Link copied!

Thanks for suggestion @WarrenBelz, I have circa 330 users, so not hitting the 1000 limit. The second suggest unfortunately returns zero results.

Kind regards,
Matt

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Mattpst

Yes - forget the second one - brain not engaged when putting fingers in gear - it will only look at your Search Field.

Strange though as I ran the first one here and received back the expected result. It is also logical (I cannot think of any other criteria) that if the total (before filtering) Entra User List is under 999, you should get back all results.
One question I have is are you sure that the CompanyName has been entered on the Entra profile of all relevant users.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No
Verified answer

Mattpst 201 on at

Like (0)

Report
Copy link

Link copied!
I managed to resolve it using the following:

Clear(colAllUsers); ForAll( Sequence(2), With(Office365Users.SearchUserV2({isSearchTermRequired: false,skipToken: Last(colAllUsers).SKIP_TOKEN}) As _user, With({_skipToken: Mid(_user.'@odata.nextLink', Find("skipToken", _user.'@odata.nextLink') + 10)}, Collect(colAllUsers, AddColumns(_user.value, SKIP_TOKEN, _skipToken)); ) ) );

This returned all my users and I was then able to filter the collection using:

ClearCollect(colAcmeUsers, Filter(colAllUsers, CompanyName="Acme" && AccountEnabled=true && !("#EXT#" in UserPrincipalName)));

Was this reply helpful? Yes No
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Mattpst,

Sounds to me that you have more than 999 users in the full Entra list (which was what I suspected from the start) - you would not need all of that if the total was under 999.

1 people found this reply helpful.

Was this reply helpful? Yes No