Unanswered

Combo Box only save last selected item in Excel

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm using combo box to select multiple items, when I save the record it only save the last selected item excel. Is there anything I missed out? Here's my update property Update = ComboBox.Selected.Items

Selected Items

Item 1
Item 2

Saved in Excel

Item 2

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

This is because that you have used Selected in the formula and this will only update single selection. The right formula should be Update = ComboBox.SelectedItems.Value. But I just tested with this, but it still won't work. I think this is because that this column from Excel table. I would ask about this with pg and see if they have any suggestions.

Regards,

Mona
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Assuming this is saved in an Excel spreadsheet file, the error is probably caused by the fact that Update is expecting a string, not a list. Try using a Concat() function to collapse the list into a string.

Then again, I just used Patch() here and gone away with the "helpful" abstraction by PA so I don't have much experience with the Update property.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I tried this formula but still the last selected item was only saved.

UpdateContext({AddRecord: Patch(ComboBox,Defaults(ComboBox),{Document:Left(Concat(ComboBox.SelectedItems.ItemsList, Concatenate(Text(ItemsList), ";")), Len(Concat(ComboBox.SelectedItems.ItemsList, Concatenate(Text(ItemsList), ";"))) -1)})})