Row filter does not work inside of slice

[ajisafe]

I have a row filter to select rows that belong to the user based on a reference that points to the table I am using:  =IN(USEREMAIL(),[Related Roles][Email])

When I test the slice based on this filter, it correctly limits the view to just the rows belonging to my account, so it doesn't seem to be an error in the filter definition.  However, in the actual app, no rows are shown.  I have tried hardcoding the email address with the same result (no rows shown).  [Related Roles][Email] is a virtual column so I'm not sure if virtual columns are not supported for this type of filter.

[Steve]

Please post a screenshot of the slice configuration screen. Please also post a screenshot of the entire expression.

[ajisafe · Accepted solution]

I actually resolved the problem by pulling the column from the related table into a virtual column in the active table instead of reading directly from the related table.  So the screenshot below works correctly.  The system seems a little finicky so I would prefer not to go back to the previous filter just in case, but =IN(USEREMAIL(),[Related Roles][Email]) was indeed the entire expression when it was not working.

[Jamie_Laing]

I've been banging my head on the exact same issue all morning.  I suspect something is broken in AppSheet.  I have a nearly identical data relationship with the same field types.  When I use the Test function in the Expression Assistant, the expression does work correctly, but when the slice is viewed, it does not work.

Genius solution Ajisafe!

[Jamie_Laing]

Your solution worked for me.  Thank you, thank you, thank you!!!