Make a label visible from the status of a column in sharepoint Lists

[LUMDN]

Hello,

I have the following gallery with videos, in it, I am placing a label (Completed) that tells me if the current user has already seen the video or not, so that when I leave the application and re-enter I can identify the videos that I have already seen previously.

I have two lists in SharePoint:

The first one is where I am saving the videos that are presented in the gallery.

The second one is to register the videos that I have already seen.

How can I make the label visible from the records of the second list and the current user?

I tried to use a variable and the lookup function to relate the ID of the first list with the ID of the second list and the email registered in the second list with the email of the current user but it did not work.

Thanks!!

[RandyHayes · Accepted solution]

@LUMDN 

Setting a variable is not going to be of much value to you.

What you need to do is set the Visible property of the completed label to:

!LookUp('Collection Registro de Videos Vistos',
    'ID Video' = ThisItem.ID &&
    Correo = varemail &&
    Estatus = "Completado",
    true
)

I hope this is helpful for you.

[LUMDN]

Thanks!!

This solves my problem!!