Answered

Unable to Save Combobox Value in SharePoint List

(0) Share

Report

Posted on by MS-19111917-0

Hello PowerApps Experts,

I have an edit form. I am using the form for making updates in the SharePoint list. In that form I have a multiselect combo box that is a Single line text column in SharePoint list. Combo box values are coming from another SharePoint list column (single line of text) . I am using following for Combo box properties in edit form:

Edit Form Database: List B

Items: List A. ListAColumnName

Default selectedItems: Split(ThisItem.ListBColumnName,",")

Datacard Update: Concat(comboboxname.SelectedItems,ListBColumnName, ",")

 
Datacard Default: ThisItem.ListBColumnName
 
Everything is working fine when there is no existing value in the column and I select values for combo box and make update to the list. However, when I make edits in the same list item again, it pulls previously submitted comma seperated SharePoint list column value in the combo box. But for second time edit if I don't make any edit in the combo box options and save the form. In SharePoint list column, value is erased and shows',' only, even though on form it was showing values in combo box.

Any ideas that can help in resolving the problem.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

If you don't make any edits in the list then you need to save the defaults back in the update. So add an IF() to the update to send back the default string if nothing is chosen.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
MS-19111917-0 35 on at

Like (0)

Report

@Pstork1 Could you please help me with if condition for default? Since my form will be used only for update not for creating new item. I appreciate your support.

Was this reply helpful? Yes No
Verified answer

MParikh 322 Super User 2025 Season 2 on at

Like (3)

Report
You need to ensure the Update property always has a reliable reference to the existing values even when the user doesn't interact with the ComboBox.
1. Set DefaultSelectedItems:

ForAll( Split(ThisItem.ListBColumnName, ","), { Value: Trim(Result) } )

2. Set Items:

Distinct(ListA, ListAColumnName)

Make sure ListAColumnName returns values as { Value: "text" } structure to match ComboBox items.

3. Set Update (DataCard's Update):

If( IsEmpty(comboboxname.SelectedItems), ThisItem.ListBColumnName, Concat(comboboxname.SelectedItems, Value, ",") )

This condition ensures that if the user does not change anything in the ComboBox, it preserves the original value.

Was this reply helpful? Yes No
MS-19111917-0 35 on at

Like (0)

Report

@MParikh Thank you so much for resolving my combo box issue.

Really appreciate the help.

Was this reply helpful? Yes No