Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

People Picker in Form leaves SharePoint list column empty

Posted on 13 Dec 2024 09:58:45 by 14

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.

  • Suggested answer
    WarrenBelz Profile Picture
    WarrenBelz 143,595 on 14 Dec 2024 at 06:06:03
    People Picker in Form leaves SharePoint list column empty
    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
     
     
  • prossberg Profile Picture
    prossberg 14 on 13 Dec 2024 at 11:29:51
    People Picker in Form leaves SharePoint list column empty
    @mmbr1606 The Update property for the datacard has "DataCardValue.Selected" with DataCardValue being the combobox.
  • Suggested answer
    mmbr1606 Profile Picture
    mmbr1606 10,000 on 13 Dec 2024 at 11:17:06
    People Picker in Form leaves SharePoint list column empty
    hey
     
     
    what are you having in the update property of that datacard? i guess it could be empty, can u check?
     
     
    Cheers

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,595

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,098

Leaderboard