Power Platform Community Forum Thread Details

Hi there,

I have a problem with AddColumns function:

Collect(entregas;
 AddColumns(
 GroupBy(
 Filter(
 AddColumns(
 '[dbo].[tbPODetails]';
 "Code";
 LookUp('[dbo].[tbPO]';Id = IdPO;NPO)
 );
 IdProject = pry;
 ActiveETA = true
 );
 "IdProject";
 "IdPO";
 "Code";
 "Supplier";
 "Grupo"
);
 "ETA1";
 LookUp('[dbo].[tbPODetails]';PO = Code;ETA1);
 "Origen";
 "Pedidos";
 "Status";
 If(IsBlankOrError(Sum(Filter('[dbo].[tbWarehouseDetails]';IdPO = IdPO);Amount)) ;"Pendiente";
 If((Sum(Filter('[dbo].[tbWarehouseDetails]';IdPO = IdPO);Amount)/Sum(Filter('[dbo].[tbPODetails]'; IdPO = IdPO); EuroAmount))<1;"Pendiente";
 "Entregado"));
 "Status1";
 If(IsBlankOrError(Sum(Filter('[dbo].[tbWarehouseDetails]';IdPO = IdPO);Amount)) ;0;
 Sum(Filter('[dbo].[tbWarehouseDetails]';IdPO = IdPO);Amount)/Sum(Filter('[dbo].[tbPODetails]'; IdPO = IdPO); EuroAmount))
))

The issue is on the columns "Status" and "Status1" because all records in the gallery show the same value and isn't update in each one for his own "IdPO".

Anyone know why?

Thank you.

Categories:

Building Power Apps