cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pasha
Level: Powered On

Dropdown filtered by another Dropdown (all reading from OneDrive Spreadsheet)

I am trying to build an inventory app with powerapps, but struggling with the filtering of some drop downs. 

 

Reading data from excelfile stored at OneDrive, I am using several tables in the same file.

 

DataSource/Table = CatChoice, Columns: Category and ProductID

Drop downs: Drop_InKategori (upper) and Drop_InVariant

 

I would like to filter Drop_InVariant to only show data depending on the choice of Drop_InKategori.Selected.Value

 

After that I would probably do the same for selection of lenghts (Längd m), as I have different data for each Category/Kategori.

 

Would be glad if someone have and ideas how to solve it.

Many thanks

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Dropdown filtered by another Dropdown (all reading from OneDrive Spreadsheet)

Set the Items of your second dropdown to:

 

   Filter(yourDataSource, Category=Drop_InKategori.Selected.Value)

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

1 REPLY 1
Super User
Super User

Re: Dropdown filtered by another Dropdown (all reading from OneDrive Spreadsheet)

Set the Items of your second dropdown to:

 

   Filter(yourDataSource, Category=Drop_InKategori.Selected.Value)

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,228)