oofice365user. search user

(0) Share

Report

Posted on by Eben98

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.

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Eben98 123 on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Eben98 123 on at

Like (0)

Report
Copy link

Link copied!

Thank you! You are a lifesaver.

Was this reply helpful? Yes No