multiple filters on a gallery

[Snazzybec]

Hi I am trying to create multiple filters on a gallery and coming across some delegation issues

Using

Filter(TABLE,Manager.DisplayName = VarUserName  And StartsWith(Surname,TextSearchBox1.Text) And StartsWith('Case closed?',"No")

The last part 'Case closed?' is causing issues because I already have an = condition

I would also like to order by meeting date

any assistance gratefully received

Sam

[eka24 · Accepted solution]

Try

Filter(TABLE,Manager.DisplayName = VarUserName  And StartsWith(Surname,TextSearchBox1.Text) And 'Case closed?'="No")

Or

Filter(TABLE,Manager.DisplayName = VarUserName  And StartsWith(Surname,TextSearchBox1.Text) And 'Case closed?'=false)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Snazzybec]

thank you very much @eka24 

the false option worked a treat

much appreciated

Sam

[eka24]

Please mark as a solution since it's working..

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.