PowerApps Office 365 User Search

PowerApps Office 365 User Search

Shane Young

5 лет назад

130,506 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@raghadm5719
@raghadm5719 - 19.10.2023 20:25

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.

Ответить
@Jean-Paul1001
@Jean-Paul1001 - 10.10.2023 18:53

I need something like this but instead of search using names, I need all people with a certain job title

Ответить
@ItsMe-si3ov
@ItsMe-si3ov - 01.03.2023 10:50

Hello Shane, I really love your channel and I got tons of good hints for my daily work here.
Regarding the Office365Users connector; Is there a reference of all the possibilities to find users, information about aso.?
E.G. the method to reduce the results by defining the search term or limiting the number of results by typing {top:999} ?

Ответить
@honganhuynh6003
@honganhuynh6003 - 10.02.2023 21:56

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

Ответить
@peterkaprinyak9692
@peterkaprinyak9692 - 08.12.2022 12:24

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.

Ответить
@kabadiharikiran2508
@kabadiharikiran2508 - 26.10.2022 17:56

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!

Ответить
@cristinaraicovici5689
@cristinaraicovici5689 - 07.07.2022 01:15

Amazing content!!!

Ответить
@andrasradocz
@andrasradocz - 29.06.2022 00:10

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.

Ответить
@anshujha3885
@anshujha3885 - 24.05.2022 22:55

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

Ответить
@hokemspitter
@hokemspitter - 19.05.2022 04:28

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.

Ответить
@arielalonzo4556
@arielalonzo4556 - 19.04.2022 19:40

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

Ответить
@anlylmaz3014
@anlylmaz3014 - 01.03.2022 11:29

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.

Ответить
@gnanavelvengatesan2814
@gnanavelvengatesan2814 - 24.02.2022 11:40

Sharepoint List Powerapps Customize forms.
I'm using Office365user connector to display a officeusers Displayname in 'ComboBox ' using this formula in items "Office365Users.SearchUser({searchTerm:ComboBox1.SearchText,top:509}).DisplayName"
I'm trying get a existing value in ComboBox in 'DefaultSelectedItems' using Parent.Default but its not working showing error.

Ответить
@ousselg1509
@ousselg1509 - 11.02.2022 13:30

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!

Ответить
@josieprofi2398
@josieprofi2398 - 26.01.2022 10:48

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!

Ответить
@stwilhite1
@stwilhite1 - 12.01.2022 04:43

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.

Ответить
@pdixan61
@pdixan61 - 19.12.2021 12:13

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!

Ответить
@IggyVanca
@IggyVanca - 06.12.2021 09:39

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.

Ответить
@chonggee8254
@chonggee8254 - 03.11.2021 10:52

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

Ответить
@taruntarun00198
@taruntarun00198 - 15.09.2021 05:19

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

Ответить
@kikebarahona3097
@kikebarahona3097 - 20.08.2021 18:27

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?

Ответить
@divyasree3436
@divyasree3436 - 06.08.2021 12:55

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?

Ответить
@mash6184
@mash6184 - 30.07.2021 05:33

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!!

Ответить
@Planeflake
@Planeflake - 20.07.2021 01:58

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?

Ответить
@mskaelgonza
@mskaelgonza - 10.07.2021 05:42

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

Ответить
@stevenstocking3523
@stevenstocking3523 - 08.07.2021 21:30

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?

Ответить
@wendymason3263
@wendymason3263 - 28.06.2021 19:17

Love this, thank you so much Shane 🥰

Ответить
@MustafaFarooq
@MustafaFarooq - 18.06.2021 01:10

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 ?

Ответить
@bhanuprathappoojari5453
@bhanuprathappoojari5453 - 17.06.2021 08:40

can anybody help me to set multiple users as a default in people picker?

Ответить
@parranoic
@parranoic - 12.06.2021 02:52

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)

Ответить
@aniamiklewska352
@aniamiklewska352 - 09.06.2021 12:46

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? :)

Ответить
@timothychan8291
@timothychan8291 - 29.05.2021 21:59

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

Ответить
@JenniferLaveryFBE
@JenniferLaveryFBE - 25.05.2021 18:23

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?

Ответить
@albertocastro365
@albertocastro365 - 20.05.2021 00:41

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!

Ответить
@HEROGaming-yy9dz
@HEROGaming-yy9dz - 12.05.2021 10:24

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

Ответить
@genovjillella3602
@genovjillella3602 - 10.05.2021 02:41

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

Ответить
@powerappstw
@powerappstw - 27.04.2021 12:08

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

Ответить
@nanu1624
@nanu1624 - 19.04.2021 18:22

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

Ответить
@joseluiscolladosoriano9640
@joseluiscolladosoriano9640 - 15.04.2021 19:29

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

Ответить
@DavidPrenticeJr
@DavidPrenticeJr - 17.03.2021 19:02

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?

Ответить
@mcs3015
@mcs3015 - 14.03.2021 20:09

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?

Ответить
@SAULSM17
@SAULSM17 - 12.03.2021 20:47

Gracias!!!

Ответить
@jjayceeb
@jjayceeb - 12.03.2021 20:10

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

Ответить
@garymalley1797
@garymalley1797 - 07.03.2021 16:53

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

Ответить
@metalsnake00
@metalsnake00 - 03.03.2021 22:53

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?

Ответить
@bradhoyer8691
@bradhoyer8691 - 11.02.2021 19:28

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.

Ответить
@TheShnitbear
@TheShnitbear - 10.02.2021 23:15

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

Ответить
@zai1590
@zai1590 - 25.01.2021 16:54

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

Ответить
@kimpaciotti8913
@kimpaciotti8913 - 20.01.2021 16:57

Thank you.

Ответить
@bethg2417
@bethg2417 - 18.01.2021 22:14

Try this... Office365Users.SearchUser({searchTerm:ComboBox1.SearchText, top:999})

Ответить