314
I am interested in utilizing a textbox to search for an O365User and display only those users who have an email address. I encountered an issue where some users were displayed without an email address, which I want to avoid. How can I filter out users without an email address from being shown in the list?
If you want this in the combobox then:
Share
Report
All responses (
Answers (
Distinct(
Filter(
Office365Users.SearchUser({searchTerm: TextInput.Text, top: 999}),
Mail <> Blank()
),DisplayName
)If in the gallery then:
Distinct(
Filter(
Office365Users.SearchUser({top: 999}),
Mail <> Blank()
),DisplayName
)
_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!
