Answered

People Picker in Form leaves SharePoint list column empty

(0) Share

Report

Posted on by prossberg

I am trying to create entries in a SharePoint list using a combobox within a form in a PowerApp. When I use the default combobox with items set to Choices() it works fine.
owever I want to filter the selectable items for the combobox to a specific group so I used Office365Groups.ListGroupMembers().value.displayName.

This works fine for the combobox itself as it only display the group members I want to be able to be selected. However when I submit the form the person column in the sharepoint list is left empty.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

hey

what are you having in the update property of that datacard? i guess it could be empty, can u check?

Cheers

Was this reply helpful? Yes No
prossberg 16 on at

Like (0)

Report

@mmbr1606 The Update property for the datacard has "DataCardValue.Selected" with DataCardValue being the combobox.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (2)

Report
Hi @prossberg

Coming in here as this is a very common query I see and needs a complete detailed explanation of what has happened and how to address it. Firstly you need to capture both the users email and name, so the Items of the Combo Box would be
Office365Groups.ListGroupMembers().value

and then choose Edit in the right panel and choose displayName in the Primary text and SearchField.

The issue beyond this is that the query connector returns a different schema (field names) to that expected in a Person field, so that needs to be addressed in two places (reading from and writing to the Person field).

Firstly the Data Card Update
{ Claims: "i:0#.f|membership|" & Lower(DataCardValue.Selected.mail), Department: "", DisplayName: DataCardValue.Selected.displayName, Email: DataCardValue.Selected.mail, JobTitle: "", Picture: "" }

and now you also need to capture the essential fields so that the control will save correctly if no changes are made to it - so the DefaultSelectedItems
{ displayName: ThisItem.PersonFieldName.DisplayName, mail: ThisItem.PersonFieldName.Email }

I am assuming that this is a single selection combo box and field.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
prossberg 16 on at

Like (0)

Report

Hi @WarrenBelz

Thanks a lot for your detailed answer. I have a feeling it would solve my problem if not for a another problem coming up.
In the Update field the DataCardValue.Selected.mail is empty. displayName works fine but mail is empty and therefore I get an error about the user not being found. I also tried to see if job title was populated, however that was also left empty.

EDIT: Nevermind, after breifly selecting mail in the in the Edit part before switching back to displayName the connector seems to have refreshed itself and everything is now working.

Was this reply helpful? Yes No