cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
slan2018
Level: Powered On

How do I use Office365Users as a search feature in a form?

I've created a simple form which is created from a sharepoint list. On one of my fields, i would like the user to be able to search for a O365 user and select the name. I've looked everywhere on these boards and haven't been able to figure out how to make this happen (if it's possible). Can someone offer some feedback as to what I should do? 

image.png

 

I am very new at this and would appreciate any help I can get!

1 ACCEPTED SOLUTION

Accepted Solutions
v-siky-msft
Level 8

Re: How do I use Office365Users as a search feature in a form?

Hi @slan2018 ,

 

I have a solution to solve your problem.
You can refer to following step:
1. Unlock the Sales Rep Name_ Data card1
2. Delete the Text input control of that data card, and add a Combo box
3. Set Item property of combo box as below

Office365Users.SearchUser()

4. Set Update property of combo box as below

ComboBox.Selected.DisplayName

5. Set Y property of ErrorMessage as below

ComboBox.Y + ComboBox.Height

So that you can search office365 users in the form, and submit your form.

 

 

Best regards,
Sik

 

8 REPLIES 8
ck25415
Level 8

Re: How do I use Office365Users as a search feature in a form?

@slan2018 Since you are using a SharePoint list as a datasource for this form, create a people picker field "Sales Rep Name" in the SharePoint list and use it in the form.

v-siky-msft
Level 8

Re: How do I use Office365Users as a search feature in a form?

Hi @slan2018 ,

 

I have a solution to solve your problem.
You can refer to following step:
1. Unlock the Sales Rep Name_ Data card1
2. Delete the Text input control of that data card, and add a Combo box
3. Set Item property of combo box as below

Office365Users.SearchUser()

4. Set Update property of combo box as below

ComboBox.Selected.DisplayName

5. Set Y property of ErrorMessage as below

ComboBox.Y + ComboBox.Height

So that you can search office365 users in the form, and submit your form.

 

 

Best regards,
Sik

 

slan2018
Level: Powered On

Re: How do I use Office365Users as a search feature in a form?

Thank you @v-siky-msft ! I think I may have pressed Solution a moment too soon. I followed your instructions, but when I play the app I am unable to search/Type/do anything except see a blue bar. 

 

image.png

 

Did I miss a property? Maybe an OnSelect? The Data search and display items seem wrong but I dont know enough about it. 

image.pngimage.png

image.png

slan2018
Level: Powered On

Re: How do I use Office365Users as a search feature in a form?

@ck25415 can you give me more information on that? I went to my sharepoint list and added a "People or Groups" column called RepLookup. Is that what I'm supposed to do? I kept the "Choose from" on All Users. I want it to show at minimum a name when you search, but other info would be nice. 

image.png

 

I've never done this before, any help would be greatly appreciated!

ck25415
Level 8

Re: How do I use Office365Users as a search feature in a form?

@slan2018 That looks goo to me, were you able to add the "RepLookup" field into the form in PowerApps ?

v-siky-msft
Level 8

Re: How do I use Office365Users as a search feature in a form?

Hi, @slan2018 

 

The item property of combo box needs some parameters, please set as 

Office365Users.SearchUser({searchTermSmiley Sad""),top:<TopRecordNumber>})

 TopRecordNumber is the number of record you want to search.

 

And you also need to change the Display Fields and Search Fields as ["DisplayName"].

 

Best regards,

Sik

slan2018
Level: Powered On

Re: How do I use Office365Users as a search feature in a form?

@v-siky-msft Trying to enter but on my screen your formula is showing a frown face haha. Not sure what goes in place of the frown?

image.png

image.png

 

Do you have any advice as to the top # section? We have a whole lot of users on our domain so i want to search them all, would this be for the # of matches returned? 

v-siky-msft
Level 8

Re: How do I use Office365Users as a search feature in a form?

Hi @slan2018 ,

 

Oh a frown face haha Smiley Sad

The formula is: Office365Users.SearchUser({searchTerm: (""),top:TopRecordNumber})

The maximum value of user records retrieved from Office365Users.SearchUser() function at once is 999.

 

you can use collection to work around this limit.

For more information, please refer to this thread: 

https://powerusers.microsoft.com/t5/General-Discussion/Office365Users-Connector-Company-Directory/m-...

 

Best regards,

Sik

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 191 members 5,573 guests
Please welcome our newest community members: