Filter gallery on multiple columns and only show unique items

[steven_S]

I can't figure it out how to filter my SP list on two columns. 

Variable

varUserMail = User().Email

Columns

Behoriga

'Skapades av'

Formula

Filter ( Projekt; varUserMail in Behoriga.Email || varUserMail = 'Skapades av'.Email )

If you look at the picture,  in this example I would like to find 2 items in the gallery (ID 2 and 13). 

Filter(Projekt; varUserMail in Behoriga.Email)   <-- Finds ID 2

Filter(Projekt; varUserMail = 'Skapades av'.Email) <-- Finds ID 13

How do you combine them to show both items in the gallery? (And then it needs to only show unique items, maybe Distinct?)

Thanks in advance!

[steven_S]

(I've tried collections, but they ruin my app further on)

[gabibalaban]

@steven_S ,

Your formula seems to be fine:

Filter ( Projekt; varUserMail in Behoriga.Email || varUserMail = 'Skapades av'.Email )

are you worried about the delegation warning ? or there is something else ? 

[steven_S]

@gabibalaban Thanks for the reply.

Im fine with the delegation warning, but the formula just gives me items from one of the criterias. In this case 

varUserMail in Behoriga.Email

My user is now Oskar Johansson, so I should be able to se more than ID 4 Bar Himmel:

If I run it with this formula I get 4 items - that I've created:

[steven_S]

Ok, there is something going on with the columns. Maybe it's the built-in in column "Created by" that is causing the problem. I have to test that.

If I filter by StartDatum = "2021-08-01" I get ID 1 and 2

With SlutDatum = "2021-12-30" I get ID 4. Together it works fine, as you said:

[gabibalaban]

Can you try to put each condition in brackets ?

Filter ( Projekt; (varUserMail in Behoriga.Email) || (varUserMail = 'Skapades av'.Email ))

[gabibalaban]

Have you tried this ? For some reason it is possible that the system to check the condition a little bit different than you expect. 

Filter ( Projekt; (varUserMail in Behoriga.Email) || (varUserMail = 'Skapades av'.Email ))

[steven_S · Accepted solution]

Same result, see below. It seems to be something with that built-in column 'Created by'.

I found a easy workaround till we found a solid solution 🙂

@gabibalaban  Thank you for your help and have a great weekend!

Created a new text column and just used User().Email as Default value.