cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

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

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.

View solution in original post

5 REPLIES 5
Helper II
Helper II

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

Regular Visitor

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 

Microsoft
Microsoft

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.

View solution in original post

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?

Regular Visitor

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

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (9,121)