Answered

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

(0) Share

Report

Posted on by bikeknife 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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!
@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", ", ")

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.

Was this reply helpful? Yes No
bikeknife Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!
@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, "," ), "," )

Was this reply helpful? Yes No
bikeknife Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No