App Hanging when using Security Filter

[Hani_Ibrahim]

I have the follows:

1. Top tier table "Owner"
2. Second tier table "Users"

The "Owner" table has a field to accommodate the owner's users emails injected through bot and automation as shown below:

When i use the below security filter on "Users" table the app works fine if i logged in with "someone@gmail"

But if i used any of the user's emails the app gave me the below message:

I am also adding a phot to my "Users" Table for reference:

Kindly, assist on that matter.

Thank you

[Joseph_Seddik]

Hi Hani,

Would you please copy/paste the complete IFS() statement you are using? The screenshot is truncated. Thank you!

تحيا مصر 🙂

[Hani_Ibrahim]

Good morning,

This is the entire “IFS” statement. I just moved the last arrow to match with the ifs.

تحيا مصر 🙂

[Hani_Ibrahim]

IFS(
USEREMAIL()="arch.hany@gmail.com",
TRUE,


IN(USEREMAIL(), OWNER[Owner Authorized Email List]),
[Owner id]=ANY(SELECT(
OWNER[Owner_id],
IN(USEREMAIL(), OWNER[Owner Authorized Email List]))

),
)

[Joseph_Seddik]

Thank you!

I see two things:

1. Your security filter condition should either return TRUE or FALSE. The problem with your IFS  expression is that it can return TRUE, but otherwise it will never return FALSE. You have to  add another line at the end of your IFS statement:

   
   TRUE, FALSE
   
   
2. Also, I believe there's a logical problem. It might not cause the security filter to fail, but it  could lead to undesirable results. It is not only that the exact IN() condition is used twice, but  more importantly the SELECT statement will either return all rows of OWNER table or none,  because its condition is not testing the rows and has actually nothing to do with them. I  believe you should rewrite this. 

[Steve]

Your expression can be simplified:

OR(
  USEREMAIL()="arch.hany@gmail.com",
  IN(
    [Owner id],
    SELECT(
      OWNER[Owner_id],
      IN(USEREMAIL(), OWNER[Owner Authorized Email List])
    )
  )
)

[Hani_Ibrahim]

It looks tidy with your suggestion 😍,

i will try it.

[Joseph_Seddik]

Dear @Steve, sorry if I'm missing something very obvious, but I can't see how the SELECT expression would work; the outcome of its condition is independent of the row column values. 

I see this expression equivalent to:

OR(
  USEREMAIL()="arch.hany@gmail.com",
  AND(
    IN([Owner id], [OWNER[Owner_id]),
    IN(USEREMAIL(), OWNER[Owner Authorized Email List])
  )
)

[Steve]

Good point! I just restructured the original expression; I didn't consider whether it would do anything meaningful. 🙂

[Hani_Ibrahim]

Really, appreciate your feedback and respected advice, i will do think in it again with different approach. 

thank you for your valuable time. 

[Joseph_Seddik]

I see, thank you 🙏