PowerApps Office 365 User Search

In this video, you will learn how to Office 365 Search Users with PowerApps. We start with the basics but then we look at some new concepts to handle scenarios where you have 1000 users or more. As a bonus we also use the Concat function to send a bunch of people an email. Lots of fun.

[jomarismeneses]

Nice video! I have a query, if I have a combobox where l search in Office users for the name and I have other textinputs that depending on the user I choose, automatically fill these fields such as position, department, etc. However, I have a problem, it only returns the data of the first 100 users even if I use the top function since I handle about 650 users. How could you make it show the information of all users and not just the top 100? Thanks!

[AdiCristea]

And here we go again. Before the video "what can I learn new?" Shane: "Select(icon2)"; Booom, mind-blowing!

Thank you, sir!

[honganhuynh]

Hey Shane, everytime I'm pressing the reset button it creates a new collection item that is blank. How do i stop this?

[MickaelGoulle]

Hi Shane, Thank you for your videos, it helps me A LOT! However, I have a little problem with the cbx + automatic reset. My collection saves the name I select but after the reset, an empty record is added to my collection as well.

[hokemspitter]

Hi, great video (as usual). I have a question, when I search and then in the combobox dropdown, I select a user, it shows up, but i also have a blank "user" added to the gallery after that. Can you suggest why that is and how to fix that? Thanks.

[gerardosalazar]

Thanks to you I learned PowerApps and I’m still learning, you are the best mentor ever!

[k_peter_]

Hi
Why doesn't working for me this: OnSelect -> FX -> ?
I everything got an error message when I write this: in the FX. I tried separate with ", " intead of ";" but that doesn't work either.

[TajimaPendragon]

Is there anyway to do this where when a user types in their name the Outlook profile card pops up to select? much like if you were to do a List "type Person or group" in sharepoint?

[blutkraehe_official]

Hi, i has a error: 6:22 Unexpected signs. The formula contains "Paren Close", but it is expected "Eof".

[MustafaFarooq]

Hi Shane, another great video, so i implemented this workaround, but the issue im facing is when i tried to implement this is by placing the reset function for the combo box in its onchange property just as you have, is resulting in a blank record being added along with the selection made from the combo box. Not only is this blank record unwanted, i am using a gallery to display the collection and am using the office 365 connector to show the users picture using the email column in the collection and because of the blank record my app gets a runtime error as well because it cant look up the user since it gets nothing from the email column for that record, and the user is not happy about having to delete the blank record and see an error as well. Can you suggest how this can be corrected ?

[JenniferLaveryFBE]

I've literally started learning PowerApps on Friday, and I've used a few of your videos to get myself a fairly functional Directory for my organisation (got myself a gallery and using the Office 365 connector). You're a great teacher! Problem is that I'm in an education institution, and it's bringing up all the students as well. I only want staff, which can relate to an Office 365 Group or try and filter only those who have a Department. I can't figure it out, and I've been through sooo many videos and articles. Can it be done, or am I wasting my time on the wrong function?

[payalgupta]

i tried Below formula in combolist Distinct( Filter(ApprovalMatrix, Model.Value=lblModelName.Text), Approver.DisplayName).Result but no data is populated in combobox, could you please elp on this

[flymanish]

Thanks a lot Shane, is this 999 limit is is only with O365 user lookup or it will apply with in general with combo box ? Even we use any lookup from SQL that limit to 999 ?

[raghadm]

Thanks a lot ! :)
If I want the combobox to filter the office365 users based on if there is a record for that user in a sharepoint list?
PS. I have a column in the sharepoint list of type person.

[jjayceeb]

Good day Mr. Shane..i have a problem in my app. Im using O365 i shared it with my colleague without Outlook.they are part of azure AD i can use my app however my colleague has an error shows need licence. I thought O365 and azure is the same. Please advise. 🙏🙏🙏

[aravindadamarla]

@shane, How can i search users and groups from my organization. In my 'To:\' combo box, i need to search and include both users and groups in the same combo box just like outlook. How can i achieve that ?

[andrasradocz]

Hi Shane, great content as always! Probably you also figured it out by now, but I believe even the textbox is redundant for limiting the search, when "self-search" is configured. This code goes into the combo box Items property:



It bypasses the >1000 user limit in one go.

[DavidPrenticeJr]

Similar to the "To" field in Outlook when trying to type in an email or distribution group, how do you show both users, and groups in the search?

[Planeflake]

Hi Shane, I have been trying this but I cannot get the photos to appear. It seems to be blocked somewhere. My photo also does not appear in the corner when using power apps or in outlook. Any ideas?

[TheShnitbear]

Can you sort the names asc? There doesn't seem to be a rhyme or reason how it is sorted by default