web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Not able to store mult...
Power Apps
Answered

Not able to store multiple selected value of combo box in to sharePoint list

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello Expert!

I am unable to save multiple selected value of combo box in to sharePoint list, Only first value of combobox is saving in sharepoint list.

 

I have attached screenshot below Please help:

 

 

jay95_0-1617965752134.pngjay95_1-1617965776316.png

 

 

 

Categories:
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

    Your Update property of your DataCard should be:

      yourComboboxControlName.SelectedItems

     

    Check that it is that and not just .Selected.

     

    I hope this is helpful for you.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi Randy!

     

    Thanks for your response.

     

    When I use selectedItem, It will show an error as below screenshot:

    jay95_0-1617974340634.png

     

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

    How is your column defined in your SharePoint list?  Is it defined to allow multiple values?  Is it a choice column?

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    It is multi line text column

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

    The assumption was that you had a choice column as that is typically what you want to populate from a multi-select combobox.

     

    So, if you have a multiline text column instead, then there are some more questions

    - what is your Items property of the combobox?

    - what format are you expecting to store the choices of the combobox into text?

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    My Item Properties:

    Distinct('SharePoint List Name','Column Name')
    I want to store this in to the same row by comma separated or any format

  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

    Very good.

     

    So, your Update property needs to be:

        Concat(DataCardValue1.SelectedItems, Result & ",")

     

    Your DefaultSelectedItems property of the combobox needs to be:

        Filter(Split(Parent.Default, ","), !IsBlank(Result))

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hello Expert!

    I did everything from below screenshot, But this time I am getting error of default property in Combo Box, 

    Saved value is not showing when I open form in edit or view mode.

    what will be the default property for Combo BOx.

     

    jay95_2-1622621393626.png

     

     

    jay95_1-1622621375482.png

     

  • KayFax Profile Picture
    99 on at

    Dear @RandyHayes 

     

    since you are the expert on all things datacards and forms, I am adding my experience to this thread.

     

    Recently, I had a similar problem with a multiple select combo box in an App - which had worked fine for several months now, and suddenly stopped saving and displaying the default values of multiple selections.

     

    After again wasting half a night, trying to figure out WHY, I tried your solution with adding a concat to the update property, (again, it HAD WORKED without that for some time now) and now it was at least saving multiple selections back to the SP list.

    Thank you.

     

    One question though: I am fairly certain, that having to use "selectedItems" is rather new? It did function with just xx.selected.columname before.

     

    However, although meticulously following the suggestion with splitting the default in order to get a record from the default value, it was not displaying the values back in the box.

    Weirdly, the intellisense (cense?) DID show the correct result - but the box-field not.

     

    I tried various approaches, and in some cases it produced the same strange behaviour of "internally" showing the correct result, but not displaying it in the text-field of the box. Also not showing an error message. Just nothing. Aargh.

     

    So, finally, I resorted again to the simple "Filter(Datasource, ColumnName in Parent.Default) " - and now it works.

    Needless to say, the same thing did not before.

     

    I love learning new stuff on the Power Platform, but sometimes it really...

     

    Have you got an idea, why it is behaving so strangely? Is MS trying to get us all to use DataVerse instead of SP Lists?

     

    Any other "out of the ordinary quick fix-tips"? (Mr Warren Beatty mentioned in another thread that sometimes, datacards go rogue, and the only way to fix is delete and redo- which I would have not thought of in years - it would really be great to have a video or so with this kind of "unsettling bugs and how to fix them" 😉

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Anonymous 

    I just realized I never responded to your response...thanks to @KayFax for causing this to pop back up on my radar.

    I hope you have figured it out at this point that the Default property does nothing on a combobox...you must use the DefaultSelectedItems property to provide a record or a table (if multi-select is enabled) to select your items.

     

    @KayFax 

    If you are using Concat to store your values, then I'm assuming that the underlying column is a text column.

    Also, for a combobox, Select is a record - it will be the currently selected item record (or the first is multiple are selected).  SelectedItems has been around as long as the combobox has, it is a Table of all the selected records.

     

    As for the conversion of the text value to the records for the DefaultSelectedItems property, you need to make sure you filter out any blanks.

    So, for example, Filter(Split(yourTextValue, ", "), !IsBlank(Result))

    This will filter out any trailing blank records.  

    You thought that your list of records in the Formula Editor showed all the records from the Split properly, but yet I can almost bet that there was a trailing record in that editor list that was blank...this will trip up a combobox!

    But still, the key to a combobox selection is that the DSI property MUST contain records that match the Items property signature exactly...otherwise nothing will be produced.

     

    MS is definitely pushing Dataverse, but they also are not abandoning SharePoint.  This would close their market if they did as many will not pay a premium price for the dataverse on top of the existing Office 365 License.  If your goal is to write one app for 1000 users to show a list of names (for example) - no one is going to pay an additional $10,000 per month just because they need a premium license to connect to Dataverse to get that list (and they don't want it in Teams).  Just sayin' !

     

    I think you might be talking about a post from Warren Belz - it is correct, sometimes datacards go bad.  However, usually ONLY when the designer of the app is also mucking with the underlying datasource columns.  Once you create a form, it "learns" the column types.  If you then change a column type, even a refresh of the datasource in the designer will not correct the datacard...it needs to be deleted and then added back.  This is usually the only issue that happens with them.

    There are definitely some gotchas in PowerApps designer that will trip you up.  Some will make you beat your head for a little bit, but then you learn them quickly.  Things like the DataCard strangeness, the Combobox and Dropdown ghosts, Schema inferences, etc. there are a few.  But...I find that most people run into these problems more when they think they are developing and doing things like a developer.  If you drop the misunderstanding that you are developing and realize that you are designing an advanced Excel spreadsheet, you will not run into many of the oddities that are encountered...in other words - Keep It Super Simple and Think Excel!!

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 225

#3
M Bilal Khan Profile Picture

M Bilal Khan 192

Last 30 days Overall leaderboard