hi,
i have created a edit form with Dropdown (as a list of user from person or group field from Sharepoint List).
i have selected a user in the dropdown and i have updated coding in UPDATE Field in PowerApps as below:
{Value: DataCardValue14.SelectedItems}
then i press submit button, the result is new record created but Person or Field cell is empty.
then i have changed UPDATED coding as below:
{Value:Table({
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
DisplayName:DataCardValue14_1.Selected.DisplayName,
Claims:"i:0#.f|membership|" & Lower(DataCardValue14_1.Selected.Email),
Department:"",
Email:DataCardValue14_1.Selected.Email,
JobTitle:"",
Picture:""
})}
also i have below code in Dropdown.items field:
Choices([@Disciplinary_Irregularities_Report].Reporting_Person)
BUT The RESULT IS SAME, NEW record created with empty Person or Group data.
Please help me to resolve this issue:
Asan
Solved! Go to Solution.
Hi @AsanKani ,
Could you please share more details about your scenario? What is the Item property of the Edit Form? Is the Person Data Card inserted via “Edit fields” of the Form?
As per you mentioned Update property of the Data Card is DataCardValue14.SelectedItems, I assume that it is a Combo box in a Data Card which you inserted via Edit fields of the Form. Then the point you need to check is whether you have set the Person or Group column allow multiple selections:
If yes, the Update of the Data Card would be:
DataCardValue14.SelectedItems
If Person column not allow multiple selections, the Update would be:
DataCardValue14.Selected
Since you would like to use Office365Users.SearchUsers() in the Dropdown, you will have to:
1. Set Items of the Dropdown to:
Office365Users.SearchUser()
2. Set Update of the Data Card to:
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
DisplayName:DataCardValue14_1.Selected.DisplayName,
Claims:"i:0#.f|membership|" & Lower(DataCardValue14_1.Selected.Mail),
Department:"",
Email:DataCardValue14_1.Selected.Mail,
JobTitle:"",
Picture:""
}
In SP list, values in Person or Group type columns allow single selection are RECORDs with fields in my above formula, so you need to update the record value to the list in same structure.
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Is the drop-down a custom field or is it people picker field from the SharePoint list.
I have used Dropdown field with Office365Users.SearchUsers(). Not using people picker from the SharePoint list.
I have tired two types.
one dropdown & another one combo box. BUT Result IS SAME - NEW record created with empty Person or Group data
Hi @AsanKani ,
Could you please share more details about your scenario? What is the Item property of the Edit Form? Is the Person Data Card inserted via “Edit fields” of the Form?
As per you mentioned Update property of the Data Card is DataCardValue14.SelectedItems, I assume that it is a Combo box in a Data Card which you inserted via Edit fields of the Form. Then the point you need to check is whether you have set the Person or Group column allow multiple selections:
If yes, the Update of the Data Card would be:
DataCardValue14.SelectedItems
If Person column not allow multiple selections, the Update would be:
DataCardValue14.Selected
Since you would like to use Office365Users.SearchUsers() in the Dropdown, you will have to:
1. Set Items of the Dropdown to:
Office365Users.SearchUser()
2. Set Update of the Data Card to:
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
DisplayName:DataCardValue14_1.Selected.DisplayName,
Claims:"i:0#.f|membership|" & Lower(DataCardValue14_1.Selected.Mail),
Department:"",
Email:DataCardValue14_1.Selected.Mail,
JobTitle:"",
Picture:""
}
In SP list, values in Person or Group type columns allow single selection are RECORDs with fields in my above formula, so you need to update the record value to the list in same structure.
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Sorry i did not ask you this earlier.
Is your dropdown field within the form datacard or outside of the form.
And which field are you seeing as empty when the form is saved?
Can you take a screen shot if possible?
Hi,
I'm trying to use Person or Group column on my Sharepoint List. When I submit my Form the column is blank on my SP list. I want to use Multiple selection and want the items selected by default in edit mode.
I don't know what you mean by below. Can elaborate what do you mean by values in Person or group?
"In SP list, values in Person or Group type columns allow single selection are RECORDs with fields in my above formula, so you need to update the record value to the list in same structure. "
My SP column is set as below.
Can help me?. I have created a new post too. https://powerusers.microsoft.com/t5/Building-Power-Apps/SharePoint-Person-or-Group-column-showing-em...
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
253 | |
122 | |
84 | |
84 | |
67 |