I'm trying to figure out the most efficient way to filter a gallery w/ multiple columns. Ideally, I'd like to do a single filter function like...
Filter(DataSource,
If(!IsBlank(Criteria1), Column 1 = Criteria1,true)
If(!IsBlank(Criteria2), Column 2 = Criteria2,true)
If(!IsBlank(Criteria3), Column 3 = Criteria3.true)
The problem I can't figure out a way to do this without using IsBlank. I'm using a sharepoint list and I get a delegation issue. the only workaround I can think of is shove everything into a big collection and then filter off that or write a really long filter function where I write out every combination.
Edit: I thought startswith would work but I'm getting a delegation issue.