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

Combining two values in one filter

Hi

I'm trying to filter a Gallery based on 2 different values in a SharePoint List. Filtering One is easy (Filter(TableName,ColumnName=Dropdown1.Selected.Value)

But, I would like to show content  where the "ProjectName" = XXX and the "ProjectPhase"= YYY. Both X and Y is in the same SharePoint-list.

I've tried &  &&  .  and ! without any results.... 

 

Any good ideas or solutions?

2 ACCEPTED SOLUTIONS

Accepted Solutions
PowerApps Staff LauraOnu
PowerApps Staff

Re: Combining two values in one filter

You can use either && or "And" function, for example:

Filter(Assets, InService=true && AssetType="Tablet") or Filter(Assets, And(InService=true, AssetType="Tablet"))

No need to quote the column names, intellisese adds simple quotes if there are spaces

View solution in original post

PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Combining two values in one filter

In addition to what LauraOnu suggested, you can also pass more parameters to the Filter function, and they will be combined as if they were passed to the And function, like in the example below.

Filter(TableName, ColumnName = Dropdown1.Selected.Value, ProjectName = "XXX", ProjectPhase = "YYY")

View solution in original post

5 REPLIES 5
PowerApps Staff LauraOnu
PowerApps Staff

Re: Combining two values in one filter

You can use either && or "And" function, for example:

Filter(Assets, InService=true && AssetType="Tablet") or Filter(Assets, And(InService=true, AssetType="Tablet"))

No need to quote the column names, intellisese adds simple quotes if there are spaces

View solution in original post

PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Combining two values in one filter

In addition to what LauraOnu suggested, you can also pass more parameters to the Filter function, and they will be combined as if they were passed to the And function, like in the example below.

Filter(TableName, ColumnName = Dropdown1.Selected.Value, ProjectName = "XXX", ProjectPhase = "YYY")

View solution in original post

TerjeF
Level: Powered On

Re: Combining two values in one filter

Thanks, I went for this and it worked perfect! Great fun!

cholopa
Level: Powered On

Re: Combining two values in one filter

And what about using "OR" instead of "AND", lets say a want to filter by two conditions, but not both condicitons have to be true, only one of them.

 

Any clue?

Super User
Super User

Re: Combining two values in one filter

You can use the Or operator or the || which is the equivalent.

Check out the operators here at this document.

 

Basic building blocks:

And  &&

Or  ||

Not !

_____________________________________________________________________________________
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.

Helpful resources

Announcements
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,077)