Share via

Whats wrong with my code?

Anonymous
2026-01-19T18:25:54.2433333+00:00

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
    )
)
Microsoft Copilot | Other
0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.