web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Email Combobox search
Power Apps
Answered

Email Combobox search

(0) ShareShare
ReportReport
Posted on by 140

I currently have the following:

JamtMaster_0-1680704751167.png

Filter(
 AddColumns(
 UsuariosdeOffice365.SearchUser({searchTerm: txtBuscadorPersonas_1.Text}),
 "EmpresaActual", UsuariosdeOffice365.MyProfile().CompanyName,
 "PaisActual", UsuariosdeOffice365.MyProfile().Country
 ),
 CompanyName = EmpresaActual || CompanyName = "One 365 12" && Country = PaisActual || Country = "Dominican Republic"
)

In the txt I write the name of the person and then select it in the combobox, I would like to be able to search directly from the combobox. Try doing this:

 

Filter(
 AddColumns(
 UsuariosdeOffice365.SearchUser({searchTerm: ComboBox2_1.SearchText}),
 "EmpresaActual", UsuariosdeOffice365.MyProfile().CompanyName,
 "PaisActual", UsuariosdeOffice365.MyProfile().Country
 ),
 CompanyName = EmpresaActual || CompanyName = "One 365 12" && Country = PaisActual || Country = "Dominican Republic"
)


However, when doing so, nothing happens, how could I achieve what I need?

Categories:
  • v-zhoqian-msft Profile Picture
    Microsoft Employee on at

    Hi @JamtMaster ,

     

    Do you want to search directly in the combo box? It looks like there is nothing wrong with your code. Have you turned on the "Allow searching" property of combo box?

     

    vzhoqianmsft_0-1680768768168.png

     

     

    Best Regards,

    Community Support Team _ habsburg Qian

    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • JamtMaster Profile Picture
    140 on at

    @v-zhoqian-msftYes allow it´s ok.

     

    If i put this code:

    UsuariosdeOffice365.SearchUser({searchTerm: ComboBox2_1.SearchText})

    JamtMaster_0-1680790432475.png

     

     The search work but in this way I have 2 problems that I want to avoid, 1) in my company we are too many and the CompanyName filter is practically mandatory for it to be functional and 2) in this way all the people are not pulling me, in that capture where I am filtering with the word ju I am missing several people

  • v-zhoqian-msft Profile Picture
    Microsoft Employee on at

    Hi, @JamtMaster ,

     

    I'm not very sure where the code went wrong. But in test, I noticed that if I add () to the condition, the results may be different. You could check if this is the reason?

     

    Filter(
    AddColumns(
    UsuariosdeOffice365.SearchUser({searchTerm: ComboBox2_1.SearchText}),
    "EmpresaActual", UsuariosdeOffice365.MyProfile().CompanyName,
    "PaisActual", UsuariosdeOffice365.MyProfile().Country
    ),
    (CompanyName = EmpresaActual || CompanyName = "One 365 12") && (Country = PaisActual || Country = "Dominican Republic")
    )

     

    Best Regards,

    Community Support Team _ habsburg Qian

    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • JamtMaster Profile Picture
    140 on at

    @v-zhoqian-msftthanks for the help but now i found the error. The seach field of combobox just has City, just need to change it for ["DisplayName","Mail"] and the combobox work but have one doubt it's taking too long to display the results, is it due to the way I set up my code? Or do I have to activate something in particular to optimize this part?

  • Verified answer
    v-zhoqian-msft Profile Picture
    Microsoft Employee on at

    Hi @JamtMaster ,

     

    There could be various reasons why the combo box takes a long time to display. You could try to create a new collection to store the data of the data source at the OnStart of the app, and then use this collection in the formula.

     

     

    Best Regards,

    Community Support Team _ habsburg Qian

    If this post helps, then please consider Accept it as the solution to help the other members find it.

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 248 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 192 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 135

Last 30 days Overall leaderboard