Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Multi select combobox only saves single value despite selecting multiple options

Like (0) ShareShare
ReportReport
Posted on 5 Jul 2023 16:53:15 by 494

I have a multiselect combobox in powerapps which is the equivalent person or group field in SharePoint. Allow multiple selections has been enabled for this column  named "Members"  in SharePoint and powerapps as well. 

 

Items property of the combobox

Filter( Office365Users.SearchUser({searchTerm: DataCardValue17.SearchText,top:500}),
Department = "Banking & Finance"
)

Default property of the combobox = Blank

Default Selected Items of the combobox = Parent.Default

Update property of the datacard

{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(DataCardValue17.Selected.Mail),
Department: DataCardValue17.Selected.Department,
DisplayName: DataCardValue17.Selected.DisplayName,
Email: DataCardValue17.Selected.Mail,
JobTitle: DataCardValue17.Selected.JobTitle
}

 

I have selected multiple values in combo box in powerapps new form and submitted the form. However in SharePoint i can only see single value. 

 

Any idea where i am going wrong?

Categories:
  • AJ_Z Profile Picture
    3,711 Super User 2024 Season 1 on 05 Jul 2023 at 17:14:56
    Re: Multi select combobox only saves single value despite selecting multiple options

    Hi @Iantaylor2050 

    You're seeing only one value in SharePoint because in your Update property of the data card, you're using "Selected" property which is for single selection. For a multi-select combo box, you should use the "SelectedItems" property which returns a table of all selected items.

    Below is an example of how you can modify your code to accommodate multiple selections:

     

    ForAll(
     DataCardValue17.SelectedItems, 
     {
     '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
     Claims: "i:0#.f|membership|" & Lower(Mail),
     Department: Department,
     DisplayName: DisplayName,
     Email: Mail,
     JobTitle: JobTitle
     }
    )
    

     

    In this formula I assumed DataCardValue17 is your combobox name if not, DataCardValue17 should be replaced with your actual combo box control name. This will iterate over each selected item and create a table of user information which will then be written to your SharePoint "Members" field.

    Remember, when you're using the ForAll function, the context inside the function changes. So instead of using DataCardValue17.Selected.Mail, you simply use Mail, Department, DisplayName, and JobTitle. This will refer to the properties of the current item in the ForAll loop.

     

    Also, ensure that the "Members" field in your SharePoint list is set up to accept multiple values.

     

    I hope this helps! Let me know if you have further questions.

  • Rajkumar_M Profile Picture
    3,665 Super User 2025 Season 1 on 05 Jul 2023 at 16:59:57
    Re: Multi select combobox only saves single value despite selecting multiple options

    Hi 

    Plz try this formula, it may help you

    {
    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
    Claims: Concat(
    DataCardValue17.SelectedItems,
    Concatenate(
    "i:0#.f|membership|",
    Lower(Mail)
    )
    ),
    Department: First(DataCardValue17.SelectedItems).Department,
    DisplayName: First(DataCardValue17.SelectedItems).DisplayName,
    Email: First(DataCardValue17.SelectedItems).Mail,
    JobTitle: First(DataCardValue17.SelectedItems).JobTitle
    }

    Thanks!

    If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 83 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 54

#3
mmbr1606 Profile Picture

mmbr1606 41 Super User 2025 Season 1

Overall leaderboard
Loading started