Whats wrong with my code?
i dont get whats wrong with my code, it is suppose to show a list of projects depending on the user logging in, is the any error of sintaxis? or am i using wrong a function or something? help please.
The code first verify if the user logging in is a "Admin" and if its not it just show the projects asociated with the user, all the data is from sharepoint lists in which the code originally belongs to the "DH-PROYECTOS" list and the project code is called "PEP". I give the user access to it linking a column on the usuarios list, this columns is called "PROYECTO_LK" and it is linked to the "PEP" columns from "DH-PROYECTOS". i dont think that i explained my problem very well but hopefully i can get help on this. Thanks!!
(BTW) the code show me error especifically on
"OrdenPEP";
If(
varIsAdmin;
SortByColumns(
'DH-PROYECTOS';
"PEP";
SortOrder.Ascending
);
SortByColumns(
AddColumns(
Filter(
'DH-USUARIO-PROYECTO';
ACTIVO = true && USUARIO_LK.Id = varUserRow.ID
);
"OrdenPEP";
LookUp(
'DH-PROYECTOS';
ID = PROYECTO_LK.Id
).PEP
);
"OrdenPEP";
SortOrder.Ascending
)
)