Blank value is displayed when filtering a choice type column in DropDown control in PowerApps EditForm

[sgokul95]

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.

[gabibalaban]

@sgokul95 ,

Try to use Choices() function.

Choices(SubListA.SubCategory)

Hope it helps !

[sgokul95]

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.

[gabibalaban]

@sgokul95 ,

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)