Combobox values not saving to SharePoint Single line of text field

(0) Share

Report

Posted on by dixonbridgeta

125

Something so simple is just not working and I don't know why!

I have a combobox inside of a datacard. The datacard is on my form in the app and is linked to a SharePoint list. However, for some reason the combobox value isn't saving to my list!

Combobox is pulling from a separate data source. User can select multiple. Displayfield and searchfield is "FriendlyName".

The datacard is a single line of text. Datacard's datafield and display name matches the column name in the SP list, so does default: ThisItem.'Servers to install onto'.

The update property.... I have tried so many... here is a few:

Text(ComboBox26.Selected.FriendlyName)

ComboBox26.Selected.FriendlyName

Combobox26.SelectedItems

I also tried a Concat....

NOTHING IS SAVING! WHY?!

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

WarrenBelz 153,462 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @dixonbridgeta ,

Can you please post (in Text)

The Items of the Combo Box

The DefaultSelectedItems of the Combo Box

The Update of the Data Card

The name and type of field it is writing back to (if Choice is it single or multi-value)

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@dixonbridgeta concat was the right answer. Try the below on the Update property of the DataCard:

Concat( ComboBox26.SelectedItems, Value, //assumes the data source for your combo box returning a single column table with the default header of "Value" ";" //change if you are using a different delimiter, such as a comma "," )

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

Items: Filter(CMDB_SERVERS,Location = Dropdown3.Selected.Value)
Defaultselected: empty
Update: I have tried;
Text(ComboBox26.Selected.FriendlyName)
ComboBox26.Selected.FriendlyName
Combobox26.SelectedItems

field is a single line of text
datafield: "field_42"
displayname: DataSourceInfo([@'Application OnBoarding'],DataSourceInfo.DisplayName,"field_42")

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

tried this as well, didn't work

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

"didn't work" is not very descriptive @dixonbridgeta . Is there an error message for example?

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@dixonbridgeta - i've just seen another super user has responded to your question. I will drop out.

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

sorry, no error message or anything. Just didn't save to the list.

Was this reply helpful? Yes No
Verified answer

dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

Not sure what happened, but it seems like the column was just broken. I made a new one and it is working now although I was trying to avoid doing this because I have to change more fields now.

Thanks though!

Was this reply helpful? Yes No
WarrenBelz 153,462 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@dixonbridgeta ,

Importing from Excel with the field_xx underlying names will cause you considerable inconvenience (and confusion) going forward, but that is not your current issue. From what you have posted, your data card Update should be

Concat( Combobox26.SelectedItems, FriendlyName, "," )

and if this is on an Edit Form, you also need to get the values back into the Combo Box to save existing records, so the DefaultSelectedItems would be

RenameColumns( Split( ThisItem.field_42, "," ), "Value", "FriendlyName" )

I wrote a blog on this some time back which may be of use to you.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
dixonbridgeta 125 on at

Like (0)

Report
Copy link

Link copied!

thank you! The forms are set to new though.

Was this reply helpful? Yes No