[Email]=Useremail()

[EddyVW]

I would like to add a Slice from a datatable "Jobs"
The Row filter condition must be ==> [Email]=Useremail() <==
The problem is that my column [Email] is not in the datatable "Jobs" but in the datatable "Responsibles"

Thanks

[baba_sawane]

How your tables Reponsibles and Jobs are linked then ?

[EddyVW]

In Jobs I have a column RespName (type Name) which is set as Key.
In Resp I have a column RespName (type Ref) and a column Email (type Email) set as Key.

In Jobs I add a virtual column Email (type List) with formula ==>Ref_Rows("Resp","RespName")<==

I create a slice in Jobs with  Row filter condition =[Email] = useremail()
I receive an error: "Cannot compare List with Email in ([Email] = USEREMAIL())"

When I change the column Email (in Jobs) then we have the error:

The type of the app formula 'List of Ref to table 'Resp' of Email' does not match the column type 'Email'.

Thanks