Power Platform Community Forum Thread Details

I have 3 sharepoint lists: END, UN, INTEGRANTES.

In a screen I have a calculated label, that need to look up for all unities in list "UN" that matchs with ID and then sum all people that work there in list "INTEGRANTES".

I have this formula that isn't working

LookUp(INTEGRANTES;Filter(UN;Idend=ThisItem.Idend);Sum(OFICIAL_DE_PROMOTORIA_CHEFE;OFICIAL_DE_PROMOTORIA_I;AUXILIAR_DE_PROMOTORIA_CHEFE;AUXILIAR_DE_PROMOTORIA_ENCARREGADO;AUXILIAR_DE_PROMOTORIA_I;AUXILIAR_DE_PROMOTORIA_II;AUXILIAR_DE_PROMOTORIA_III;ANALISTA_DE_PROMOTORIA_I;ANALISTA_DE_PROMOTORIA_II;ANALISTA_JURIDICO_DO_MP;ANALISTA_TECNICO_CIENTIFICO_DO_MP;'ANALISTA_DE_PROMOTORIA_I_(SAUDE)';DIRETOR_DE_AREA_DO_MP;DIRETOR_DE_DEPARTAMENTO_DO_MP;ASSESSOR_DE_DIRECAO_DO_MP;ASSESSOR_DE_GABINETE_DO_MP;ASSESSOR_DO_MP;ASSESSOR_ESPECIAL_DO_MP;ESTAGIARIOS_DE_GRADUACAO;ESTAGIARIOS_DE_NIVEL_MÉDIO;PROCURADOR_DE_JUSTICA;PROCURADOR_GERAL_DE_JUSTICA;PROMOTOR_DE_JUSTICA;PROMOTOR_DE_JUSTICA_SUBSTITUTO;SECRETARIO_DO_MP))

What I did wrong?

Thanks for help

Categories:

Building Power Apps