Unanswered

How to get values in a Combobox from a table in a Collection

(0) Share

Report

Posted on by dhruvmathur

Hi All,

I have been struggling with this for a couple of day, but have not been able to find a solution, even after searching the forum. I have a SharePoint list (List A) that has a choice field which allows multiple selections. I also have another SharePoint list (List B) that I use as a kind of feeder list. In my PowerApps for List A, I want to filter List B based on a value I input in the form, and put the record into a collection (FeederItem). This works fine. The choice field from List A shows up in the collection as a table. Now, in my PowerApps form, I want to show the values from this table in a combobox. I am just not able to figure out what the syntax to use would be. Can anyone guide me? Please let me know if I can provide more clarity.

Any guidance/help would be much appreciated.

Thanks,

Dhruv

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

eka24 20,923 on at

Like (0)

Report

For choice in combobox, use:
Choices(ListName,ColumnName)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
dhruvmathur 61 on at

Like (0)

Report

Tried that, but it does not work. i tried adding Choices(FeederItem, Software) to the Items property, where FeederItem is the Collection and Software is the column, but it doesn't work, It says function Choices has some invalid arguments. Keep in mind, the column Software is a table withing the collection.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Please used
Choices(FeederItem.Software)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
dhruvmathur 61 on at

Like (0)

Report

That doesn't work either, error is Name isn't valid. Do I need to parse the table values? If so, how would I do that?

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

If this does not work, take a screen shot of the collection:
FeederItem.Software.Value
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Kindly give a screen shot if this does not work:
FeederItem.Software.Value
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
dhruvmathur 61 on at

Like (0)

Report

Hi eka24,

Greatly appreciate all the help, but that did not work either. Attached are screenshots of the column in the collection, and the column itself.

Screenshot of the...

Was this reply helpful? Yes No
dhruvmathur 61 on at

Like (0)

Report

To give a bit more context. I have a SharePoint list that has a choice column set up for multiple choices. In PowerApps, when I create a collection, this Choice column becomes a table in the collection. I want to bring these values into a combobox in my PowerApps app, but can't seem to figure out what the syntax should be.

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report

@dhruvmathur ,
You need to tag the responder @eka24 like this to make it easier for them to see in their feed.

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
Hi @dhruvmathur ,
Is your request fundamentally that a user chooses some values in a multi-choice box and you want those values to be displayed in another combo box as below?
If so, all you have to do is make the second Combo Box Items property
YourFirstComboName.SelectedItems

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No