Strange Behavior App

[Cannone_Cannone]

Hi everyone!
I have a problem with my APP, in a view with the formula [Checked on (date)]>(TODAY())-15 I display the data for the last 15 days. With a security filter [Station] = ANY(SELECT(User[Station], [Email] = USEREMAIL())) I only display the data of the correct station. Everything works perfectly but I have a problem with an Email address where only the formula [Checked on (date)]>(TODAY())-15 doesn't work, it shows me all the data from the previous months the email is formatted like this
it.mxp.gse@..........
It only happens to me with this email, the others all work
the account is Microsoft
Thank you

[Koichi_Tsuji · Accepted solution]

Only FIND Condition with AppSheet could be Case-sensitive, why do you wanna test with it?

[AleksiAlkio · Accepted solution]

What happens if you simplify your condition something like [Checked on(date)]>TODAY()? What about [Checked on(date)]>"06/01/2024"?

[AleksiAlkio]

First.. change the email address with small letters and then test it.

[Koichi_Tsuji · Accepted solution]

Only FIND Condition with AppSheet could be Case-sensitive, why do you wanna test with it?

[AleksiAlkio]

I have seen cases now and then when the email address was not identified when it started with upper case 🙂 After writing it with all small letters, it has started to work. And those cases didn't have anything to do with FIND().

[JMPeterson · Accepted solution]

I have started wrapping email fields and USEREMAIL() in LOWER() for this exact reason.

[Cannone_Cannone]

Hi, I tried but it doesn't work

[Cannone_Cannone]

Hi, I tried but it doesn't work

[AleksiAlkio]

So.. I assume the security filter works properly, right? Where are you using this formula? Is it with a slice?

[Cannone_Cannone]

Hi, yes exactly, I use this in the slice

[Cannone_Cannone]

Hi, yes exactly and this is in the security filter

[AleksiAlkio · Accepted solution]

What happens if you simplify your condition something like [Checked on(date)]>TODAY()? What about [Checked on(date)]>"06/01/2024"?

[Cannone_Cannone]

Thanks to everyone, I solved it, rechecking the dates, practically some of them were in American format, so the filter was not hiding the data.
Thanks for your support

[AleksiAlkio]

Good to hear!