You’re offline. This is a read only version of the page.
Announcements
175
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
Share
ReportIf(
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"
)
)
)
if you can help me
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
All responses (
Answers (
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"
)
)
)
