Announcements
Hey guys I am trying to get the top 10 items on my dropdown and at the same time user will be allowed to search.
Filter(Office365Users.SearchUser({searchTerm: Input.SearchText,top:10}), ("au.com" in Mail))
Hi @nagestiada ,
For this scenario, filter with "au.com" in Mail will not work.
Instead, you can use EndWith function, so try this formula:
Filter(Office365Users.SearchUser({searchTerm: Input.SearchText,top:10}), EndsWith(Mail, "au.com"))
Best regards,
Allen
Its working but when I click the dropdown it doesn't show any, only the search function works. and yes it does filter only string ends with au.com
This formula should meet your requirement:
If(IsBlank(Input.SearchText),Office365Users.SearchUser(), Filter(Office365Users.SearchUser({searchTerm: Input.SearchText,top:10}), EndsWith(Mail, "au.com")) )
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 405 Super User 2026 Season 2
Mohsin Ali 368
WarrenBelz 244 Most Valuable Professional
