Power Platform Community Forum Thread Details

hey guys,

I'm trying to add search columns from a parent table to a child table, the formula is adding only one column, but the code is the same for all, I don't know what could be going wrong

If(
 App.ActiveScreen.Name = Screen3.Name;
 With(
 {
 tbRecomendacaoId: AddColumns(
 tbRecomendacao;
 "idRecomendacaoNr";
 Value(idRecomendacao)
 )
 };
 SortByColumns(
 Filter(
 AddColumns(
 tbMonitoramento;
 "idRecomendacaoValor";
 LookUp(
 tbRecomendacaoId;
 idRecomendacaoNr = tbMonitoramento[@idRecomendacao] ;
 idRecomendacao
 );
 "nrProcedimentoAdministrativo2";
 LookUp(
 tbRecomendacaoId;
 idRecomendacaoNr = tbMonitoramento[@idRecomendacao];
 nrProcedimentoAdministrativo
 );
 "nrSituacao";
 LookUp(
 tbRecomendacaoId;
 idRecomendacaoNr = tbMonitoramento[@idRecomendacao];
 nrSituacaoRecomendacao
 );
 "sgJurisdicionadoRecomendacao";
 LookUp(
 tbRecomendacaoId;
 idRecomendacaoNr = tbMonitoramento[@idRecomendacao];
 sgJurisdicionado
 )
 );
 nrConclusaoMonitoramento = Blank()
 );
 "idRecomendacaoValor"
 )
 )
)

Captura de Tela 2023-02-10 às 16.42.10.png

if you can help me

Categories:

Building Power Apps

fixed, it was probably delegation problem

however the documentation is bad and powerApps did not give a delegation message

this is really bad because we have to try to guess what could be going on

If(
 App.ActiveScreen.Name = Screen3.Name;
 With(
 {
 tbRecomendacaoId: AddColumns(
 tbRecomendacao;
 "idRecomendacaoNr";
 Value(idRecomendacao)
 );

 tbRecomendacaoFiltrada: Filter(tbRecomendacao; nrSituacaoRecomendacao = 10).idRecomendacao
 };
 SortByColumns(
 Filter(
 AddColumns(
 tbMonitoramento;
 "idRecomendacaoValor";
 LookUp(
 tbRecomendacaoId;
 idRecomendacaoNr = tbMonitoramento[@idRecomendacao] ;
 idRecomendacao
 );
 "nrProcedimentoAdministrativo2";
 LookUp(
 tbRecomendacaoId;
 idRecomendacaoNr = tbMonitoramento[@idRecomendacao];
 nrProcedimentoAdministrativo
 );
 "nrSituacao";
 LookUp(
 tbRecomendacaoId;
 idRecomendacaoNr = tbMonitoramento[@idRecomendacao];
 nrSituacaoRecomendacao
 );
 "sgJurisdicionadoRecomendacao";
 LookUp(
 tbRecomendacaoId;
 idRecomendacaoNr = tbMonitoramento[@idRecomendacao];
 sgJurisdicionado
 )
 );
 nrConclusaoMonitoramento = Blank() && idRecomendacao in tbRecomendacaoFiltrada
 );
 "idRecomendacaoValor"
 )
 )
)