Hi All,
I have 1 main list(ListA) and 1 sub list(SubListA) in SharePoint. In PowerApps, I have created an EditForm for the ListA. In this EditForm, I have a custom data card which contains a DropDown control. In this, I have to display the items from the choice type column "SubCategory" of the SubListA. The following is the code in the Items property of this dropdown control.
Filter(SubListA, System.Value = systemComboBox.Selected.Value && Category.Value = categoryDropDown.Selected.Value).SubCategory
The above code properly filters the SubListA but the items are displayed blank. I can note that the Filter provides a table in which the SubCategory column contains records instead of direct value.
When running the app and opening the dropdown items:
Can you please let me know what I am missing here because the filtering is done correctly but I am not able to get its value to be displayed.
Update:
I need to populate only certain items of that SubCategory column based on the selected value of another element. Hence I have used a Filter function to include a condition for it.
Due to this case, I can't use Choices(SubListA.SubCategory) as it will populate all the choice items.
Hi @gabibalaban ,
Thanks for your quick response.
I need to populate only certain items of that SubCategory column based on the selected value of another element. Hence I have used a Filter function to include a condition for it.
Due to this case, I can't use Choices(SubListA.SubCategory) as it will populate all the choice items.
The result choice() function actually is a table so you can filter it, but honestly I don’t get it how you link the subcategories you need to the “another” control selected options.
you can use something like:
Filter(Choices(SubListA.SubCategory), Value in ExpectedList)
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
181 | |
52 | |
41 | |
39 | |
33 |
User | Count |
---|---|
261 | |
81 | |
71 | |
69 | |
66 |