Security Filter difficulties

Hello I have two tables one with a security filter using [User]=USEREMAIL() and the other without. The table with no security filter has a column with a formula to confirm certain data in the table with the security filter. The only thing now is that it won’t work unless I remove the security filter. Is there a expression I can use that will allow that column to access the data on that table with the filter on? Perhaps an expression I can add on to the security filter which would allow access to confirm that data?

0 4 146
4 REPLIES 4

To clarify I need to make 4 columns accessible to the column in the table without the security filter but these 4 columns would be in the table with the security filter

Hi, if you need access to other records than your own records (filtered by the security filter), it won’t work. If you need access to those records, those records need to be out of that security filter as well.

Ah ok I thought there was a workaround thank you!

You’re welcome

Top Labels in this Space