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

[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

[WarrenBelz]

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.

[dhruvmathur]

@WarrenBelz ,

Actually, I am trying to populate the combobox from a collection. The issue is, the column in the collection is in the form of a table. I am not able to figure out what the syntax for that should be.

[WarrenBelz]

Hi @dhruvmathur ,

I understood completely what you are trying to do and was trying to take you down a less painful track. I was actually doing another similar post at the same time and you might have a read of this one.

Not everyone takes this track (nor am I suggested you should), but I have always managed my data rather than let my data manage me and approached issues from the desired result backwards and have never needed to write the type of complex code such as my colleague @Anonymous assisted with on that one, however the syntax of the code you need is on that post.

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.

[dhruvmathur]

Hi @WarrenBelz ,

Thanks for pointing me in the right direction. The solution provided by @Anonymous worked to get the values into the collection, but I am now trying to filter the values before they get into the collection based on two drop downs. Basically, I want to filter the SharePoint list by two dropdown fields I have on my form. The filter will filter out all but one item in the sharepoint list. So, for example, my first dropdown is a field called dept, and my second dropdown is a field called Etype. My sharepoint list has three columns, Department, Type, and Software (multi select choice field). I want to get the list of software into a collection in my app for the item where the department = dept and Type = etype.

Thank you for all your help,

Dhruv

[WarrenBelz]

Hi @dhruvmathur ,

This is where the issue becomes a bit circular. The problem is your multi-choice column and the complexity of filtering on all values contained in it. If it was a single choice, this would easy. You can collect it, but then it becomes a table and you can't filter two tables with each other. I will tag @Anonymous again here as I never need to use this type of structure.