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
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
Thank you for your video! I already have a people field from my sharepoint list, when I click the box it is showing the list of people for user to choose and it is searchable as well, however if I want it to not show the full list unless user type to search that specific person, (in your video 16:41) how to do that? my current people field item property is: Choices([@'List'].Requestedby) Thanks you very much
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?
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.
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.
Great video. Reza, I get a ‘inject0’ and numbers on a dropdown in a datacard from a people field of a sharepoint list that l can get people from my organization. How can I get to show the name of the person and for the user to be able to search the organization’s users?
@@RezaDorrani Is it possible inside the datacard to add a text input field that shows the current value of selected record in view mode, and if I want to edit, it looks for people from my organization? I'm able to be able to look for people. I just can't get it to get it to store when I submit the form.
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.
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.
i am unable to solve one thing related to search User or Group, when i use edit form control and in there if i have any field that is set to "People or group" then onselect i am getting some number to choose from and not search option even when search is on. when i try to see what does it show when i insert the value manually in sharepoint list for perticular record then that shows as "INJECT0" instead of username in power app. how to deal with that. i feel only you can make it possible. need your help understanding how to resolve that - all your videos did not gave me that answer.
I have no clue about this. I will recommend checking or posting your issue on forums in case someone has experienced something similar community.powerplatform.com
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...
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 😅
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.
Hey @reza, thanks for this. Could you help me when using sharepoint forms to save to a list. How to build the formula for the update back to the list once the person is picked. I have retried everything I know to get it to work and the only none error formula - does not save the person picked???
I have not come experienced this 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
@@RezaDorrani thanks....I've used a combo box, linked to office365 users, in the update. I've got combobox1.selected and nothing else. Because everything I try shows the error line. I think it should be displayname. But that errors. Tried .text, result value etc. I will post see if I get a answer via the forum
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.
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.
Dear Reza, I have query, I am trying to save people picker column using Form Preview version, the people picker column value is not getting saved but other columns are saved. i used default combobox but person names were not showing so I went to items added the below "Office365Users.SearchUserV2( { searchTerm: Trim(Self.SearchText), isSearchTermRequired: false, top:20 } ).value" after doing this i am able get user name but the data is not getting saved. would you please tell me what went wrong for only people picker column is not getting saved.
@@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
@@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
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?
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?
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
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.
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/
Hi Reza , Great content ! Can you please specify what should be the update and default value for combo box as person field. I am facing an issue when the form is updated the field becomes blank . Thankyou In advance for your help !
@ Great! Thankyou for the information! But it would be great if there is a possibility of sharing the formula only for update and default property only as it is urgent . I have used a text column and then combo box on the text column to use it as person field . When using the customized form, the value disappears after any modification in the item.
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.
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.
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.
Thanks Reza! I do have one problem with using Office Groups though. I choose a person and on submit of the form, I get empty field in my MS List. any idea how to solve this?
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani thanks for prompt response. I have asked chatGPT and its suggested solution worked. Sharing, maybe someone will benefit. :) chat recommended to change the 'Update' property on DataCard (combobox parent) to: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & DataCardValue1.Selected.mail, DisplayName: DataCardValue1.Selected.displayName, Email: DataCardValue1.Selected.mail }
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?
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
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
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.
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/
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?
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?
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?
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!
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
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
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?
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
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?
Hi Reza, Great video and your videos are always on point. However, I'm trying to populate a field in a form. The column type is "Person" on SharePoint. But when i connect the form on PowerApps to the SharePoint list expecting to load the names or persons on Active Directory to pick from, i get numbers instead, presumably id for users on AD. I tried the combo box option which loaded the names to PowerApps but it doesn't log the name on the SharePoint list when the form is submitted.
@@RezaDorrani Not combo box, a form. I want to be able to pick users from AD in the form control. I have a column in SharePoint with data type Person that I want to be able to load users from AD and be able to select a user right in the form
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?
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?
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.
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?
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?
@@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/
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 RUclips channel - click on Join button
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?
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?
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.
@@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.
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 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.)
@@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.
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!
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! :)
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
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
I have error: Filter( AddColumns( Office365Users.SearchUserV2({searchTerm: Trim(Self.SearchText), isSearchTermRequired: false}).value, "UserData", ThisRecord.DisplayName & " (" & Coalesce(ThisRecord.Department, "N/A") & ")" ), AccountEnabled = true && !("EXT" in UserPrincipalName) ) "UserData" there is error in this formula... Expected identifier name
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Clear and precise! No BS, no lame jokes, no annoying sounds. Earned a subscriber right away, Sir. Great job!
Thanks so much. I try to get straight to the point :)
Thank you 🙏, @reza, for sharing another valuable video on Power Apps. This will certainly benefit us the Power Platform Community .
Awesome!
Great Content. I was looking for this just to understand the concept. Thanks as always 🙏🏽
Most welcome
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
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
Great encouraging video, Reza! I am trying to build my first app to visualize the Teams presence status of favorite people in my organization.
Thanks
Great content!! This helped me a lot. Thanks for sharing. Liked and subscribed
Awesome, thank you!
Thank you for your video!
I already have a people field from my sharepoint list, when I click the box it is showing the list of people for user to choose and it is searchable as well, however if I want it to not show the full list unless user type to search that specific person, (in your video 16:41) how to do that? my current people field item property is:
Choices([@'List'].Requestedby)
Thanks you very much
I'm not sure of the steps needed to not load initial users until user types.
Reza u are the best! Thanks from Argentina
Thank You Fernando
Thanks - exactly what I was looking for!!!
Glad I could help!
I love the emoji option that you showed!! No more Icon..thanks.
Thanks for take your time for teach us about power apps, i know if i have a problem you have the answer, thanks ..😊
Most welcome
I'm not sure when or if it changed but the AddColumns function doesn't allow quotes for the column name. Took me a while to figure out the error.
I think this change came 6 months or so ago
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?
That’s a combo box feature for searching.
hi reza, for using the people picker from template, how do i patch into list in microsoft list?
Watch my latest video on person type column. It includes the key syntax which can be used for patching as well.
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.
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.
Great video. Reza, I get a ‘inject0’ and numbers on a dropdown in a datacard from a people field of a sharepoint list that l can get people from my organization. How can I get to show the name of the person and for the user to be able to search the organization’s users?
It's a known limitation currently. That's why I did not cover it in the video.
@@RezaDorrani Is it possible inside the datacard to add a text input field that shows the current value of selected record in view mode, and if I want to edit, it looks for people from my organization? I'm able to be able to look for people. I just can't get it to get it to store when I submit the form.
@JoseLopesMoreno For now my suggestion would be to use the classic combo box control just for that part.
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.
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.
i am unable to solve one thing related to search User or Group, when i use edit form control and in there if i have any field that is set to "People or group" then onselect i am getting some number to choose from and not search option even when search is on. when i try to see what does it show when i insert the value manually in sharepoint list for perticular record then that shows as "INJECT0" instead of username in power app. how to deal with that. i feel only you can make it possible.
need your help understanding how to resolve that - all your videos did not gave me that answer.
Do not use modern combo box for person picker. I call that out in the video.
Im using the people picker via SharePoint, the profile image shows in the web version but the ios app shows a blue square with a ?, any ideas?
I have no clue about this. I will recommend checking or posting your issue on forums in case someone has experienced something similar
community.powerplatform.com
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...
Not sure why it would not work
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 😅
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.
Your on the right track
Hey @reza, thanks for this. Could you help me when using sharepoint forms to save to a list. How to build the formula for the update back to the list once the person is picked. I have retried everything I know to get it to work and the only none error formula - does not save the person picked???
I have not come experienced this 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
@@RezaDorrani thanks....I've used a combo box, linked to office365 users, in the update. I've got combobox1.selected and nothing else. Because everything I try shows the error line. I think it should be displayname. But that errors. Tried .text, result value etc.
I will post see if I get a answer via the forum
Hello again! Great video
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.
How would you use the Image property of the Person combobox to display the persons picture from the Office 365 datasource. Its greyed out?
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.
Dear Reza, I have query, I am trying to save people picker column using Form Preview version, the people picker column value is not getting saved but other columns are saved. i used default combobox but person names were not showing so I went to items added the below "Office365Users.SearchUserV2(
{
searchTerm: Trim(Self.SearchText),
isSearchTermRequired: false,
top:20
}
).value" after doing this i am able get user name but the data is not getting saved. would you please tell me what went wrong for only people picker column is not getting saved.
Person column schema is unique. ruclips.net/video/g9ChYuTdNd4/видео.html
Perfect!!! Thanks for sharing this.
Most welcome
How do I send the result to the excel list for the record?
Does it need too be inside a control card?
Excel list?
@@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
@@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
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?
Thanks!
Dont have office ids? Then how are they signing into power apps?
For example, factory workers who don't have a UserID, but could be nominated for recognition.@@RezaDorrani
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?
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
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.
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/
Hi Reza ,
Great content ! Can you please specify what should be the update and default value for combo box as person field.
I am facing an issue when the form is updated the field becomes blank .
Thankyou In advance for your help !
I have a video coming in 2 weeks.
Cannot describe here on chat as it would be a long process
@ Great! Thankyou for the information!
But it would be great if there is a possibility of sharing the formula only for update and default property only as it is urgent .
I have used a text column and then combo box on the text column to use it as person field . When using the customized form, the value disappears after any modification in the item.
I don't have it handy and currently traveling. I would suggest posting your query on forums
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.
The first option is a template. It has logic that does that. Click on onselect of gallery and other properties to see the code.
@Reza Can you use the Office235 Connector to only search for certain user in tenant within a specific department? Say all of HR?
Check documentation learn.microsoft.com/en-us/connectors/office365users/#search-for-users-(v2)
Department is not an option.
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.
Nice but this video is not just about Dataverse + why would one create a to limit user selection?
@@RezaDorrani I limited the selection to only show the users in our organization
@@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
@@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
@@DataisKing ok but would not be an option for large user bases which is normally the case.
Hi Reza, amazing video. Do you have a video for people picker in modern combo box?
Thanks!
Modern combo box currently does not support people picker option.
I have diffrent buttons for diffrent department i need to validate buttons based on users department and combined one user for multiple department
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.
Thanks Reza! I do have one problem with using Office Groups though. I choose a person and on submit of the form, I get empty field in my MS List. any idea how to solve this?
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@@RezaDorrani thanks for prompt response.
I have asked chatGPT and its suggested solution worked. Sharing, maybe someone will benefit. :)
chat recommended to change the 'Update' property on DataCard (combobox parent) to:
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & DataCardValue1.Selected.mail,
DisplayName: DataCardValue1.Selected.displayName,
Email: DataCardValue1.Selected.mail
}
Thanks for sharing
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?
You need to search for users. It will not list all users.
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
@@MichaelDeBlasis1369 Thats default behavior
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
Because this code is querying the office365users api and not the choices function
Do you know if any of these works on modern apps? I select the user but it soon disappears from the box
I just read Igas comment below.. That might work
Use classic combo box
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.
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/
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?
The reason I did not show modern combo box in this video is because currently it’s not best suited for person picker control
Nevermind... see in previous replies modern combo box doesn't work... maybe MS will fix it eventually.... work in progress...
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?
Check documentation on modern combo box.
That may very well be the limit.
Hey Reza, is there a way to exclude current user in Approvers column basically a people picker column
No but you can write some additional logic to not allow user to submit form if they pick themselves as approver
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?
I have a video planned on 2 lists connected with lookup column and showing repeating table like experience.
Hi Reza, love your videos! How would you pre-populate a people picker with the current user on a PowerApp list form?
Thanks!
I did a video on default values in power apps. Check that one.
Thank you! It was very helpful!
You're welcome!
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!
It can only return 999 users after performing search. No way around that limit.
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
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
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?
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
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?
Hi Reza, Great video and your videos are always on point. However, I'm trying to populate a field in a form. The column type is "Person" on SharePoint. But when i connect the form on PowerApps to the SharePoint list expecting to load the names or persons on Active Directory to pick from, i get numbers instead, presumably id for users on AD. I tried the combo box option which loaded the names to PowerApps but it doesn't log the name on the SharePoint list when the form is submitted.
Are you using modern combo box? Currently, it does not support person type column.
@@RezaDorrani Not combo box, a form. I want to be able to pick users from AD in the form control. I have a column in SharePoint with data type Person that I want to be able to load users from AD and be able to select a user right in the form
And yes I'm using modern form
@@gbemigaodunigba6365 Person column is not supported. Modern form is in preview.
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?
When connected to a group, it does not list the values. It is by design. Flow would be the way.
Hi Reza, how can I get Jobtitle from person I choose from combo box?
Combobox.Selected. Should give you the properties
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?
You dont need to build any custom user table. The AAD users table shown in video has all the users.
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.
Modern is limited in terms of searching for a combo box. Hence I used classic.
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.
@@HaiNguyenMD Thats why I did not use it :)
Hi Reza, great video :) , I am now following your videos regarding modern controls, can we adapt this also for this ones?
Currently, modern controls dont work for person picker
So is there a way around it
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?
1 - Yes but there is no template for that.
2 - Possible
3 - Check my videos on responsive design
Pls How to set auto fillter current user use app on gallerly
Not sure I understand your question. If its filter based on current user - I have done videos on it. Look through my video list.
Is it possible to filter users according to the business unit? how would I do that?
Not sure if thats an option. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani THX so much!
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?
Question is what type of column is fieldname.
Also Selected.Value
S and V are caps as far as I can remember
fieldname is a text field and yes in syntax Selected and Value were capitalized@@RezaDorrani
@@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/
Great video, thank you
Glad you liked it!
Hi Reza I am looking to start learn powerapps session but I am little confused of order of your session could you please suggest
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 RUclips channel - click on Join button
how to filter Security Groups from search ? when searching I can see many security groups are showing
Depends on which option you chose.
The first one is user based search.
How to submit to sharepoint multiselect person column field?
I do not have a specific video reference on that. I will recommend posting your query on forums at
community.powerplatform.com/
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?
Yes, hence I did not show people picker with modern controls
@@RezaDorrani Good to know and I'm not wasting time on this feature. Thank you
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?
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.
@@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.
@@FOzcan I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Thanks Reza, I created two post in the microsoft community.
@@FOzcan good luck
Thank you Mr Raza, but I can't seem to find the column
Which column? And where?
Is there a way to create a people picker with the new modern combobox control?
Currently, No
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.
Most welcome!
I am not sure about multi-org scenario.
@@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.)
@@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.
I will recommend posting your query/issue on forums at powerusers.microsoft.com/
@@RezaDorrani Thanks for sharing this.
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!
Most welcome!
It must be somewhere in MSFT documentation. I am not aware of the reference link.
Thanks Reza!
Welcome
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! :)
The filter function is performed after the search results are returned (which is a max of 999)
Is there any possibility to search an email group?
May be via graph api
❤❤ Nice
Thanks
It's easy to make people picker in new form but in edit it fails for multiple selection
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
@@RezaDorrani i mean can you make custom multiple select people picker which auto populate selection in edit mode
@@malikhan0123 Possible but I do not have a specific video reference on that scenario
Combobox Data options have changed, no options for layout. 🤬🤬
Depends if you are using classic or modern controls
@@RezaDorrani Thanks. Seems like a backwards step from Microsoft though.
@@MrBond249 Modern combo box is in preview from what I know of.
Can you use the Office235 Connector to only search for certain user in tenant within a specific department? Say all of HR?
Check documentation learn.microsoft.com/en-us/connectors/office365users/#search-for-users-(v2)
Department is not an option.
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
Why dont you use the AADUser table then?
🐐🐐🐐🐐🐐🐐🐐
Thanks so much
I have error:
Filter(
AddColumns(
Office365Users.SearchUserV2({searchTerm: Trim(Self.SearchText), isSearchTermRequired: false}).value,
"UserData",
ThisRecord.DisplayName & " (" & Coalesce(ThisRecord.Department, "N/A") & ")"
),
AccountEnabled = true && !("EXT" in UserPrincipalName)
)
"UserData" there is error in this formula...
Expected identifier name
I have not experienced the mentioned issue and hence not sure what the cause for it could be.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Great vídeo, thank you!
Thanks Paulo