Hello,
I am trying to build a very simple contact list for our branch with a search field and a gallery.
There are thousands of employees all over the world which I don't want to show at all.
For the gallery Items I used this syntax:
If(EmployeeTxt.Text=""; Office365Users.SearchUser({top:999});
Filter(Office365Users.SearchUser({searchTerm:EmployeeTxt.Text; top:200}); AccountEnabled=true; CompanyName="POCR"))
- If the search field (ExmployeeTxt.Text) = "" (default value), I would like to show every active O365 user with CompName="POCR"
- If I start inputting characters the results appear very random (but correct) - One letter will result in one-two search results, two letters sometimes show up to 10 results etc.
Is there a way to limit the O365 connector to just CompanyName="POCR" somewhere on the input so it doesn't have to filter in thousands and thousands of lines? Or is there a way around it?
Thanks for your input.

Report
All responses (
Answers (