Unanswered

Filter table with two conditions, same column not working

(1) Share

Report

Posted on by tpcolson

I have a simple app that displays a sharepoint list in a table. I have a column in the list with the name "Title". I want to display the table filtered on if the title contains the word "Approved" or "Waiting".

Filter('Online GIS User Account Request List', !IsMatch(Title, "approved", MatchOptions.Contains))

Works when it's one condition.

Filter('Online GIS User Account Request List', !IsMatch(Title, "approved", MatchOptions.Contains) or !IsMatch(Title, "waiting", MatchOptions.Contains))

Does not work when I add the second condition with or

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Meekou on at

Like (0)

Report
Could you check for the single condition you real get expected data?
Based on your requirement, you want to filter based on approve and waiting, but you add ! before ismatch, and for your second conditon, you should use "Or" instead of "or".
Here is a sample demo:

ClearCollect( SampleData, { Id: 1, Title: "Approved" }, { Id: 2, Title: "Pending" }, { Id: 3, Title: "Waiting" } ); ClearCollect( FilterSampleData, Filter( SampleData, IsMatch( Title, "Approved", MatchOptions.Contains ) Or IsMatch( Title, "Waiting", MatchOptions.Contains ) ) );

Best Regards,
Meekou
YouTube
PowerApps
PowerAutomate

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report
In your example. it looks like you actually want it to only show items where the Title is neither "approved" nor "waiting", so using Or won't get you that as they both allow each other - i.e. if the Title is not approved then it could be waiting or if the Title is not waiting then it could be approved - but what you want (I think) is that neither of the two appear in your datatable.

Filter( 'Online GIS User Account Request List', !("approved" in Title) And !("waiting" in Title) )

It's worth noting that this formula is not delegable though so it won't work once you are over 2000 items - so can I ask, is your Title equal to "approved" or is there other text inside the Title field? If not, and you have a limited set of potential Title values, then I would suggest using explicit references to the other possible Title names, as this is scalable and will work no matter how many options you add to it:

Filter( 'Online GIS User Account Request List', Title="Under Review" Or Title="With Administrator" Or Title="Denied" Or Title="Rejected" )

Cheers,

Sancho

Was this reply helpful? Yes No