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 147
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