Type Department in Text input.
Gallery show the user which belong this Department.
--------------------Items in Gallery--------------------
Sort(
Filter(
Office365User.SearchUserV2(
{
searchTerm: SearchBox.Text.
top:20
}
).value,
!IsBlank(CompanyName)
),
MailNickname,
Ascending
)
--------------------Try another formula SearchUserV2 but no results--------------------
Filter(
Office365Users.SearchUser(
{searchTerm:SearchBox.Text}
),SearchBox.Text in Department
)
------------------------------------------------------------
As I known, Office365User is unavailable to search Department field.
So I'm wondering Is there any way to use standard connector and delegable function to build feature above?
Any help will be appreciated! Thank you!
