
I'm filtering a gallery that is connected to O365. I want to filter by officeLocation and jobTitle. However, when I use the code below I only get 3 results and I know there are many more.
Filter(
Office365Users.SearchUser(
{searchTerm: "", top: 500}),
OfficeLocation="TECH & INN" And StartsWith(JobTitle,"INTERN/COOP")
)
I now realize that I have more records than PA will process. How do I collect all users and then filter the collection? We have more than 12,000 users.