Unanswered

Office365User multi select combobox pass all selected items to sharepoint list when SubmitForm is clicked

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

We have a powerapp when I need to populated a sharepoint list column with a list of Attendees. Attendees are always someone in the company so I use a multi-select combobox utilizing the Office365Users.SearchUserV2. I am able to get it to work when only one person is selected but once I try multiple people selected it will only send over the last person selected. Any help with this would be greatly appreciated.

Items code on the combobox iteself

But then on the Update of the Datacard itself it doesn't like the SelectedItems choice

Also the Sharepoint list columns is a Multiple Line Text

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You need a forall and you need to pass the claims, something like this:

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

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I put that in and update the necessary fields but it just tells me I have invalid arguments. Not sure what I am doing wrong here.

Was this reply helpful? Yes No
MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

It might not be ThisRecord.Mail for you, please check

Was this reply helpful? Yes No