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

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

Shane you are genius man, i figure out the things i required after watch this video.👍👍👍👍👍

Regarding the timelines of my comment, see it as an indictment on the value of your channel and older videos. They are invaluable, and I appreciate them.

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?

You're a genius, Shane! Thank you!

Another great video Shane. Many thanks, just what I needed to move on another step.

Nicely done, I needed to use a semicolon in my concat to build the email string. Also, I'm getting a blank record in my gallery on the "onchange" while creating my list

Shane, Thank you. This opened up a lot of new ideas for me.

Thanks for sharing the trick with select function, actually i was trying it with pressed event & it was not working, Good that you included in the trick in hear, Many thanks!

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: Office365Users.SearchUser({searchTerm:Combo1.SearchText}).DisplayName It bypasses the >1000 user limit in one go.

That was very helpful, I wonder why MS doesn't just gives a combobox with the same workaround you created omg

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!

Love this, thank you so much Shane 🥰

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?

Amazing content!!!

The Prodigious Professor of Power Apps delivers again. Great lesson. Oddly enough even after establishing an Outlook Users Connect the combo box does not show a data connection, but indeed is searching the directory. Any recommendations how to implement this idea in a collection "edit form" or import selected value to sharepoint. Would you edit the datacard value to import the values in the combo box and simply hide the field from view?

Well explained useful example as always. I did something similar but used a gallery instead of a combo box to display the employees.

Great video Shane, got me thinking how I could modify your idea to make it fit an upcoming app. Thanks and happy New year!

Watching your vid today. On New Years Eve 2019. :) Thank you for your videos!

I know this is 5 years old. Just finding out about Power Apps. Love the videos. The only wierd thing for me is every time I select someone from the search and the control box resets the collection adds a blank row. I’ve tried everything. Not sure how to fix it beyond not resetting the combo box. Literally. Every time I select a name I get the name and then a null in the gallery. IDK. I am sure no one will even see this.

Happy new year! Awesome Videos!

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.

Happy New Year Shane! Another Great Video. Can you please do a video on datatable & chart please ?

You saved me again witht his old video!

Thank you for sharing the info Many organizations do look for bulk emailing solutions. Happy New Year

One of MANY great videos! This helped me greatly! I'm trying to go one step further in the Collection area. I have a form for requesting Exchange resources. These resources have multiple security groups. Most of them will have the same users in each security group. Others will have some but not all. What I want to do, is have the user have an option to click a button to copy the users from say fullAccessCollection to sendasCollection. Then they will have the option to edit the sendascollection to add or remove more users. I'm trying to make the User Experience as simple as possible to speed up the process of filling out the forms. I can have up to 7 security groups with some having duplicate data. I've scoured the web but haven't found much of anything addressing this possibility. Any suggestions you give would be appreciated!!!

many thanks, Shane I'm your Fan!

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.

Would be cool to be able to search for users with eg. PowerApps in the Skills in profile, and maby show a collection of all skills in the company in the combobox

Great Video! Thank you!

Shane! Very grateful for this video, it is helping me a lot in my learning! So, I found difficulties in the reset part. When I put the iconreset code in the combox, it shows an error, does not accept the code, says that the type of argument is invalid. Here is the code: Collect (collectUsersToEmail; {Name: ComboBox5.Selected.DisplayName; Email: ComboBox5.Selected.Mail}) & Reset (ComboBox5) & Reset (TextInput5) Once again, thankful for your generosity.

@ShanesCows - awesome! Love the part about reverse engineering. Okay the 365 user connector is great but I want to only show a list of users within a specific OU in AD. I also want to be able to select a user account then enable it and create a function where I can create a random password and allow the current user to reset the selected user's password. Can this be done? (The user accounts being selected would be unlicensed accounts not that this would make a difference as the accounts do exist on the network and appear in AD OUs.)

Great Video Shane . I have a requirement to display the Approvers name ( it is a lookup List - Field type - multiPeoplepicker) in Parent form . Ex : After user selecting the country , We need to set the country Approver names in Parent form (people picker) field automatically . We also need to give a option to users to update the existing approver names by adding or deleting the Names.

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

Thank you.

This is such a great solution: easy to understand and well demonstrated. Thanks, Shane! Is this still the way you would solve the scenario given the latest features on the current app version?

Hi Shane, Can we use the same concept for Dropdown box instead of Combo Box. thanks

I have always look into your videos related to PowerApps and its always help to get my requirement addressed. I wanted to get a way to added user VP name in text box but unable to get it. Not sure how to get user VP (Vice President) Display name in text box. Kindly me us know with an example. Thank you!

Great video Shane to start 2019. Thanks for sharing it.

Hi Shane, thanks for this video and for all your channel :) I am trying to reproduce this app but I have a different behaviour in the reset. When I reset in the ComboBox1 from icon "update" or from the event Onchange of the ComboBox, a blank row is inserted in the collection. Do you know which can be the reason? Greetings from Spain!

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.

Hi Shane, I want something similair but little different. I build a onboarding app. In a sharepoint list the job title is related to the manager. In powerapps I made a filter that when selecting a job title it shows the manager related to that job. I want to setup the manager value in ad but I need the GUID of the manager. I can use the office365 users and show an id, but what I want is to have a textinput of a label that shows the id of the selected manager. Is this possible that you know off and how can I achieve this. Many thanks!

Gracias!!!

I love this. Is it possible to take it a step further and exclude certain types of results from showing up in the list? For a particular app I don't need to search any groups. In InfoPath you could tell it to only look for users. This would be so helpful to be able to do.

This is an awesome solution; however, it does add a blank line in the collection when the combo box changes from a value to reset. Any way to eliminate the creation of this blank line in the collection. I see there are others who have asked the same question.

Hi Shane, Could you please share the link to the microsoft solution to this which you mentioned toward the end of this video ? Thanks ! You are the best

For some reason whenever I choose one name it adds the name to the collection but with another entry that is empty (it shows in the gallery too)

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

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

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 ?

Hello Shane, I would like to perform this same exercise with a group of 365, how could I generate this same filter? can you please help me

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?

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

Thank for the video, I want to exclude groups while searching, Can you help me on this?

Intro went in wrong direction 😉......Topic Well explained as always

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?

Hi Shane! Thanks for everything, you are a real star !!!! I have a problem with this, my Office 365 has more than 1000 people, but users will not search by name, they will filter by other tags like Department, Job title ... How can I do it ???

Thanks Shane. This video is very useful to me. Let me know how to create app for downloading employees details in to an excel sheet from a office365user database of over 10K employees.

Hi Shane, Quick question - I am using Sharepoint list name field to be picked up by my Flow to use the user search.. if my sharepoint list field is 'blank' and the flow is run, will it still give me ALL of the addressess from the AD? or will it abort? Thank you

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. 🙏🙏🙏

Hi Shane, Thanks for all of your videos. I have tried searching for this, but can't find how I would get the samaccountname? Would you be able to shed some light on the solution for this? Thanks in advance!!

Just another great tutorial, Shane. I was able to follow all steps presented. Also, I’d like to ask you for an advice how to search for groups in the Office365. I guess a different connector needs to be used but I am not sure how to put it in a formula. Thank you very much for sharing your knowledge. I have learned about Power Apps mostly watching your videos.

Hello, How can I use office365users command for combobox in form connected to SharePoint? Because of connected to SharePoint, there is Choice function in Items.

Shane, I've been learning a lot from your videos. A quick question. If the picker is recording each name to a SP list, does each name you add to the picker create it's own record?

Hi Shane! Thanks for the great video. I've followed all the steps but the combo box doesn't work as it should - it doesn't respond to the value from text input at all. Do you have any suggestions? :)

Hi Shane, thank you for this video, I really enjoying the way you bring this to be more exciting :) Ask one thing, in the combobox, after we search some name and select what we want, am having trouble to exit the lookup, so I need to click some "empty" space outside of the combo box in order to close the lookup and move one to other control. Do you have the same trouble ? or is just me who don;t know how to use that control (combobox) properly ? Thanks again, awesome videos. Cheers,

Good afternoon Shane. Is there a way to search only a specific distribution group with-in the company instead of the entire company?

hi thanks for the video... the dropdown has one issue... it is triggering false while selecting the first item...

Hi Shane, thanks gor your viedos!! Just one question, is it possible to display also 365 Contacts in the name field? I found a way to display my personal contacts but not the general ones. The only solution I found is to create a list wher i load all contacts and use this list to populate field choices. Am i wrong, is there a better solution around? Many thanks!

Hi Shane, is there a way to search user by keywords , eg Past Projects or skills ( info from UserProfileV2) instead of name and email ?

I cannot get this to work using Office365Users.SearchUserV2 The error I get is: Invalid Argument type(record). Expecting a table value instead. If I don't use Office365Users.SearchUserV2, and use Office365Users.SearchUser it works. But.... wondering how to get this working with the new V2 ? as you make a point to always choose the V2 versions if we see them. :)

Good morning Shane, my name is Carlos, I work in the Panama Canal in the IT area, I am starting with some projects in power apps I have seen many of your videos and they are really excellent, I have a question, we have a list of users of devices in Share point but they do not notify us when they retire until the Security staff removes them from the Active Directory, how do I make my power app compare my sharepoint list with the list in Office 365 User to mark the users who are no longer there?

Hi Shane, thank you for all the videos helping me loads. Is there a way to display the first item in the list you are filtering in the combo box so the box starts to show something?

@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 ?

Hello Shane, as usual thanks for sharing. I have a twist that is challenging me. Everything works as described, but I want to use this to edit existing records. So a record show with "Tom, Bob, Shane" in the input box as read from the record. How would I use the defaultSelectedItems to prepopulate the names in the combobox?

Hi Shane, I having trouble getting the email address from Office365users.SearchUser into a label from previously selected user name from dropdown box. my fx> Office365Users.SearchUser({searchTerm: Dropdown3.Selected.Con_FullName}) Error message: unexpected character. The Formula contains 'ParentClose' where 'Eof' is expected. There's something wrong with my formula, which I can't figure out. Any help would be appreciated. Thanks

Shane, will you make video of how to add users to groups via powerapps and specially how to add users to multiple groups at the time. I dont know is this scenario even possible?

really good! thank you so much for your amazing videos

How to search Groups in Powerapps, when I try this, I can search everyone, except for the groups, what connector do I need to use? Thanks

Hi Shane, Your videos have been super helpful! I'm running into an issue where I have a form set up where one of the data cards allows you to search employees by last name. I would like to have one of my other data cards pull in their department once an employee is selected. On the default dropdown for the department I have If(DataCardValue33.Selected.DisplayName=Office365Users.UserProfile(User().Email).DisplayName, Office365Users.UserProfile(User().Email).Department) Data Card Value 33 is a user picker brining in the selected users display name What Am i doing wrong?

Hi Shane is there an update to your video since the new v2 version is out and I can't get to the combo box properties to continue? Thanks in advance and these are super helpful. My goal is to ultimately add a people search to our SPO intranet page using this powerApp if it's even possible. EDIT: okay i went back and did not use V2 and was able to continue. PA has updated since this vid but your method helped a LOT!!!! Do you have or can you help with these items? Create in PA add a button after i find a user to Chat with user, call user, start vidchat with user, and also check my Teams voicemail? I'm trying to add these functions to my SPO Intranet page. many many thanks! EDIT2: I just found your site and will review your vids. I also subscribed!

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 ?

Hi Shane! Thank you for these videos! I was just wondering is there a way to send an email to the manager of the user of the PowerApp?

When i select a name on the list it adds 2 item on the gallery 1 with the detail and 1 blank

Hmm this was useful, anytime you think you could show us how to create a custom api or even use Azure AD API (built in) to read names in groups? Thanks Shane

Hi Shane. thanks for this useful video. Can you also advice how to save selected user in CDS, for example I'd like to save project manager in my app. which type of the field should I use? email or lookup of users entity or is there another technique for saving? thank you.

Thanks Shane. Love your videos. This one was spectacular as I told my boss PowerApps couldn't search for users...... This helps a lot. Question, when I use the Reset button it creates a blank record. I suspect the reset clearing the combo box is seen as a change and therefore creates a blank record. Any thoughts on that? Thanks in advance.

Shane - Great video. Is there a way to limit Office365Users to only search in a specific Organizational Unit in Active Directory instead of the entire AD?

Hi Shane, I managed to perform something similiar to this. I save the string into SQL but when I reopen the app it needs to load up the selected users back into the gallery from the saved SQL string. I am guessing you need to split the string?

Hi Shane! Thanks for the tutorial. I'm doing exactly what you do, but I can't write anything on the combobox. Hope you can help me, thanks!

Hello, your video is helpful. but I have a requests. Can you do a video on how to use the office365 users connector to show upcoming users birthdays?. This would be nice.

Hi Shane, this video was done in 2018. any update if PowerApps already changed the searchable data to maybe 2000+?

Hi Shane, We are trying to use a PowerApp to provide to our users, with links to our SharePoint Online content. Since we are already signed into PowerApps with our O365 Creds, how can we pass that auth to the mobile browser so they don't have to sign into SharePoint? We are using Azure AD and have some enterprise Apps we would like to link to from the PowerApp also. Please let me know how I can handle some of the challenges.

When searching for a name or an email, I get shown every person in the office365... any ideas why?

Shane, I am trying to create a basic Employee Directory with the following information... Employee Name, email address, phone number, extension, and location... is this possible?

I've used this on a form, works great on a new form. How do I get the user I selected using the same form in edit mode? Thank you

Love it

Great video, thank you. How do you find a manager from a populated combobox from a office365 user search?

is there any way to get all users, then put them into a collection?thanks