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 / Cascading combobox res...
Power Apps
Unanswered

Cascading combobox result is a comma separated string - I can't seem to split the results to make them individual choices

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I have a flow gathering data via API and putting it into Dataverse. One field is a set of values related to that single record. In exploring solutions to this problem I created additional columns and have the value as a string in an array format in one column and just a string of comma separated values in another. I'm trying to massage the data at the source and am open to whatever other options on that end might do the trick.

 

These values will always be a group of items and I can't seem to split the results into individual options for the combobox/dropdown. Split doesn't work nor does setting the formula results as a variable. I've tried creating a collection of the values as well as converting the results to text so I can use Split but nothing has worked so far. Oh, and I'm pretty new to the Power Apps side of things. Power Automate is my jam but in this area I'm out of my depth.

 

I have the Items property set to

Distinct(
    Filter(
        'Field Details',
        FieldName = cbField.Selected.Value
    ).FieldAllowedValuesList,
    FieldAllowedValuesList
)
And it produces something like ["option1", "option2", "option3"] (the alternate column values look like "option1, option2, option3")
How can I split these results?
 
Thanks!
Categories:
I have the same question (0)
  • EddieE Profile Picture
    4,641 Moderator on at

    @bikeknife 

    I'm not quite sure what you are asking but if you add a Dropdown with this code is that what you want?

    Split( "option 1, option 2, option 3", ", ")

    EddieE_0-1692332596512.png

     

    If so, where I have "option 1, option 2, option 3" replace it with your data source column name that is the comma separated string.

     

  • bikeknife Profile Picture
    Microsoft Employee on at

    Thanks for the reply, The column value is already being set by a distinct filtering of a previous combobox value.

     
    Distinct(Filter('Field Details',FieldName=cbField.Selected.Value).FieldAllowedValuesList,FieldAllowedValuesList
     
    What I'm trying to do is get the resulting values of this filter (which are comma separated ) to become individual choice options. 
     
    "option1, option2, option3"
    Becomes
    option1
    option2
    option3
  • Verified answer
    EddieE Profile Picture
    4,641 Moderator on at

    @bikeknife 

    I still don't understand, sorry. Are you saying that this code

    Distinct(Filter('Field Details',FieldName=cbField.Selected.Value).FieldAllowedValuesList,FieldAllowedValuesList) 

    Produces this

    "option1, option2, option3"

     

    ??

     

    If so, maybe try this

    Split(
     Concat(
     Distinct(
     Filter(
     'Field Details', 
     FieldName = cbField.Selected.Value
     ).FieldAllowedValuesList, 
     FieldAllowedValuesList
     ),
     Value,
     ","
     ),
     ","
    )

     

     

     

  • bikeknife Profile Picture
    Microsoft Employee on at

    That's exactly what I was going for. Thanks!

    Between then and now, I was chatting with a colleague and we came up with this for the OnSelect and set Items to _values

    Clear(_values);
    ForAll(
        Distinct(
            Filter(
                'Field Details',
                FieldName = cbField.Selected.Value
            ).FieldAllowedValues,
            FieldAllowedValues
        ),
        Collect(
            _values,
            Split(
                ThisRecord.Value,
                ","
            )
        )
    );
    I prefer what you came up with and the Concat piece is a good tip.

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 759 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 310 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 228

Last 30 days Overall leaderboard