cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AsanKani
Skilled Sharer
Skilled Sharer

PowerApp Edit Form with Person or Group field not working

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

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.

View solution in original post

6 REPLIES 6
joeinmay
Resolver II
Resolver II

Is the drop-down a custom field or is it people picker field from the SharePoint list.

AsanKani
Skilled Sharer
Skilled Sharer

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 

v-jefferni
Community Support
Community Support

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?

AsanKani
Skilled Sharer
Skilled Sharer

Thank you for your support, @v-jefferni. and @joeinmay  Now resolved.

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. 

indhaa_0-1626721594257.png

 

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

 

 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,101)