cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sgokul95
Helper I
Helper I

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

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. 

 

sgokul95_0-1637151722029.png

 

When running the app and opening the dropdown items:

 

sgokul95_1-1637151768721.png

 

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.

3 REPLIES 3
gabibalaban
Dual Super User
Dual Super User

@sgokul95 ,

Try to use Choices() function.

Choices(SubListA.SubCategory)

Hope it helps !

 

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.

@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)

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,135)