How to build People Picker in Power Apps with Office 365 Users Search and more!

  Рет қаралды 70,188

Reza Dorrani

Reza Dorrani

Күн бұрын

In this video, you will learn how to build a People Picker in Power Apps. I will showcase 5 different methods to create the People Picker experience that suits your specific needs within Power Apps.
We'll dive into the PowerApps Office 365 Users connector and leverage the Search User V2 function, exploring its capabilities to retrieve users from your Office 365 tenant. Whether you need to search for internal users, guest users, or filter by departments, this tutorial has you covered.
But that's not all - we'll also explore building person picker using data sources such as Dataverse and SharePoint, including targeting SharePoint Groups. We will be working with the combo box control to create the people picker experience and connecting it with Office365Users, Office365Groups and data sources.
🖥️ Learn five different methods to build your own People Picker:
🔹 Screen Templates
🔹 Office 365 Users Connector and combo box
🔹 Office 365 Groups Connectors and combo box
🔹 Creator Kit Person Picker Control
🔹 Data Sources like Dataverse & SharePoint, including targeting SharePoint Groups.
If you're looking to elevate your Power Apps skills and create a powerful People Picker control, this video has you covered. So, let's get started on your journey to building a People Picker experience in Power Apps!
⬇️ Download sample Power App showcased in the video:
Exclusive for Channel Members (Silver 🥈 & Gold 🥇 Club)
Find the download link in the Community Tab for Members.
To become a member, click here: kzfaq.infojoin
#PowerApps #PowerPlatform #Office365 #Dataverse #SharePoint
Table of Contents:
00:00 - Introduction to building People Picker experiences in Power Apps
00:40 - People Screen Template in PowerApps
05:04 - Pick users from AD in Power Apps and send email
06:09 - Build your own People Picker using Combo box & Office 365 Users Connector
13:06 - Search Users from Office 365 Groups
14:55 - Build Power Apps People Picker from a data source (SharePoint list or Dataverse AAD User Table)
18:57 - Creator Kit (PeoplePicker Control)
20:50 - READY to subscribe to Reza Dorrani’s channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani

Пікірлер: 172
@ericmild4050
@ericmild4050 2 ай бұрын
I love the emoji option that you showed!! No more Icon..thanks.
@empirikal09
@empirikal09 9 ай бұрын
Clear and precise! No BS, no lame jokes, no annoying sounds. Earned a subscriber right away, Sir. Great job!
@RezaDorrani
@RezaDorrani 9 ай бұрын
Thanks so much. I try to get straight to the point :)
@hamytube
@hamytube 10 ай бұрын
Thank you 🙏, @reza, for sharing another valuable video on Power Apps. This will certainly benefit us the Power Platform Community .
@RezaDorrani
@RezaDorrani 10 ай бұрын
Awesome!
@ThomasSnoeks
@ThomasSnoeks 10 ай бұрын
Great encouraging video, Reza! I am trying to build my first app to visualize the Teams presence status of favorite people in my organization.
@RezaDorrani
@RezaDorrani 10 ай бұрын
Thanks
@fernandogomezmartirena856
@fernandogomezmartirena856 8 ай бұрын
Reza u are the best! Thanks from Argentina
@RezaDorrani
@RezaDorrani 8 ай бұрын
Thank You Fernando
@profglac
@profglac 8 ай бұрын
Perfect!!! Thanks for sharing this.
@RezaDorrani
@RezaDorrani 8 ай бұрын
Most welcome
@violettabybina6996
@violettabybina6996 2 ай бұрын
Thank you! It was very helpful!
@RezaDorrani
@RezaDorrani 2 ай бұрын
You're welcome!
@anantchirmade600
@anantchirmade600 10 ай бұрын
Great video, thank you
@RezaDorrani
@RezaDorrani 10 ай бұрын
Glad you liked it!
@denisskorikov6234
@denisskorikov6234 10 ай бұрын
Wow! I didn't know about that code component! It would be a very interesting video if you could should top-"x" code components which might be used for different scenarios.
@RezaDorrani
@RezaDorrani 10 ай бұрын
Thanks! I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@katherineparramontoya9327
@katherineparramontoya9327 8 ай бұрын
Thanks for take your time for teach us about power apps, i know if i have a problem you have the answer, thanks ..😊
@RezaDorrani
@RezaDorrani 8 ай бұрын
Most welcome
@user-eo7yx2kw4c
@user-eo7yx2kw4c 6 ай бұрын
Thanks Reza!
@RezaDorrani
@RezaDorrani 6 ай бұрын
Welcome
@sateesh123456
@sateesh123456 10 ай бұрын
Hey Reza, great video! Can you do a video on repeating tables for powerapps like we have repeating section in Infopath where we can add multiple entries for a child list while creating a request in parent list?
@RezaDorrani
@RezaDorrani 10 ай бұрын
I have a video planned on 2 lists connected with lookup column and showing repeating table like experience.
@BrunoSantos-jk6xu
@BrunoSantos-jk6xu 8 ай бұрын
Hi Reza, great video :) , I am now following your videos regarding modern controls, can we adapt this also for this ones?
@RezaDorrani
@RezaDorrani 8 ай бұрын
Currently, modern controls dont work for person picker
@bobbyw1074
@bobbyw1074 10 ай бұрын
Thanks for another great vid Reza! Since my org is huge, would it be a better idea to just build a custom user table in dataverse and search though this versus searching through Active directory?
@RezaDorrani
@RezaDorrani 10 ай бұрын
You dont need to build any custom user table. The AAD users table shown in video has all the users.
@user-ui9we9hn6k
@user-ui9we9hn6k 10 ай бұрын
Hey, Risa! Great video once again. I just noticed that you used the classic ComboBox here to search or show or current users. Are these not available in the modern controls? The new modern controls are really good now aesthetically but it feels that they are so limited compared to the classic ones.
@RezaDorrani
@RezaDorrani 10 ай бұрын
Modern is limited in terms of searching for a combo box. Hence I used classic.
@HaiNguyenMD
@HaiNguyenMD 9 ай бұрын
I tried with the modern control combo box but it only show a sort list of users. Doesn’t allow for true searching. Too bad.
@RezaDorrani
@RezaDorrani 9 ай бұрын
@@HaiNguyenMD Thats why I did not use it :)
@jamesanderson7346
@jamesanderson7346 10 ай бұрын
Thanks, Reza. Have been looking for something like this for a while. Very helpful. In Form with a SharePoint data source I have an AssignedTo field that is a SharePoint person/Group field. In the form control, when I change the Items to only show members of an O365 Group, I can no longer get ThisItem.AssignedTo to display in the control when the field is already populated. Any idea what is happening there? Also, info on the same filtering for SharePoint permission groups would be helpful. Thank you.
@RezaDorrani
@RezaDorrani 10 ай бұрын
When working in form context, SharePoint person column has a specific schema that exists. rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
@olisaemekaaghabuilo8688
@olisaemekaaghabuilo8688 10 ай бұрын
❤❤ Nice
@RezaDorrani
@RezaDorrani 10 ай бұрын
Thanks
@kutyafal
@kutyafal 2 ай бұрын
Hi Reza, love your videos! How would you pre-populate a people picker with the current user on a PowerApp list form?
@RezaDorrani
@RezaDorrani 2 ай бұрын
Thanks! I did a video on default values in power apps. Check that one.
@davidclay717
@davidclay717 9 ай бұрын
Questions for you Reza, 1) Can one put the People Screen Template into a Container? 2) Can you create two separate SearchTextBoxes and galleries doing the same thing but populating 2 Collections inorder to populate 2 different list fields in SP and 3) What the best way to do a responsive form, using a Form Screen template or with in a Container?
@RezaDorrani
@RezaDorrani 9 ай бұрын
1 - Yes but there is no template for that. 2 - Possible 3 - Check my videos on responsive design
@anthonyanyoti
@anthonyanyoti 3 ай бұрын
Hi Reza,awesome video as always,thank you! Having issues with the modern combo box which limits results to only 30 users, how do I go about increasing the limit?
@RezaDorrani
@RezaDorrani 3 ай бұрын
Check documentation on modern combo box. That may very well be the limit.
@twangt
@twangt 10 ай бұрын
Great video as always Reza! I have a question. Currently, I'm using a gallery that filters based on search criteria, as well as a combo box dropdown that filters by department. The issue I'm facing is that when I select a department from the combo box, it only returns 29 users of that department in the gallery. However, I know that there are 70 users in that department, and 700 internal users overall. I've set the "searchTerm" to 999, among other things. Do you have any idea what could be causing this? Thanks again for the great content! :)
@RezaDorrani
@RezaDorrani 10 ай бұрын
The filter function is performed after the search results are returned (which is a max of 999)
@PsYc87
@PsYc87 5 ай бұрын
Hi Reza, Once again another great video. I'm now using the modern controls features. I can't seem to get my the same function working on the new modern controls combobox. Have you had issues with people picker options using the modern controls?
@RezaDorrani
@RezaDorrani 5 ай бұрын
Yes, hence I did not show people picker with modern controls
@PsYc87
@PsYc87 5 ай бұрын
@@RezaDorrani Good to know and I'm not wasting time on this feature. Thank you
@celinegebara5010
@celinegebara5010 10 ай бұрын
Great video Reza. For option 3, how would I patch this combobox to a Sharepoint person field? Isn't the O365groups data structure different than the Person field? I am struggling to achieve this, I think the Claims is what is missing.
@RezaDorrani
@RezaDorrani 10 ай бұрын
Thanks! Structure would be different. If you want to make it easy, then option 4 (with form control) is easiest. If you want to choose option 3, then you would need to put it in a format that person column expects. Here is the blog I wrote about the structure of person column - rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
@Isaiah.43.4
@Isaiah.43.4 3 ай бұрын
Hello again! Great video
@RezaDorrani
@RezaDorrani 3 ай бұрын
Modern combobox currently does not support person type column. Hence I did not show it in video. I have a video coming next week where I show how to swap just the modern form data card for person column with classic.
@user-ne7is8mi3r
@user-ne7is8mi3r 7 ай бұрын
Great video as always. One question though, how to show the values without typing anything if i use the sharepoint list solution with only allow selection from a target sharepoint group. so far want i know is to use power automate flow to trigger http request to pre load the values as a variable. Any other suggestions?
@RezaDorrani
@RezaDorrani 7 ай бұрын
When connected to a group, it does not list the values. It is by design. Flow would be the way.
@afasbender
@afasbender Ай бұрын
Hi Reza, great and very educative video as always! 💚 A question: Do you know where I can find the German conventions/names of operators and functions? (e.g. AccountEnabled and UserPrinciopalName are not found...) Is there some sort of directory or a way to translate the english ones? Thanks in advance!
@RezaDorrani
@RezaDorrani Ай бұрын
Most welcome! It must be somewhere in MSFT documentation. I am not aware of the reference link.
@desipher
@desipher 4 ай бұрын
First off- - Great video, thank you! I have a question though: Why do I get errors when I try to set up a combo box with allow searching? If i disable allow searching the error goes away. The error isn't very helpful and seems tied to the 'DisplayFields' property of the combobox control. The error says "Unexpected characters. The Formula contains 'Eof' where 'ParenClose' is expected." Thanks
@RezaDorrani
@RezaDorrani 4 ай бұрын
Thanks! I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@ScottMembry
@ScottMembry 3 ай бұрын
Love your videos, first up. I have a situation where some users who need to go on the form don't have Office IDs. I want them to still be able to type their names on the people picker, but it deletes their name on Submit. Any idea how I could do this?
@RezaDorrani
@RezaDorrani 3 ай бұрын
Thanks! Dont have office ids? Then how are they signing into power apps?
@ScottMembry
@ScottMembry 3 ай бұрын
For example, factory workers who don't have a UserID, but could be nominated for recognition.@@RezaDorrani
@qoryhanisagal
@qoryhanisagal 4 ай бұрын
@Reza Can you use the Office235 Connector to only search for certain user in tenant within a specific department? Say all of HR?
@RezaDorrani
@RezaDorrani 4 ай бұрын
Check documentation learn.microsoft.com/en-us/connectors/office365users/#search-for-users-(v2) Department is not an option.
@thanujar9548
@thanujar9548 4 ай бұрын
Hey Reza, is there a way to exclude current user in Approvers column basically a people picker column
@RezaDorrani
@RezaDorrani 4 ай бұрын
No but you can write some additional logic to not allow user to submit form if they pick themselves as approver
@aamiuk1
@aamiuk1 9 ай бұрын
Hi Reza - i hope you are doing well - quick query with regard to Multi Select Combo Box Person Type which is setup using 0365 connector and search via the text typed in Combo box. I'm facing issues when we are have bulk uplod data in the backend SharePoint list and then try to update the same via power app through patch - it gives me a network error - while troubleshooting it came to my attention that the values that were bulk uploaded are blank while patching for some reason and it gives me the error. Note: if the item is created and edited via power app it behave normally only for those data that have been bulk uploaded using edit in grid view in the SP list
@RezaDorrani
@RezaDorrani 9 ай бұрын
Depends upon what technique you are using for bulk uploading. I don’t think this is something I have tried or have a video reference for. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@meenufsts
@meenufsts Ай бұрын
Thanks much Reza. The video helped me and solved my app issue. In my Office365, there is more than one organization involved. Is it feasible to auto populate the person name in the Inspector Column(Person type) who is adding the record or filling the form.
@RezaDorrani
@RezaDorrani Ай бұрын
Most welcome! I am not sure about multi-org scenario.
@meenufsts
@meenufsts Ай бұрын
​@@RezaDorrani I tried to solve it. Table({Cliams:"i:0#.f|membership|" & User().Email, DisplayName: User().FullName, Email:User().Email}) The above formula is working for me to populate User Name for Person type field/column(Inspector). There are two issues with the code - 1. Inspector name is not reflecting in my SharePoint list for records added/submitted. 2. In Power apps records history, records User name is keep changing to the person who is using the app for old records also. (For example - I created one test record and another test record is created by my Boss. And both the old records on power app showing my name when I am checking old records and on my Boss end it is showing his name for both old records added.)
@meenufsts
@meenufsts Ай бұрын
@@RezaDorrani Thanks for helping Reza! I need help - how to auto populate user name (in person field/column) named as Inspector. Table({Claims:"i:0#.f|membership|" & User().Email, DisplayName: User().FullName, Email:User().Email}) The above formula is working for me to populate User Name for Person type field/column(Inspector). There are two issues with the code - 1. Inspector name is not reflecting in my SharePoint list for records added/submitted. 2. In Power apps records history, records User name is keep changing to the person who is using the app for old records also. (For example - I created one test record and another test record is created by my Boss. And both the old records on power app showing my name when I am checking old records and on my Boss end it is showing his name for both old records added.) AND I tried another way - { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", DisplayName: User().FullName, Claims: "i:0#.f|membership|" & User().Email, Email: User().Email } It is showing Inspector name in my SharePoint list however in the records for Test Record it is showing claims code in submitted record. I need help to make change into the code from Azure to Office365Users or Outlook(Office365Outlook) and to solve the error.
@RezaDorrani
@RezaDorrani Ай бұрын
I will recommend posting your query/issue on forums at powerusers.microsoft.com/
@meenufsts
@meenufsts Ай бұрын
@@RezaDorrani Thanks for sharing this.
@jomarismeneses3765
@jomarismeneses3765 4 ай бұрын
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!
@RezaDorrani
@RezaDorrani 4 ай бұрын
It can only return 999 users after performing search. No way around that limit.
@tvenkatesh81
@tvenkatesh81 7 ай бұрын
Hey reza, for the first option where are you saying How to add the people to the collection once the email id is found in the Active directory or the O365 connector ? i cannot get it. Please clarify.
@RezaDorrani
@RezaDorrani 7 ай бұрын
The first option is a template. It has logic that does that. Click on onselect of gallery and other properties to see the code.
@Ed-Salinas
@Ed-Salinas 5 ай бұрын
Pretty close to what I needed. I tried to set up a People Picker Combo box to choose from a Group created in sharepoint list as described in the video (and based on some search results on Google). However, I didn't like that users had to type the person's name, and then I ran into a problem where only the people that were listed in the sharepoint list got vaildated results from that people picker. It was a required field, so every other user not in that sharepoint list received an error that they couldn't submit a record entry because it thought that field was blank. Kept saying that field was required even if not blank. I may move to create an Office 365 Group if I can figure out how to do it without having Office 365 Admin privileges. The behavior of the combo box seems to be more inline with what I want. I'm just afraid that users outside of that Group may still have an issue submitting records with the Power App. Currently the only solution I can think of is to turn off the required button for that column, but that may cause issues further down the line. Anyway, just something I'm working through at the moment.
@RezaDorrani
@RezaDorrani 5 ай бұрын
Your on the right track
@headbobgunpants4858
@headbobgunpants4858 4 ай бұрын
Work well for a SharePoint list, thank you... But why will it not work for a collection..? I have a list with a users column, im trying to make a collection that has the list filtered for items that have a particular value selected from a multi choice lookup column, then use the resulting User column in my combo...
@RezaDorrani
@RezaDorrani 4 ай бұрын
Not sure why it would not work
@headbobgunpants4858
@headbobgunpants4858 4 ай бұрын
Ah sorry, correction: collections do work but people columns don't seem to be people columns any more - the field selection panel does not allow you to configure people columns with picture, first and secondary field and searchable... Never mind. I put in a workaround in validation.. they can search for anyone in the list but if the selected user doesn't have the desired value selected in the multi choice lookup column, validation kicks in when you submit the form.. not great but it works 😅
@W.Wallace73
@W.Wallace73 7 ай бұрын
Great video.... I have a form whose fields come from a SharePoint list, so since the fields are defined with text boxes it is not possible for me to change them or rather I don't know how to change it to a Dropbox and be able to use this search. Any idea?
@RezaDorrani
@RezaDorrani 7 ай бұрын
Thanks! I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@W.Wallace73
@W.Wallace73 7 ай бұрын
Hello @@RezaDorrani. Thank you so much for your support. There is a way to create a people picker using Office365Users and Office365Groups connectors and at the same time add filters. I mean like only enabled and internals accounts and being members of specific group. That make sense to you?
@sriramsivakumar531
@sriramsivakumar531 8 ай бұрын
How do we load / populate People Picker Combo box with emails IDs stored as simple text in Sharepoint list as Default selected items? for both single email IDs and multiple email IDs.
@RezaDorrani
@RezaDorrani 8 ай бұрын
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@DataisKing
@DataisKing 10 ай бұрын
I wanted a drop-down so that I could choose the user from a list. The list was too long to show every user from the dropdown so I created a couple of views in Dataverse and then applied the views to the dropdowns.
@RezaDorrani
@RezaDorrani 10 ай бұрын
Nice but this video is not just about Dataverse + why would one create a to limit user selection?
@DataisKing
@DataisKing 10 ай бұрын
@@RezaDorrani I limited the selection to only show the users in our organization
@RezaDorrani
@RezaDorrani 10 ай бұрын
@@DataisKing But what if org has 5000 internal users.How would that solve the dropdown issue? + in video I do not even use a dropdown
@DataisKing
@DataisKing 10 ай бұрын
@@RezaDorrani I created 2 views a 2 dropdowns based on the users last name. A - L and M - Z. We only would have a maximum of 800 users at one time
@RezaDorrani
@RezaDorrani 10 ай бұрын
@@DataisKing ok but would not be an option for large user bases which is normally the case.
@techdrift73
@techdrift73 8 ай бұрын
How would you use the Image property of the Person combobox to display the persons picture from the Office 365 datasource. Its greyed out?
@RezaDorrani
@RezaDorrani 8 ай бұрын
Image requires the actual image base64 of the user. You would probably have to create a collection which has that info. This is not something I have tried.
@arjumandansari2873
@arjumandansari2873 9 ай бұрын
hi Reza - great video. was able to build the Combo Box with your directions, but when I attempted to connect this to a gallery I get syntax errors. here is my filter condition for the gallery: Filter(SharepointList, FieldName = combobox.selected.value) - i have tried multiple selected.result, in selecteditems.value but not seem to be working. Any thoughts?
@RezaDorrani
@RezaDorrani 9 ай бұрын
Question is what type of column is fieldname. Also Selected.Value S and V are caps as far as I can remember
@arjumandansari2873
@arjumandansari2873 9 ай бұрын
fieldname is a text field and yes in syntax Selected and Value were capitalized@@RezaDorrani
@RezaDorrani
@RezaDorrani 9 ай бұрын
@@arjumandansari2873 Not sure why you would be getting an error for this. I am not able to reproduce it. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
@khaledfwzy32
@khaledfwzy32 10 ай бұрын
I have diffrent buttons for diffrent department i need to validate buttons based on users department and combined one user for multiple department
@RezaDorrani
@RezaDorrani 10 ай бұрын
I do not have a specific video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@JeevanTube
@JeevanTube 4 ай бұрын
When I use a SharePoint list with a People column it gives me suggestions of people (random) in the Power app (@16:15). Is there a way to disable those suggestions/listing of users?
@RezaDorrani
@RezaDorrani 4 ай бұрын
That’s a combo box feature for searching.
@HienVu-kz7mv
@HienVu-kz7mv 3 ай бұрын
Hi Reza, how can I get Jobtitle from person I choose from combo box?
@RezaDorrani
@RezaDorrani 3 ай бұрын
Combobox.Selected. Should give you the properties
@waynepeinke
@waynepeinke 3 ай бұрын
Hi Reza, the Office 365 Users Connector and combo box option doesn't work when you use the new modern combo box. You can pick users when you don't enter any search term but if you add a search term, the filter works but you cannot select a user. It is as if the moment you select the user, the search term disappears, and the item is not there to pick. Have you tried this with the new combo box and can you reproduce the issue?
@RezaDorrani
@RezaDorrani 3 ай бұрын
The reason I did not show modern combo box in this video is because currently it’s not best suited for person picker control
@waynepeinke
@waynepeinke 3 ай бұрын
Nevermind... see in previous replies modern combo box doesn't work... maybe MS will fix it eventually.... work in progress...
@Skd_bear
@Skd_bear 5 ай бұрын
Pls How to set auto fillter current user use app on gallerly
@RezaDorrani
@RezaDorrani 5 ай бұрын
Not sure I understand your question. If its filter based on current user - I have done videos on it. Look through my video list.
@niranjanchekka6079
@niranjanchekka6079 10 ай бұрын
Hi Reza I am looking to start learn powerapps session but I am little confused of order of your session could you please suggest
@RezaDorrani
@RezaDorrani 10 ай бұрын
I make videos on specific topics. I don’t have sessions or ordered lists. I am starting LIVE training (paid) which is step by step. You need to be a channel member of type gold in order to get access to it. To become a member - open web browser - open my KZfaq channel - click on Join button
@hudsonquay
@hudsonquay 8 ай бұрын
Is there a way to create a people picker with the new modern combobox control?
@RezaDorrani
@RezaDorrani 8 ай бұрын
Currently, No
@varunmenon474
@varunmenon474 5 ай бұрын
When I click on the a people picker on my power app tied to a person sharepoint column it gives me a dropdown with random user profile suggestions. How can I stop this and make the field only as a searchable field?
@RezaDorrani
@RezaDorrani 5 ай бұрын
I believe there is some setting for it but do not remember which. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@2007pradipta
@2007pradipta 10 ай бұрын
how to filter Security Groups from search ? when searching I can see many security groups are showing
@RezaDorrani
@RezaDorrani 10 ай бұрын
Depends on which option you chose. The first one is user based search.
@esdrasmarques
@esdrasmarques 8 ай бұрын
Is it possible to filter users according to the business unit? how would I do that?
@RezaDorrani
@RezaDorrani 8 ай бұрын
Not sure if thats an option. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@esdrasmarques
@esdrasmarques 8 ай бұрын
@@RezaDorrani THX so much!
@user-hy2nq7nv8r
@user-hy2nq7nv8r 2 ай бұрын
Thank you Mr Raza, but I can't seem to find the column
@RezaDorrani
@RezaDorrani 2 ай бұрын
Which column? And where?
@ccices01
@ccices01 Ай бұрын
How do I send the result to the excel list for the record? Does it need too be inside a control card?
@RezaDorrani
@RezaDorrani Ай бұрын
Excel list?
@ccices01
@ccices01 Ай бұрын
@@RezaDorrani I built a CRUD app from an excel spreadsheet. It allows me to add a new record and review the contents of the table. I guess I need to associate that people picker result to the correct spot in excel
@RezaDorrani
@RezaDorrani Ай бұрын
@@ccices01 I have not tried with excel and hence not sure about its limitations. I recommend posting your query on forums at powerusers.microsoft.com in case someone has done something similar
@user-qm3uc5df3c
@user-qm3uc5df3c 4 ай бұрын
Is there any possibility to search an email group?
@RezaDorrani
@RezaDorrani 4 ай бұрын
May be via graph api
@MichaelDeBlasis1369
@MichaelDeBlasis1369 2 ай бұрын
I have a combobox linked to a person column and I can only choose from 2 options. Myself, or all other users. How can I set it to show all users separately?
@RezaDorrani
@RezaDorrani 2 ай бұрын
You need to search for users. It will not list all users.
@MichaelDeBlasis1369
@MichaelDeBlasis1369 2 ай бұрын
TY for the quick reply. When I search the only option that will return are myself and everyone except external users. Its set to use Choices(ClaimPro.'Assigned To') @@RezaDorrani
@RezaDorrani
@RezaDorrani 2 ай бұрын
@@MichaelDeBlasis1369 Thats default behavior
@MichaelDeBlasis1369
@MichaelDeBlasis1369 2 ай бұрын
I'm not sure why search wasnt working, but changing the code to this worked. We only have about 10 users so limits of 1k are no issue. Office365Users.SearchUser({searchTerm:"",top:999})@@RezaDorrani
@RezaDorrani
@RezaDorrani 2 ай бұрын
Because this code is querying the office365users api and not the choices function
@FOzcan
@FOzcan 8 ай бұрын
Hi Reza, I created a power app from SharePoint list. There is an user column in sharepoint list and this is converted as user picker in the power apps. I don't have any problem when I submit a new form. I can pick the people and submit. However, I am trying to show user picker result on one label and I couldn't find correct way to this. Can you please help me to do this?
@RezaDorrani
@RezaDorrani 8 ай бұрын
Hi, if there is a user picker, why would that not show the value on form? Why do you need another label. I cannot help here on chat unless I have a video reference on it.
@FOzcan
@FOzcan 8 ай бұрын
@@RezaDorrani thanks Reza , I am creating gallery and I want to show user picker value in this gallery. But it is not showing properly and giving formulas error.
@RezaDorrani
@RezaDorrani 8 ай бұрын
@@FOzcan I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@FOzcan
@FOzcan 8 ай бұрын
@@RezaDorrani Thanks Reza, I created two post in the microsoft community.
@RezaDorrani
@RezaDorrani 8 ай бұрын
@@FOzcan good luck
@malikhan0123
@malikhan0123 10 ай бұрын
It's easy to make people picker in new form but in edit it fails for multiple selection
@RezaDorrani
@RezaDorrani 10 ай бұрын
I have not come across any issues in form scenario and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@malikhan0123
@malikhan0123 10 ай бұрын
@@RezaDorrani i mean can you make custom multiple select people picker which auto populate selection in edit mode
@RezaDorrani
@RezaDorrani 10 ай бұрын
@@malikhan0123 Possible but I do not have a specific video reference on that scenario
@lee161a
@lee161a 5 күн бұрын
I hate this connector, i hate it. I would prefer to use AADuser table or any other method that could use either a service principal or does NOT require the app's userss to additional authenticate a connector
@RezaDorrani
@RezaDorrani 5 күн бұрын
Why dont you use the AADUser table then?
@qoryhanisagal
@qoryhanisagal 4 ай бұрын
Can you use the Office235 Connector to only search for certain user in tenant within a specific department? Say all of HR?
@RezaDorrani
@RezaDorrani 4 ай бұрын
Check documentation learn.microsoft.com/en-us/connectors/office365users/#search-for-users-(v2) Department is not an option.
Power Apps working with SharePoint List Relationships
22:28
Reza Dorrani
Рет қаралды 195 М.
Became invisible for one day!  #funny #wednesday #memes
00:25
Watch Me
Рет қаралды 56 МЛН
Жайдарман | Туған күн 2024 | Алматы
2:22:55
Jaidarman OFFICIAL / JCI
Рет қаралды 1,8 МЛН
50 YouTubers Fight For $1,000,000
41:27
MrBeast
Рет қаралды 75 МЛН
KINDNESS ALWAYS COME BACK
00:59
dednahype
Рет қаралды 144 МЛН
PowerApps Office 365 User Search
25:17
Shane Young
Рет қаралды 129 М.
How To Add People Picker In Your Powerapps
3:28
HelpingAll - Technical
Рет қаралды 213
Power Apps Search and Filter Functions on Large SharePoint Lists
19:41
How to Build a Pretty Power Apps People Picker with Office365 Users
23:54
Power Apps Editable Grid using Gallery & Modern Controls (2023)
23:49
PowerApps: Patch SharePoint Lookup, Person and Choice Fields
8:30
April Dunnam
Рет қаралды 63 М.
МЛАДШАЯ СЕСТРА И МОРОЖЕНОЕ ИЗ АРБУЗА
0:41
ОЛЯ ПЕРЧИК
Рет қаралды 3,2 МЛН
Слепой перехитрил свою жену😳
1:00
Kino_sh
Рет қаралды 12 МЛН
Ай ай 🤣
0:27
Dragon Нургелды 🐉
Рет қаралды 1,3 МЛН
Happy 4th of July 😂
0:12
Pink Shirt Girl
Рет қаралды 61 МЛН
PUT CARDBOARD TOOTHPASTE ALL OVER ONE’S BODY!#asmr
0:40
HAYATAKU はやたく
Рет қаралды 21 МЛН