Filter a gallery excluding certian values

[d3ell]

Hi, Im wanting to filter a gallery, but i'm only wanting to show the records that don't have a specific value in a field.

ie. i want to see all the records from the list that dont have a "-" in the DevelopmentName Column

I'm a bit out of practice as i havent used powerapps for a good few months now, so not sure if i'm being thick and missing something easy!

I have tried the following to no avail. - If i remove the "!" then i can only see all the records that contain that, so i'm just wanting to do the opposite!

Filter(Developments,Development_Name=!"-")

[K-A-R-L]

Hi @d3ell ,

Try filtering your gallery with this code:

IsMatch(ThisItem.DevelopmentName, "-",Contains)

----------------------------------------------------------------------------
Thanks,
K-A-R-L

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.

[d3ell]

Sorry...

I have misworded my initial post  I dont have a gallery yet, i meant i'm trying to filter a sharepoint list to create a gallery that doesnt show these items.

is there a way to do that? as i'm also wanting to filter the list for a data table as well.

[d3ell]

The Items fx is currently just "Developments" - This shows all the records from the list in the gallery.

If i try to use "Filter(Developments(IsMatch(ThisItem.DevelopmentName, "-",Contains)))

It doesnt work

[shailendra74 · Accepted solution]

Hi @d3ell 

Try below code:

ClearCollect(
    collDev,
    Filter(
        Developments,
        !("-" in DevelopmentName)
    )
)

You can set the datasource of gallery to collDev (or just consider from Filter if you do not want collection)

Thanks.

[K-A-R-L]

Hi @d3ell ,

Try adding this code to your gallery Items() Property:

Filter(
    DataSource, //Name of your DataSource
    IsMatch(
        Title,
        "-",
        Contains
    ) <> true
)

or

  Filter(
        AttachmentTest,
       !("-" in Title)
    )

*Note you might have delegation warning but the code will still filter items with "-" on the DevelopmentName Column.

----------------------------------------------------------------------------
Thanks,
K-A-R-L

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.