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!
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?
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.
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
Hi @Shane Young I am facing the same problem. There is always an empty entry added to the collection together with the user I selected. Do you have an idea of how to get rid of it? This is the code Collect(collectUsersToEmail,{Name:ComboBox1.Selected.DisplayName, Email:ComboBox1.Selected.Mail});Reset(ComboBox1);Reset(SearchField)
I found this solution and it is working for me, check the part after the last semicolon: Collect(collectUsersEmail, {Name: ComboBox1.Selected.DisplayName, Email: ComboBox1.Selected.Mail});Reset(ComboBox1);Reset(TextInput1); RemoveIf(collectUsersEmail, Name= Blank() And Email = Blank())
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?
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.
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
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.
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 ?
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!!!
I finally found the answer in one of your other videos!!! Once again, Shane Young to the rescue... For those interested the following created a new collection from an existing one with the data intact: ClearCollect(collectSendAs, collectFullAccess)
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.
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.
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?
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.
I had the exact same issue. Fixed it by changing "OnChange" of the "ComboBox" to: If(Not IsBlank(UserComboBox.Selected), Collect(collect .....)); Reset(UserComboBox); Reset(UserSerachBoxTextInput)
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.
@@ShanesCows Ok, that’s what it seemed to me. In the meantime I added a RemoveIf to my collection. But in your video there was nothing to suggest that you did it too. I understand better. Thank you again for your help through your videos, you save us a lot of time!
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?
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.
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! 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,
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.
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!!
@@ShanesCows... BOOM! Thank you sir. You made me think and point me in the right direction. My code is as follows: Office365Users.Manager(ComboBox1.Selected.Mail).Mail ..... Thanks for the fast reply and pointing me n the right direction. Keep up the great work!
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 thank you for this video. It was super useful. I was wondering, is there any way to add users to the email you want to send that are not within the organisation? Outlook/teams can do it if you add in specifically a persons email?
@@ShanesCows I was hoping to do it in the actual search user. So if there is no user found using search user, then give an option to add the email you have typed. I got the plan to use the match method to check that is an email. But I'm stuck on what to add for the check on when the searchuser doesn't return anything
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 ???
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!
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?
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?
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.
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?
@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.)
You are going to have to talk to the Graph API to do that. In my head it should all be possible but I haven't tried. Here is an intro to APIs if you haven't used them before th-cam.com/video/p8ErJU43N74/w-d-xo.html
Would you be interested in sharing how you did that and if you see the same issue with the blank line that is experienced when resetting the combo box?
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.
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?
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!
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 ?
@@anamariajaramillojimenez7837 Nothing yet, however we might be able to apply a workaround for you scenario. I'm down to give it a try and look what we can do.
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 - Great tutorial as always. I was able to implement the search, though now I'm trying to figure out how to have it return all items containing the text in the TexInput field. For instance, if I search for John Smith, it will only return the user John Smith. I would like it to return John B. Smith, John C Smith, John D. Smith, etc. Do you know if that's possible?
@@ShanesCows If I search for John, I can bring up the first 999 Johns, but our organization is very large. I'm trying to make it easy for our users to find a name, even if they don't know the person's middle initial.
Hey Shane, first of all great video! and thanks a lot for your videos. I am trying to search my coworkers by their office phone number. But that is not possible, i can only search them by their mobile number and that is circumstantially. Do you have a solution for this Problem?
Hey Shane. Great video. Quick question. I have built a powerapp which will be used by multiple companies within a portfolio. Lets say main company-mid company-Strategic business units. So 3 levels of companies. I'm using the Office365users connector and followed your directions here to find users. This part works great. What I'm not able to figure out is this scenerio. In O365 users are listed under Company and then Department. I want the user to be able to open the app and only have the ability to search on users by Department that they're assigned to since that's the SBU they work in. Is this possible? Thanks.
Hey Brad. Maybe? If the connector returns that info you could probably use the filter function against the search user function output. I haven’t tried but should be possible
@@ShanesCows Thanks. Yeah. This is what i've been struggling with. The O365 connector brings in the department. Now i'm trying to filter against the department so when a user in a different department opens the app they only see their employees. So I've got Office365Users.UserProfileV2(User().Email).department which returns the department. My dropdown formula (which isn't working) is Filter(Office365Users.SearchUser({searchTerm: TextInput1.Text}), Department = DisplayName )
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
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.
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, 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.
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?
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?
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, 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?
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, 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
Shane, great video as always! I've been trying to figure out how to filter a person field to return only results where the user has a job title (we have students and faculty in the same AAD; faculty have job titles, students do not, so we'd like to be able to return only faculty as results). I've tried using a condition of "!IsBlank(JobTitle)", but that doesn't seem to work. Any suggestion on how to do that?
Hi Chad. I wanted to filter the searchable records if the Office365 email (or Mail) field is blank, or the user doesn't have an email in their Office365 account. So I used this filter in the Items field: Filter(Office365Users.SearchUser({searchTerm:txtSearch365.Text, top:999}),!IsBlank(Mail)) So if the Mail record is NOT blank, then include that record in the available list of records that can be searched. In your case you would replace !IsBlank(Mail) with !IsBlank(JobTitle). Thanks must go to Shane for his excellent educational videos to teach us PowerApps and PowerAutomate.
@@mickyd4684 thanks for that info. As it turns out, we often have graduate level students teaching courses, so there's really no filter that's going to help here. I just need to rely on the students paying attention and following instructions (shock! horror!).
@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 ?
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, 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!
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
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?
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?
Shane Young, I am attempting to create a basic power app that I can link to SharePOint that when I key in an employee name it will pull up their contact information. Example: Name, email, phone number, extension and so on
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.
Hi, Shane, i need to give access for a screen to only certain members. Lets say group defined as owner/Admin of a SharePoint list or members of an outlook email ID. I can do that by listing each member’s name but whenever the members change; i need to make a change in Powerapp ! Do you have any short trick for that please ?
I am trying to update the data of People column in my sharepoint list. Situation is i have a Gallery from where i am trying to display a particular user name (from sharepoint) in my Combobox. Combobox is fetching user directly from O365 users (Items) . Now i want to display the selected user in that Combobox from the gallery. I need to do that in order to update the user for that particular record. Can u help me pleaseeee?
hey shane.., i started powerapp after seeing ur video... if i want to pull the email id in a label by selecting display name from a combo box, how can i do it? i m selecting an o365 user display name and want to pull the email id of that user as well
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. :)
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
And here we go again. Before the video "what can I learn new?" Shane: "Select(icon2)"; Booom, mind-blowing!
Thank you, sir!
Glad it helped. I always try to sneak bonus nuggets in where I can. :)
Completely true!!!!
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!
Thanks to you I learned PowerApps and I’m still learning, you are the best mentor ever!
You are welcome. Glad it helped. :)
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?
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.
Hello Bash! hope you are well, did you find the solution? I have same issue now
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
Your code is slightly eschew I am guessing. Post it here?
@@ShanesCows Collect(UserstoEmail,{Name:ComboBox_UserstoSelect.Selected.DisplayName,Email:ComboBox_UserstoSelect.Selected.Mail});Reset(ComboBox_UserstoSelect);Reset(TextInput1)
Same here!
Hi @Shane Young I am facing the same problem.
There is always an empty entry added to the collection together with the user I selected.
Do you have an idea of how to get rid of it?
This is the code
Collect(collectUsersToEmail,{Name:ComboBox1.Selected.DisplayName, Email:ComboBox1.Selected.Mail});Reset(ComboBox1);Reset(SearchField)
I found this solution and it is working for me, check the part after the last semicolon:
Collect(collectUsersEmail, {Name: ComboBox1.Selected.DisplayName, Email: ComboBox1.Selected.Mail});Reset(ComboBox1);Reset(TextInput1); RemoveIf(collectUsersEmail, Name= Blank() And Email = Blank())
Hey Shane, everytime I'm pressing the reset button it creates a new collection item that is blank. How do i stop this?
This happened to me too when I followed along. Curious about the fix - might be hard if he can't reproduce it. Might be how our data is stored w/ MS.
Hi Shane,
Can we use the same concept for Dropdown box instead of Combo Box.
thanks
I think so. Haven't tried.
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?
Yup 👍 it doesn’t care how it gets populated just that it does. 😀
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.
Thanks for that!
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
Rohit can you give me a time stamp? Sorry I don’t remember
@@ShanesCows At about 22.45. when you say you want to show us the microsoft stuff.
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.
You could return the users and then add filters to the table that gets return.
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 ?
THat limit was the function I was using, not the control.
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!!!
I finally found the answer in one of your other videos!!! Once again, Shane Young to the rescue... For those interested the following created a new collection from an existing one with the data intact: ClearCollect(collectSendAs, collectFullAccess)
Cool
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!
Glad it helped.
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.
Glad they have improved it over the years. I haven’t had to do this scenario in a while so thanks for the tip. 🐶
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.
Change your & to ;; and you should be good to go
@@ShanesCows Wow!! That simple! It worked! Very grateful indeed!
@@ShanesCows
After I select the user in the gallery, can I record in the source? I have a table with a column called the user's email. Thankful!
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?
Not that I know of. 😐
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.
Delete the blank record. 😉 Easy enough.
I had the exact same issue. Fixed it by changing "OnChange" of the "ComboBox" to:
If(Not IsBlank(UserComboBox.Selected), Collect(collect .....));
Reset(UserComboBox);
Reset(UserSerachBoxTextInput)
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.
Yes, when that happens anywhere I use the collection I filter it to not show the blank rows. So they are there but ignored.
@@ShanesCows Ok, that’s what it seemed to me. In the meantime I added a RemoveIf to my collection. But in your video there was nothing to suggest that you did it too. I understand better.
Thank you again for your help through your videos, you save us a lot of time!
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?
You could set the DefaultSelectedItem
That was very helpful, I wonder why MS doesn't just gives a combobox with the same workaround you created omg
🐶
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.
It is a table, so you could filter the list of users Table. I sometimes do this to filter out external people.
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.
Where you able to find how to eliminate the blank line, I'm having the same issue?
Filter the gallery to not show the blank line. Then use Gallery.allitems when you patch. No more blank lines
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?
Yes. Get the managers email from Office365Manager action
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,
The combo control just isn’t awesome. 😑
@@ShanesCows haha.. too bad😅😅
Shane you are genius man, i figure out the things i required after watch this video.👍👍👍👍👍
Awesome 😎
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.
For CDS I usually use the User entity.
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!!
Great video, thank you. How do you find a manager from a populated combobox from a office365 user search?
I don’t have it handy but something lie Office365Users.Manager(combo.selected.email)
@@ShanesCows... BOOM! Thank you sir. You made me think and point me in the right direction. My code is as follows: Office365Users.Manager(ComboBox1.Selected.Mail).Mail ..... Thanks for the fast reply and pointing me n the right direction. Keep up the great work!
Hi Shane, great videos! Is there a way to have a drop-down where I only see the members of the SharePoint site I'm using?
There isn’t an easy way to get the list of SharePoint users like that. 😔 Graph API probably can though
@@ShanesCows ok, thought so :D thanks for the answer!
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 Alberto, did you fix it? I have the same issue now
Hi thank you for this video.
It was super useful.
I was wondering, is there any way to add users to the email you want to send that are not within the organisation?
Outlook/teams can do it if you add in specifically a persons email?
Make a textinput and let people type in email addresses then use that text in the to section
@@ShanesCows I was hoping to do it in the actual search user.
So if there is no user found using search user, then give an option to add the email you have typed.
I got the plan to use the match method to check that is an email.
But I'm stuck on what to add for the check on when the searchuser doesn't return anything
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 ???
Jose I think you have to use the Graph API for that. 😑Though I have never tried.
@@ShanesCows Oh.... shit... I have never worked with Graph. You have any video whits this??? Thanks for all!!!!!
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!
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?
You have to filter the items property to return the records you want to match.
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?
I think so. 🤔 But haven’t thought about it too much
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.
You will use a Combo Box and then you need to get the formula correct for the DefaultSelectedItems property of the Combobox.
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?
It is up to you and how you add them to SharePoint. You can do either way.
@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.)
You are going to have to talk to the Graph API to do that. In my head it should all be possible but I haven't tried. Here is an intro to APIs if you haven't used them before th-cam.com/video/p8ErJU43N74/w-d-xo.html
@@ShanesCows - you're beyond awesome! Thanks so much, I know nothing about Graph API- will need to read up, very grateful - thanks Shane!
Another great video Shane. Many thanks, just what I needed to move on another step.
Fantastic!
Well explained useful example as always. I did something similar but used a gallery instead of a combo box to display the employees.
Nice! 👍
Would you be interested in sharing how you did that and if you see the same issue with the blank line that is experienced when resetting the combo box?
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.
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?
I have never tried. I will make a note to take a look and add it to the list if possible.
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!
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 ?
Did you get a solution to this? I have the same thing happening
@@perthsteve5032 sadly nothing yet
Any solution to this? I'm having the same issue :(
@@sebastianmanrique9877 any solution? I have the same issue
@@anamariajaramillojimenez7837 Nothing yet, however we might be able to apply a workaround for you scenario. I'm down to give it a try and look what we can do.
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! 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!
You need to use the text input to let the users enter the name.
Good afternoon Shane. Is there a way to search only a specific distribution group with-in the company instead of the entire company?
Shane, Thank you. This opened up a lot of new ideas for me.
Awesome
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
Should be the same?
Hi Shane - Great tutorial as always. I was able to implement the search, though now I'm trying to figure out how to have it return all items containing the text in the TexInput field. For instance, if I search for John Smith, it will only return the user John Smith. I would like it to return John B. Smith, John C Smith, John D. Smith, etc. Do you know if that's possible?
I don’t follow. If you search for John does it not work that way?
@@ShanesCows If I search for John, I can bring up the first 999 Johns, but our organization is very large. I'm trying to make it easy for our users to find a name, even if they don't know the person's middle initial.
Hey Shane,
first of all great video! and thanks a lot for your videos. I am trying to search my coworkers by their office phone number. But that is not possible, i can only search them by their mobile number and that is circumstantially. Do you have a solution for this Problem?
I don’t. Maybe try to graph api?
Great video Shane, got me thinking how I could modify your idea to make it fit an upcoming app. Thanks and happy New year!
Thanks. Happy new year to you also.
Hey Shane. Great video. Quick question. I have built a powerapp which will be used by multiple companies within a portfolio. Lets say main company-mid company-Strategic business units. So 3 levels of companies. I'm using the Office365users connector and followed your directions here to find users. This part works great. What I'm not able to figure out is this scenerio. In O365 users are listed under Company and then Department. I want the user to be able to open the app and only have the ability to search on users by Department that they're assigned to since that's the SBU they work in. Is this possible? Thanks.
Hey Brad. Maybe? If the connector returns that info you could probably use the filter function against the search user function output. I haven’t tried but should be possible
@@ShanesCows Thanks. Yeah. This is what i've been struggling with. The O365 connector brings in the department. Now i'm trying to filter against the department so when a user in a different department opens the app they only see their employees. So I've got Office365Users.UserProfileV2(User().Email).department which returns the department. My dropdown formula (which isn't working) is Filter(Office365Users.SearchUser({searchTerm: TextInput1.Text}), Department = DisplayName )
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
I haven't tried but might be possible.
Thank for the video, I want to exclude groups while searching, Can you help me on this?
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?
I haven't done that. You would have to get them all into a collection first, there is no function that returns both I know of. Boo
You're a genius, Shane! Thank you!
You’re the best
Hi Shane,
this video was done in 2018. any update if PowerApps already changed the searchable data to maybe 2000+?
Nothing has changed here that I know of.
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.
That is normal. In you gallery Filter out the blank rows. 😎
Happy New Year Shane! Another Great Video.
Can you please do a video on datatable & chart please ?
Hi. I do need to cover those. One day I hope.
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.
Not sure if that is possible here. Maybe PowerShell would be better.
Hi Shane, is there a way to search user by keywords , eg Past Projects or skills ( info from UserProfileV2) instead of name and email ?
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.
Sorry you can’t pass the auth. Hope the first time they login they cache the auth on their device.
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?
Yup. You got it. 😀
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?
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.
I haven't done that one before. WHat have you tried?
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, 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?
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
I need to do more there for sure. Hopefully one day.
hi thanks for the video... the dropdown has one issue... it is triggering false while selecting the first item...
Use the new property to make the Dropdown blank? th-cam.com/video/NzhwTrXA-cQ/w-d-xo.html
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
Not sure. Sorry.
Shane, great video as always! I've been trying to figure out how to filter a person field to return only results where the user has a job title (we have students and faculty in the same AAD; faculty have job titles, students do not, so we'd like to be able to return only faculty as results). I've tried using a condition of "!IsBlank(JobTitle)", but that doesn't seem to work. Any suggestion on how to do that?
Sorry, Chad I haven't messed with JobTitle. Does Search let you search on Job title?
Hi Chad. I wanted to filter the searchable records if the Office365 email (or Mail) field is blank, or the user doesn't have an email in their Office365 account. So I used this filter in the Items field: Filter(Office365Users.SearchUser({searchTerm:txtSearch365.Text, top:999}),!IsBlank(Mail)) So if the Mail record is NOT blank, then include that record in the available list of records that can be searched. In your case you would replace !IsBlank(Mail) with !IsBlank(JobTitle). Thanks must go to Shane for his excellent educational videos to teach us PowerApps and PowerAutomate.
@@mickyd4684 thanks for that info. As it turns out, we often have graduate level students teaching courses, so there's really no filter that's going to help here. I just need to rely on the students paying attention and following instructions (shock! horror!).
@@mickyd4684 Thanks Michael - I was hoping Shane would discuss filtering in his video. Luckily I spotted your comment. Thanks again!
Can you sort the names asc? There doesn't seem to be a rhyme or reason how it is sorted by default
It is a table of data. You can wrap it in a SortByColumns and sort by name. So yes. 😎
@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 ?
I don’t know. Never tried. 😑
Thank you for sharing the info Many organizations do look for bulk emailing solutions. Happy New Year
You are welcome.
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. 🙏🙏🙏
Yes, all users have to have a Power Apps license to use your app
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!
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
That looks correct to return a table of results. Take the Distinct off and see if you get data that way
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
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)
Yeah. You need to filter out the blank rows. The OnChange fires twice causing the blank
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?
I got nothing. Sorry 😑
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?
Yes. You can make a data source and track that info. Is that what you are looking for?
Shane Young, I am attempting to create a basic power app that I can link to SharePOint that when I key in an employee name it will pull up their contact information. Example: Name, email, phone number, extension and so on
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.
Hi, Shane, i need to give access for a screen to only certain members. Lets say group defined as owner/Admin of a SharePoint list or members of an outlook email ID. I can do that by listing each member’s name but whenever the members change; i need to make a change in Powerapp !
Do you have any short trick for that please ?
One of my recent videos about Hide buttons covers exactly that 😀
Thanks Shane. 👍
Watching your vid today. On New Years Eve 2019. :) Thank you for your videos!
Thanks for watching and happy new year 🎈
Hi Shane, How can I search for Group? Thank You.
I need to make that video still. There is an office 365 groups connector you can add.
Love this, thank you so much Shane 🥰
Glad to help. 😀
When i select a name on the list it adds 2 item on the gallery 1 with the detail and 1 blank
Filter the gallery to not show the blank ones. :) It is because the OnChange is firing twice.
You saved me again witht his old video!
Awesome Possum!
I am trying to update the data of People column in my sharepoint list.
Situation is i have a Gallery from where i am trying to display a particular user name (from sharepoint) in my Combobox. Combobox is fetching user directly from O365 users (Items) . Now i want to display the selected user in that Combobox from the gallery.
I need to do that in order to update the user for that particular record.
Can u help me pleaseeee?
YOu need to set the DefaultSelectedItems for the combobox by looking up the user record from the gallery.
@@ShanesCows got that...
hey shane.., i started powerapp after seeing ur video... if i want to pull the email id in a label by selecting display name from a combo box, how can i do it? i m selecting an o365 user display name and want to pull the email id of that user as well
Combobox.selected.EmailID if the data is in the table. If not you will need to do a LookUp based on the selected value in the combobox.
@@ShanesCows great... it worked... thanks a lot
is there any way to get all users, then put them into a collection?thanks
ClearCollect(colUsers, Office365Users.SearchUserV2({top:1000}).value)
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. :)
Office365Users.SearchUsersv2() should work. 😑
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
Intro went in wrong direction 😉......Topic Well explained as always
Thanks