Creating a dropdown of options from multiselect

[morall]

I have a data field that is multi select

I'm trying to create a dropdown menu in a canvas app. To create the items I'm trying to do something like:

Distinct(pipeline_candidates, 'Desired Location'.Value)

I'm seeing this as the data type: Table

 

How do I get access to the data in the table? 

[RandyHayes]

@morall 

To start with, your formula 'Location drpdwn'.SelectedText.Value is not going to be valid.  SelectedText is just that...it's Text.  It has no value property.  What you would want is 'Location drpdwn'.Selected.Value .  The SelectedText property has been deprecated and should be avoided.

Now on to the next.  You have a "data field that is multi select" - are you referring to a Choice field/column in SharePoint?  Is 'Desired Location' the data field, or is that something else?

Next, are we dealing with a DropDown or a ComboBox?

When you say "all of the distinct records that have been selected", Do you mean in your datasource, or in a dropdown or a combobox.

Maybe helpful, if a little complex, to share some screenshots or other details that can help narrow in on the solution.

[morall · Accepted solution]

Hey Randy,

I just happened to stumble across this video - https://www.youtube.com/watch?v=44j2VRbdWjk

It answered my question.

I wasn't familiar with the Choices() function that selected all of the choices the user has for the multi select

and then using the concat() function to iterate through the table

[RandyHayes]

@morall 

Yep...that's why I was asking about the type of field.  It was my next response 😉

Glad you worked through it.