Combobox values not saving to SharePoint Single line of text field

Like (0) Share

Report

Posted on 12 Oct 2023 18:43:47 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:

General Questions

I have the same question (0)

All responses (11)

Answers (1)

WarrenBelz 150,394 Most Valuable Professional on 12 Oct 2023 at 22:10:07

Like (0)

Report

Re: Combobox values not saving to SharePoint Single line of text field

@dixonbridgeta ,

I find it strange that this is the solution (bear in mind that future users need to rely on this) as writing back to a Text field from a multi-select combo box requires non-standard code (Power Apps will not create it for you).

Was this reply helpful? Yes No
dixonbridgeta 125 on 12 Oct 2023 at 21:50:06

Like (0)

Report

Re: Combobox values not saving to SharePoint Single line of text field

thank you! The forms are set to new though.

Was this reply helpful? Yes No
WarrenBelz 150,394 Most Valuable Professional on 12 Oct 2023 at 21:23:53

Like (0)

Report
Re: Combobox values not saving to SharePoint Single line of text field

@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
Verified answer

dixonbridgeta 125 on 12 Oct 2023 at 21:17:27

Like (0)

Report

Re: Combobox values not saving to SharePoint Single line of text field

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
dixonbridgeta 125 on 12 Oct 2023 at 21:04:04

Like (0)

Report

Re: Combobox values not saving to SharePoint Single line of text field

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

Was this reply helpful? Yes No
Ami K 15,665 Super User 2024 Season 1 on 12 Oct 2023 at 20:59:23

Like (0)

Report

Re: Combobox values not saving to SharePoint Single line of text field

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

Was this reply helpful? Yes No
Ami K 15,665 Super User 2024 Season 1 on 12 Oct 2023 at 20:57:33

Like (0)

Report

Re: Combobox values not saving to SharePoint Single line of text field

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

Was this reply helpful? Yes No
dixonbridgeta 125 on 12 Oct 2023 at 20:56:20

Like (0)

Report

Re: Combobox values not saving to SharePoint Single line of text field

tried this as well, didn't work

Was this reply helpful? Yes No
dixonbridgeta 125 on 12 Oct 2023 at 20:55:53

Like (0)

Report

Re: Combobox values not saving to SharePoint Single line of text field

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
Ami K 15,665 Super User 2024 Season 1 on 12 Oct 2023 at 20:49:03

Like (0)

Report
Re: Combobox values not saving to SharePoint Single line of text field

@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