Experts,
The goal is to prevent delivering duplicate data to the table from the collection.
As a result, I'm attempting to exclude the collection row if it has value 4 in statusc column.
My formula is as follows:
Collection : DailyinventoryL
Table : Dailyinventory
---------------------
Collection view :
------------
According to the formula below, Forall formula should eliminate column sno 1 and 2 since they have status 4 and the remaining row like sno3 which status is blank should be sent to the table.
--------------
ForAll( Filter(DailyinventoryL, Not(4 in DailyinventoryL.statusc )),
Patch(
Dailyinventory,
Defaults(Dailyinventory),
{
crf99_materialno: Materialno,
crf99_materialdesc: Materialdesc,
crf99_plant: plant,
crf99_qty: Qty,
crf99_bbd: BBD
}
)
);
Set(
varNotifytest9,
"Transmit Completed"
);
Set(Varlastno1 ,
First(
FirstN(Sort(DailyinventoryL,sno, Descending),
1
)
).sno);
UpdateIf(DailyinventoryL, 'Created On' = Today() , {statusc: 4});
above formula is not working as expected. Friends please your thoughts.
