And here we go again. Before the video "what can I learn new?" Shane: "Select(icon2)"; Booom, mind-blowing! Thank you, sir!
@ShanesCows
5 жыл бұрын
Glad it helped. I always try to sneak bonus nuggets in where I can. :)
@gerardosalazar2426
5 жыл бұрын
Completely true!!!!
@gerardosalazar2426
5 жыл бұрын
Thanks to you I learned PowerApps and I’m still learning, you are the best mentor ever!
@ShanesCows
5 жыл бұрын
You are welcome. Glad it helped. :)
@Ask65k
4 жыл бұрын
Shane you are genius man, i figure out the things i required after watch this video.👍👍👍👍👍
@ShanesCows
4 жыл бұрын
Awesome 😎
@stwilhite1
2 жыл бұрын
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.
@ShanesCows
2 жыл бұрын
Thanks for that!
@ambujaable
5 жыл бұрын
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!
@ShanesCows
5 жыл бұрын
Glad it helped.
@markmclean154
5 жыл бұрын
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
@ShanesCows
5 жыл бұрын
Your code is slightly eschew I am guessing. Post it 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)
@eil6680
3 жыл бұрын
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())
@elkolodj1
3 жыл бұрын
That was very helpful, I wonder why MS doesn't just gives a combobox with the same workaround you created omg
@ShanesCows
3 жыл бұрын
🐶
@justingallaher5068
2 ай бұрын
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.
@ShanesCows
2 ай бұрын
That is normal. In you gallery Filter out the blank rows. 😎
@JenniferLaveryFBE
3 жыл бұрын
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?
@hudsonquay
4 жыл бұрын
Well explained useful example as always. I did something similar but used a gallery instead of a combo box to display the employees.
@ShanesCows
4 жыл бұрын
Nice! 👍
@julireid9574
4 жыл бұрын
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?
@garymalley1797
3 жыл бұрын
Another great video Shane. Many thanks, just what I needed to move on another step.
@ShanesCows
3 жыл бұрын
Fantastic!
@andrasradocz
2 жыл бұрын
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.
@ShanesCows
2 жыл бұрын
Glad they have improved it over the years. I haven’t had to do this scenario in a while so thanks for the tip. 🐶
@chuckclark3277
4 жыл бұрын
You're a genius, Shane! Thank you!
@ShanesCows
4 жыл бұрын
You’re the best
@radiosonicfan1726
4 жыл бұрын
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?
@ShanesCows
4 жыл бұрын
Yup 👍 it doesn’t care how it gets populated just that it does. 😀
@mauroalbran
4 жыл бұрын
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
4 жыл бұрын
Change your & to ;; and you should be good to go
@mauroalbran
4 жыл бұрын
@@ShanesCows Wow!! That simple! It worked! Very grateful indeed!
@mauroalbran
4 жыл бұрын
@@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!
@Park-gp5zd
5 жыл бұрын
Shane, Thank you. This opened up a lot of new ideas for me.
@ShanesCows
5 жыл бұрын
Awesome
@mattengel1866
4 жыл бұрын
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!!!
@mattengel1866
4 жыл бұрын
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)
@ShanesCows
4 жыл бұрын
Cool
@vprasannak
4 жыл бұрын
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.
@ShanesCows
4 жыл бұрын
You will use a Combo Box and then you need to get the formula correct for the DefaultSelectedItems property of the Combobox.
@jomarismeneses3765
5 ай бұрын
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!
@user-ye7kb2tv7r
Ай бұрын
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
27 күн бұрын
Yes, when that happens anywhere I use the collection I filter it to not show the blank rows. So they are there but ignored.
@user-ye7kb2tv7r
27 күн бұрын
@@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!
@julireid9574
4 жыл бұрын
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.
@ShanesCows
4 жыл бұрын
You could return the users and then add filters to the table that gets return.
@CINsyg
3 жыл бұрын
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
@ShanesCows
3 жыл бұрын
I haven't tried but might be possible.
@DraaxDard
5 жыл бұрын
Great video Shane, got me thinking how I could modify your idea to make it fit an upcoming app. Thanks and happy New year!
@ShanesCows
5 жыл бұрын
Thanks. Happy new year to you also.
@Crockerfeller
4 жыл бұрын
Watching your vid today. On New Years Eve 2019. :) Thank you for your videos!
@ShanesCows
4 жыл бұрын
Thanks for watching and happy new year 🎈
@TajimaPendragon
6 күн бұрын
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?
@mcs3015
3 жыл бұрын
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?
@ShanesCows
3 жыл бұрын
I think so. 🤔 But haven’t thought about it too much
@NKBobcat
4 жыл бұрын
You saved me again witht his old video!
@ShanesCows
4 жыл бұрын
Awesome Possum!
@JohnsonVettuvelil
5 жыл бұрын
Thank you for sharing the info Many organizations do look for bulk emailing solutions. Happy New Year
@ShanesCows
5 жыл бұрын
You are welcome.
@RD-gp1mu
Ай бұрын
@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.)
@ShanesCows
Ай бұрын
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 kzitem.info/news/bejne/0W572H6LbWV_amk
@RD-gp1mu
Ай бұрын
@@ShanesCows - you're beyond awesome! Thanks so much, I know nothing about Graph API- will need to read up, very grateful - thanks Shane!
@tonya3308
5 жыл бұрын
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.
@pinchinpinchin3811
5 жыл бұрын
Where you able to find how to eliminate the blank line, I'm having the same issue?
@ShanesCows
5 жыл бұрын
Filter the gallery to not show the blank line. Then use Gallery.allitems when you patch. No more blank lines
@Vihushrihu
3 жыл бұрын
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
@ShanesCows
3 жыл бұрын
Rohit can you give me a time stamp? Sorry I don’t remember
@Vihushrihu
3 жыл бұрын
@@ShanesCows At about 22.45. when you say you want to show us the microsoft stuff.
@parranoic
3 жыл бұрын
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)
@ShanesCows
3 жыл бұрын
Yeah. You need to filter out the blank rows. The OnChange fires twice causing the blank
@wendymason3263
3 жыл бұрын
Love this, thank you so much Shane 🥰
@ShanesCows
3 жыл бұрын
Glad to help. 😀
@ambujaable
5 жыл бұрын
Happy New Year Shane! Another Great Video. Can you please do a video on datatable & chart please ?
@ShanesCows
5 жыл бұрын
Hi. I do need to cover those. One day I hope.
@kabadiharikiran2508
Жыл бұрын
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!
@raghadm5719
10 ай бұрын
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.
@ShanesCows
10 ай бұрын
It is a table, so you could filter the list of users Table. I sometimes do this to filter out external people.
@joseluiscolladosoriano9640
3 жыл бұрын
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 ???
@ShanesCows
3 жыл бұрын
Jose I think you have to use the Graph API for that. 😑Though I have never tried.
@joseluiscolladosoriano9640
3 жыл бұрын
@@ShanesCows Oh.... shit... I have never worked with Graph. You have any video whits this??? Thanks for all!!!!!
@kaushikpurohit9175
4 жыл бұрын
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.
@ShanesCows
4 жыл бұрын
Not sure if that is possible here. Maybe PowerShell would be better.
@peterkaprinyak9692
Жыл бұрын
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.
@SK-ic5vk
5 жыл бұрын
Intro went in wrong direction 😉......Topic Well explained as always
@ShanesCows
5 жыл бұрын
Thanks
@TheShnitbear
3 жыл бұрын
Can you sort the names asc? There doesn't seem to be a rhyme or reason how it is sorted by default
@ShanesCows
3 жыл бұрын
It is a table of data. You can wrap it in a SortByColumns and sort by name. So yes. 😎
@albertocastro365
3 жыл бұрын
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!
@anamariajaramillojimenez7837
2 жыл бұрын
Hi Alberto, did you fix it? I have the same issue now
@anshujha3885
2 жыл бұрын
Hi Shane, Can we use the same concept for Dropdown box instead of Combo Box. thanks
@ShanesCows
2 жыл бұрын
I think so. Haven't tried.
@hokemspitter
2 жыл бұрын
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.
@anamariajaramillojimenez7837
2 жыл бұрын
Hello Bash! hope you are well, did you find the solution? I have same issue now
@DavidPrenticeJr
3 жыл бұрын
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?
@ShanesCows
3 жыл бұрын
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
@metalsnake00
3 жыл бұрын
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?
@ShanesCows
3 жыл бұрын
I have never tried. I will make a note to take a look and add it to the list if possible.
@honganhuynh6003
Жыл бұрын
Hey Shane, everytime I'm pressing the reset button it creates a new collection item that is blank. How do i stop this?
@user-ts4td4wn3q
5 ай бұрын
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.
@kanishkaroychowdhury4050
4 жыл бұрын
hi thanks for the video... the dropdown has one issue... it is triggering false while selecting the first item...
@ShanesCows
4 жыл бұрын
Use the new property to make the Dropdown blank? kzitem.info/news/bejne/r7Ce3YiokXNeloY
@payalgupta2294
4 жыл бұрын
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
@ShanesCows
4 жыл бұрын
That looks correct to return a table of results. Take the Distinct off and see if you get data that way
@antonzhong9970
4 жыл бұрын
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,
@ShanesCows
4 жыл бұрын
The combo control just isn’t awesome. 😑
@antonzhong9970
4 жыл бұрын
@@ShanesCows haha.. too bad😅😅
@taruntarun00198
2 жыл бұрын
Thank for the video, I want to exclude groups while searching, Can you help me on this?
@Jean-Paul1001
10 ай бұрын
I need something like this but instead of search using names, I need all people with a certain job title
@Planeflake
3 жыл бұрын
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?
@ShanesCows
3 жыл бұрын
I got nothing. Sorry 😑
@cristinaR2
2 жыл бұрын
Amazing content!!!
@ShanesCows
2 жыл бұрын
Glad you enjoyed it
@arielalonzo4556
2 жыл бұрын
When searching for a name or an email, I get shown every person in the office365... any ideas why?
@stevegardner5802
5 жыл бұрын
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.
@ShanesCows
5 жыл бұрын
Delete the blank record. 😉 Easy enough.
@BrechtGijbels
3 жыл бұрын
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)
@ulises0502
4 жыл бұрын
many thanks, Shane I'm your Fan!
@ShanesCows
4 жыл бұрын
Thanks 😊
@Eb_Games
5 жыл бұрын
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
@ShanesCows
5 жыл бұрын
I need to do more there for sure. Hopefully one day.
@cool24a
5 жыл бұрын
Happy new year! Awesome Videos!
@ShanesCows
5 жыл бұрын
Thanks Daniel. Happy new year to you :)
@hbmgfoundation6136
4 жыл бұрын
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
4 жыл бұрын
It is up to you and how you add them to SharePoint. You can do either way.
@MustafaFarooq
3 жыл бұрын
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 ?
@perthsteve5032
2 жыл бұрын
Did you get a solution to this? I have the same thing happening
@MustafaFarooq
2 жыл бұрын
@@perthsteve5032 sadly nothing yet
@sebastianmanrique9877
2 жыл бұрын
Any solution to this? I'm having the same issue :(
@anamariajaramillojimenez7837
2 жыл бұрын
@@sebastianmanrique9877 any solution? I have the same issue
@sebastianmanrique9877
2 жыл бұрын
@@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.
@mskaelgonza
3 жыл бұрын
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
@andreyl2338
4 жыл бұрын
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.
@ShanesCows
4 жыл бұрын
For CDS I usually use the User entity.
@mash6184
3 жыл бұрын
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!!
@zai1590
3 жыл бұрын
When i select a name on the list it adds 2 item on the gallery 1 with the detail and 1 blank
@ShanesCows
3 жыл бұрын
Filter the gallery to not show the blank ones. :) It is because the OnChange is firing twice.
@ehsanhakimi
5 жыл бұрын
Great video Shane to start 2019. Thanks for sharing it.
@ShanesCows
5 жыл бұрын
Thank you. :)
@bobvonilten2874
5 жыл бұрын
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?
@ShanesCows
5 жыл бұрын
You have to filter the items property to return the records you want to match.
@utoroprincewill7808
5 жыл бұрын
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.
@ShanesCows
5 жыл бұрын
I haven't done that one before. WHat have you tried?
@milagrosjaraquispe789
4 жыл бұрын
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!
@ShanesCows
4 жыл бұрын
You need to use the text input to let the users enter the name.
@Crockerfeller
4 жыл бұрын
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. :)
@ShanesCows
4 жыл бұрын
Office365Users.SearchUsersv2() should work. 😑
@jjayceeb
3 жыл бұрын
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. 🙏🙏🙏
@ShanesCows
3 жыл бұрын
Yes, all users have to have a Power Apps license to use your app
@divyasree3436
3 жыл бұрын
In this video, I still see that we are fetching only top 999 users. Could you plz explain how to fetch more than 999 users?
@stevehaycock4766
4 жыл бұрын
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?
@ShanesCows
4 жыл бұрын
You could set the DefaultSelectedItem
@fly2manish
3 жыл бұрын
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 ?
@ShanesCows
3 жыл бұрын
THat limit was the function I was using, not the control.
@ousselg1509
2 жыл бұрын
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!
@punit45232
4 жыл бұрын
Great Video! Thank you!
@ShanesCows
4 жыл бұрын
Glad to help. 😀
@josieprofi2398
2 жыл бұрын
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!
@kimpaciotti8913
3 жыл бұрын
Thank you.
@ShanesCows
3 жыл бұрын
Happy to help Kim
@HEROGaming-yy9dz
3 жыл бұрын
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
@sarikagurung2465
4 жыл бұрын
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
@ShanesCows
4 жыл бұрын
Not sure. Sorry.
@IggyVanca
2 жыл бұрын
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.
@anlylmaz3014
2 жыл бұрын
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.
@markgovatos6294
4 жыл бұрын
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?
@ShanesCows
4 жыл бұрын
Not that I know of. 😐
@kikebarahona3097
3 жыл бұрын
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?
@aniamiklewska352
3 жыл бұрын
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? :)
@safetydave23
4 жыл бұрын
Great video, thank you. How do you find a manager from a populated combobox from a office365 user search?
@ShanesCows
4 жыл бұрын
I don’t have it handy but something lie Office365Users.Manager(combo.selected.email)
@safetydave23
4 жыл бұрын
@@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!
@aimeemullins2926
4 жыл бұрын
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?
@ShanesCows
4 жыл бұрын
Yes. Get the managers email from Office365Manager action
@SAULSM17
3 жыл бұрын
Gracias!!!
@ShanesCows
3 жыл бұрын
De nada.
@shanetrahan8224
3 жыл бұрын
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?
@ShanesCows
3 жыл бұрын
Yes. You can make a data source and track that info. Is that what you are looking for?
@shanetrahan8224
3 жыл бұрын
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
@pdixan61
2 жыл бұрын
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!
@aravindadamarla
3 жыл бұрын
@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 ?
@ShanesCows
3 жыл бұрын
I don’t know. Never tried. 😑
@genovjillella3602
3 жыл бұрын
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
@jamesforsythe2677
4 жыл бұрын
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.
@ShanesCows
4 жыл бұрын
Sorry you can’t pass the auth. Hope the first time they login they cache the auth on their device.
@dcm9058
4 жыл бұрын
Hi Shane, this video was done in 2018. any update if PowerApps already changed the searchable data to maybe 2000+?
@ShanesCows
4 жыл бұрын
Nothing has changed here that I know of.
@jamespark114
4 жыл бұрын
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?
@ShanesCows
4 жыл бұрын
Yup. You got it. 😀
@kanishkaroychowdhury4050
4 жыл бұрын
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?
@ShanesCows
4 жыл бұрын
YOu need to set the DefaultSelectedItems for the combobox by looking up the user record from the gallery.
@kanishkaroychowdhury4050
4 жыл бұрын
@@ShanesCows got that...
@robx1971
4 жыл бұрын
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
@ShanesCows
4 жыл бұрын
Should be the same?
@blutkraehe_official
4 жыл бұрын
Hi, i has a error: 6:22 Unexpected signs. The formula contains "Paren Close", but it is expected "Eof".
@ShanesCows
4 жыл бұрын
Share your formula here ina new comment. You must have a typo
@blutkraehe_official
4 жыл бұрын
@@ShanesCows the problem is, i have a Person column in my share point list
@Daniel199824
4 жыл бұрын
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?
@ShanesCows
4 жыл бұрын
I don’t. Maybe try to graph api?
@timothychan8291
3 жыл бұрын
Good afternoon Shane. Is there a way to search only a specific distribution group with-in the company instead of the entire company?
Пікірлер: 284