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 / oofice365user. search ...
Power Apps
Answered

oofice365user. search user

(0) ShareShare
ReportReport
Posted on by 123

Hi all,

 

Can I get help with this!. I have a hard time figuring this out. 

Office365Users.SearchUser({searchTerm:"",top:500}).DisplayName.

For example under office365users. mail. There are some mails in office365users. 

This is a list of mails under office365users. 

1.eben@gmail.com

2. eben@app.com

3.eben@yahho.com

4.susan@gmail.com

5. rinu@gmail.com

6.susan@yahoo.com

 

Normally from this above mail can I get all the mails that has @gmail.com

I want to use the Mail in the searchterm of Office365Users.SearchUser({searchTerm:"",top:500}).

 

is it possible to do that ?

Thanks in Advance.

Categories:
I have the same question (0)
  • eka24 Profile Picture
    20,923 on at

    Change it to:

    Office365Users.SearchUser({searchTerm:"",top:500}).Mail
    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
  • Eben98 Profile Picture
    123 on at

    I want to get only some particular mails from the office365users.
    For example,

    This is a list of mails under office365users. 

    1.eben@gmail.com

    2. eben@app.com

    3.eben@yahho.com

    4.susan@gmail.com

    5. rinu@gmail.com

    6.susan@yahoo.com.

     

    From all these mails I want to get only the mails with @gmail.com.

     

    So I want to write in this : Office365Users.SearchUser({searchTerm:"",top:500}).DisplayName.

     

    In the searchterm and only get those mails. Is it possible ?

  • Verified answer
    eka24 Profile Picture
    20,923 on at

    Follow thses steps:

    1. OnStart of the App create a Collection:

    ClearCollect(MyUsers77,AddColumns(Office365Users.SearchUser({searchTerm:""}),
    "Mail2",Right(Mail,Len(Mail)-Find("@",Mail))))
     
    2. Insert a Combobox and on the Items:
    Filter(MyUsers77,Mail2="gmail.com")
    Change the DisplayFields to ["DisplayName"]
     
    You can also use the Collection on a Gallery
    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
  • Eben98 Profile Picture
    123 on at

    Thank you! You are a lifesaver.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard