Save multiple combobox selected items to SharePoint

(0) Share

Report

Posted on by Aurora

364

Hi All,

I am having an issue uploading multiple values to a SharePoint list. The values come from a list of all users, but are stored in the combobox with function: Filter(_USER, ID = 9 || ID = 21 || ID = 22 || ID = 24 || ID = 40 || ID = 70)

When I submit the form, none of my selected values are sent to sharepoint. I have tried to change the update field to something along the lines of: ForAll(DataCardValue2.SelectedItems, {ID: DataCardValue2.SelectedItems.ID, Value: DataCardValue2.SelectedItems.Title})

but this gives me an error when I try to submit my form. Does anyone know what I am missing to send these values through?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Aurora ,

Try this

ForAll( DataCardValue2.SelectedItems As aUpdate, { ID: aUpdate.ID, Value: aUpdate.Title } )

Please click Accept as solution 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 Thumbs Up.

Visit my blog Practical Power Apps
Aurora 364 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

When I try that I do not get an error, but my users are still not being saved with the rest of the data in my form. I am not sure if the issue is related to something else, I have another form in my app where a user is assigned a "task" and the user is successfully submitted with that form. The code for the update property in that form is just: DataCardValue30.SelectedItems but only one user is selected in this scenario.

Do you have any additional ideas?
Verified answer

Aurora 364 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
I removed and re-added the combobox that contains users in my form, and now the data is being submitted properly. I'm not sure how it happened, but it appears to be working now.