You’re offline. This is a read only version of the page.
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
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.
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
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.
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.
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
Share
Report
All responses (
Answers (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.
You need to tag the responder @eka24 like this to make it easier for them to see in their feed.
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.
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.
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.
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.
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
