Skip to main content
Community site session details

Community site session details

Session Id : xo9sd6qmdUfCyogZhL80PK
Power Apps - Building Power Apps
Answered

Can't getting full email adresses - ComboBox

Like (0) ShareShare
ReportReport
Posted on 21 Mar 2024 08:41:47 by 482

Hi,

 

I'm using a ComboBox to search for a user's email address. But I can't see all email addresses, only some of them. 

Office365Users.SearchUser({searchTerm:ComboBox1.SearchText,top:250}).Mail

Does anyone have any idea how to get a complete list of email addresses?

Best Regards,

dKayt

Categories:
  • dkayt Profile Picture
    482 on 22 Mar 2024 at 09:36:08
    Re: Can't getting full email adresses - ComboBox

    Hi @SpongYe , 

     

    what you are providing is correct. I think I need to discuss this with our IT department, it could be an internal problem.

    Thanks again.

  • SpongYe Profile Picture
    5,580 Super User 2025 Season 2 on 21 Mar 2024 at 09:56:49
    Re: Can't getting full email adresses - ComboBox

    Hi @dkayt 

     

    Can you check how many you missing? 

    I added a count and a list to check what results I get back and at my side it looks good.

     

    CountRows and show the amount in a Text Label:

    CountRows(Office365Users.SearchUser({searchTerm:ComboboxCanvas2.SearchText}).Mail)

     

    Show the list in a Text Label:

    Concat(Office365Users.SearchUser({searchTerm:ComboboxCanvas2.SearchText}), Mail & ", ")

     

    Then you can debug and find out how many your missing. 

     

    If you have any questions or feedback, please let me know. Have a great day! 😊

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

  • dkayt Profile Picture
    482 on 21 Mar 2024 at 09:37:36
    Re: Can't getting full email adresses - ComboBox

    Hi @SpongYe , 

    Thanks for replying.

    Unfortunately it doesn't work, I still have the same list of email addresses.

  • Verified answer
    SpongYe Profile Picture
    5,580 Super User 2025 Season 2 on 21 Mar 2024 at 09:32:25
    Re: Can't getting full email adresses - ComboBox

    Hi @dkayt 

     

    Try this:

    Office365Users.SearchUser({searchTerm:ComboBox1.SearchText}).Mail

     

    If you have any questions or feedback, please let me know. Have a great day! 😊

    -----------------------
    PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

    I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete