Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Suggested answer

Convert comma separated list to Combobox selection

Posted on 21 Nov 2024 22:50:54 by 47
I have a SharePoint list where I save the state selected from a drop down to a text field.  Everything is working great.  I was asked to convert this to allow multiple selections of states.  I created a combo box and am successfully saving a comma separated list to the text field.  
 
 
I am struggling to get these values set as the default selected items of the combo box.  I have seen postings on how to do this.  This is one example.  http://powerappsguide.com/blog/post/set-combobox-data-source-to-comma-separated-string.  But I still do not have it correct.  Any assistance is appreciated.  
 
I start by collecting the states. 
 
 
In the Items property for the combo box I have the collection.
 
 
I save the returned record to varRecord. In the DefaulfSelectedItems I have the following, but as you can see I am getting errors.
 
 
In the DisplayFields I have Code base on the collection I created.
  • Suggested answer
    TMProgUser Profile Picture
    TMProgUser 47 on 22 Nov 2024 at 15:02:41
    Convert comma separated list to Combobox selection
    I figured out the issue.  I didn't need the RenameColumns.  Once I removed that portion and just did a Split, it worked. 
  • ronaldwalcott Profile Picture
    ronaldwalcott 704 on 21 Nov 2024 at 23:10:03
    Convert comma separated list to Combobox selection
    Did you set the combox to allow multiple selection?

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,061

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard