Office365Users.SearchUser filter results

[TommyHotvedt]

Hello,

I've been tinkering with my own version of the "Org Browser" from scratch and its starting to look like something usable.

But how do I remove all the unwanted results from our Azure AD? I seem to be getting shared mailboxes, contacts and some admin users in my result. Is there a way to only show a specific set of company names or to display only the ones that have a company name set? 

I use a search field and populate a gallery with the "Office365Users.SearchUser" function.

Thanks in advance.

[dinusc · Accepted solution]

That should be possible. For example, remove all the items with empth (blank) company names:

ComboBox1.Ittems=Filter(Office365Users.SearchUser({searchTerm:""}), IsBlank(CompanyName)=false)

Similarly you can match the company by a predefined or configured value (from a TextInput control for example)

[TommyHotvedt]

That worked like a charm. I've been trying to wrap my head around the filter function for a while now