Answered

Trying to filter office365 from specific country

(0) Share

Report

Posted on by Evo

Hi,

I'm trying to set up a filter/search for Office365 users from a specific country or company and display those in a gallery. Is this possible?

In this code I'm filtering on country/company/name depending on what radiobutton the user selected (and only if the company name is specified). The first filter works, the country or company filter I can't get to work.

If(Radio1.Selected.Value="Name"; Filter(Office365Users.SearchUser({searchTerm:SearchBar.Text}); Not(IsBlank(CompanyName)));
If(Radio1.Selected.Value="Country"; Filter(NO IDEA HERE({searchTerm:SearchBar.Text}); Not(IsBlank(CompanyName)));
If(Radio1.Selected.Value="Company"; Filter(NO IDEA HERE({searchTerm:SearchBar.Text}); Not(IsBlank(CompanyName))))))

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Evo 11 on at

Like (0)

Report
Copy link

Link copied!
I'm a bit further now, didn't realise it would be this easy:

If(Radio1.Selected.Value="Company"; Filter(Office365Users.SearchUser({searchTerm:""}); CompanyName=SearchBar.Text)))
But now I only get results when my searchbar contains the exact CompanyName. Can I easily change that so it searches within CompanyName?

Was this reply helpful? Yes No
Verified answer

Evo 11 on at

Like (0)

Report
Copy link

Link copied!
Solved, with this code:

If(Radio1.Selected.Value="Company"; Filter(Office365Users.SearchUser({searchTerm:""}); SearchBar.Text in CompanyName)))
Hadn't used the "in" operator yet.

Was this reply helpful? Yes No