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?!
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).
thank you! The forms are set to new though.
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
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!
sorry, no error message or anything. Just didn't save to the list.
@dixonbridgeta - i've just seen another super user has responded to your question. I will drop out.
"didn't work" is not very descriptive @dixonbridgeta . Is there an error message for example?
tried this as well, didn't work
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")
@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 ","
)
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional