web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Office365 users...

Power Apps

Unanswered

Filter Office365 users not returning all users

(0) Share

Report

Report

Posted on by soc-sp

16

I'm using the following to get all the users with a certain company name:

Filter(Office365Users.SearchUserV2({searchTerm:DataCardValue40.SearchText, isSearchTermRequired:"No", top:999}).value, CompanyName = "CRE")

This is only returning 26 users when there should be close to 300.

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

RogierE 879 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

How many are there without the filter?
soc-sp 16 on at

Like
a
(0)

Report
Copy link

Link copied!
Supposedly just 8, but definitely doesn't seem right. When I do the following, then it returns 30, but I'm able to search for people not immediately in the drop down.
CountRows(Choices('IT Request Form'.'Contractor Name'))
RogierE 879 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I'm puzzled. You get 26 users when you filter your office365 users and 8 when you don't? A filter can never increase the number of outcomes 🙂
So the unfiltered number of choices in 'Contractor Name' is 30. Is this a person type column in a SharePoint list?
How many choices do you have when you add a record directly in SharePoint?
soc-sp 16 on at

Like
a
(1)

Report
Copy link

Link copied!

I gave up and decided to create an office365 group instead.

Join the conversation