Solved: IN() function not working as expected - Page 2

G0ldsoul · 07-16-2024 10:10 AM

Hi everyone.

I'm having troubles with the IN() function, since is not working as it should be with the syntax

IN([Proyecto_solicitud],SELECT(PERSONAL[Proyectos permitidos_personal],[CorreoApp_personal]=USEREMAIL()))

[Proyecto_solicitud] is a ref type column from a table called Proyectos.

[Proyectos permitidos_personal] is an enum list with a basetype of ref also from the table Proyectos.

I want to use this formula to let the user see only the values that are in the allowed list of proyects in their respective [Proyectos permitidos_personal].

But, when i tested the formula, this occours.

I don't see what I'm doing wrong here, since I've used this function many times in the past.

Thank you for your help

AleksiAlkio

What is the error message? Or do you mean the result is just wrong? When using CONTAINS, the longer string needs to be the first element like this in your case..

CONTAINS(CONCATENATE(SELECT(PERSONAL[Proyectos permitidos_personal],[CorreoApp_personal]=USEREMAIL())),[Proyecto_solicitud])

View solution in original post