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

I have the same question (0)

All responses (3)

Answers (1)

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
Aurora 364 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

Aurora 364 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No