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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Populate a combobox wi...
Power Apps
Unanswered

Populate a combobox with sharepoint column single line of text with items separated by comma

(0) ShareShare
ReportReport
Posted on by

Hello, 

i have a combobox loaded with a collection. 

 

Collect(
 Interests,
 {
 Name: "Music"
 },
 {
 Name: "Sport"
 },
 {
 Name: "Reading"
 },
 {
 Name: "Movies"
 }
)

 

 

to store the selected items on a sharepoint column i use the following code

 

Concat(ComboInterests_Profile.SelectedItems, Name & ", ")

 

 

so inside my Sharepoint column i'll have something like "Movies, Reading,"

 

the problem is when i want to load back the combo with the value from the column.

 

how can i load the combobox  showing as selected elements only the one coming from the sharepoint column? so it should show "Movies" and "Reading"?

 

thank you

Categories:
I have the same question (0)
  • BrianS Profile Picture
    2,407 Super User 2024 Season 1 on at

    You need the Split() Function

  • Antonioclk Profile Picture
    on at

    i tried but it's not showing anything... i wrote Split(MySPList.Interests, ",") in my DefaultSelectedItems property but nothing's showing up

  • BrianS Profile Picture
    2,407 Super User 2024 Season 1 on at

    What type of column are you using - short text? Have you confirmed that the data is being written correctly? It will not matter now, but you will need to add the space - the same way you have the Concat() 

    Where are you putting the Split function? Have you defined the possible entries separately?

  • Antonioclk Profile Picture
    on at

    the column is a single line of text, and the saving data part works fine. 

     

    what do you mean i need to add the space? inside the split? i tried that too but still nothing

     

    the split function is inside the DefaultSelectedItems... 

    what do you mean with "have you defined the possible entries separately?"

     

    i also made a test, i made a label and loaded in it the text of the column, and tried to do the split like this Split(label.text,",") but still nothing

  • Verified answer
    Antonioclk Profile Picture
    on at

    ok i found the solution...

    i have to use the RenameColumns() too.

    So it is RenameColumns(Split(MySPList.Interests, ","),"Results","Value")

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard