Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Combobox values not saving to SharePoint Single line of text field

(0) ShareShare
ReportReport
Posted on by 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:
  • WarrenBelz Profile Picture
    146,524 Most Valuable Professional on at
    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).

  • dixonbridgeta Profile Picture
    125 on at
    Re: Combobox values not saving to SharePoint Single line of text field

    thank you! The forms are set to new though.

  • WarrenBelz Profile Picture
    146,524 Most Valuable Professional on at
    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

     

     

  • Verified answer
    dixonbridgeta Profile Picture
    125 on at
    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!

  • dixonbridgeta Profile Picture
    125 on at
    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.

  • Ami K Profile Picture
    15,665 Super User 2024 Season 1 on at
    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.

  • Ami K Profile Picture
    15,665 Super User 2024 Season 1 on at
    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?

  • dixonbridgeta Profile Picture
    125 on at
    Re: Combobox values not saving to SharePoint Single line of text field

    tried this as well, didn't work

  • dixonbridgeta Profile Picture
    125 on at
    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")

  • Ami K Profile Picture
    15,665 Super User 2024 Season 1 on at
    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 ","
    )

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard