I am looking to see if there is a way to filter out users that I do not want loaded in to my connector before doing the top:999. This is the code I have for my Gallery Item: FX code:
Sort(
Filter(
Filter(Office365Users.SearchUser({top: 999}),
AccountEnabled = true),
(StartsWith(DisplayName, 'Search Bar'.Text) || StartsWith(JobTitle, 'Search Bar'.Text))
&&
CountRows(Split(DisplayName, " ")) >= 1
&&
!IsBlank(JobTitle)
),
DisplayName
)
It is loading in the 999 and then filtering out from that, so my results are only going to the middle of the alphabet (displaying maybe 300 users). Is there a way to do all of my filtering first and then load the 999 so that I can see all of my users?


Report
All responses (
Answers (