cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JR-BejeweledOne
Super User
Super User

Dataverse View issue

In my Power Apps for Teams canvas app I am using Dataverse tables as data sources for a cascading dropdown setup.

 

The dataverse tables come with an Active view by default which uses the default Status column.  The issue I am running into is with adding an additional parameter to the filter for the table.   The products table has a lookup to the Product Lines table.   The lookup column is called 'Product Line'.

 

I can do this (Filter by the Active Products view): 

FilterbyView.png

 

I can do this (Filter by the Business Group dropdown):

FilterbyDropdown.png

 

but I can't combine them into a single filter:

CombinedFilter.png

 

 

 



If you like this post, give it a Thumbs up. If it answered your question, Mark it as a Solution to enable other users find it.
1 ACCEPTED SOLUTION

Accepted Solutions
cchannon
Super User
Super User

Nest your filter statements instead of trying to join them. Something like: 

Filter(Filter(Products, 'Products (Views)'.'Active Products'), 'Product Line'.Name = DropdownBusinessGroup.Selected.Name)

 

View solution in original post

1 REPLY 1
cchannon
Super User
Super User

Nest your filter statements instead of trying to join them. Something like: 

Filter(Filter(Products, 'Products (Views)'.'Active Products'), 'Product Line'.Name = DropdownBusinessGroup.Selected.Name)

 

View solution in original post

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (3,291)