Hello,
i do have two Dataverse Tables,
Nr. 1 "Stock List" and Nr. 2 "Stock Movement"
in My Powerapp i have a Starting Page, showing all Items in a Gallery.
I want to filter this Gallery, to remove items with 0 Stock.
To achieve this, i switched from directly calculating the Stock in a Label via Summary of Stock Movement items per Gallery Item(which worked without any problem) to a Collection - as i was not able to filter for Label.Value(Text)
What i want is a collection, generated from Stock_List, adding the Stock Column, then moving trough stock Movement list, and summarizing all movements, write the result into collection as Stock.
i played around for 2 hours now without any working solution..
this is my latest code, showing no error, but is not working 😄
can someone help me out?
ClearCollect(
col_stock;
AddColumns(
Stock_List;
"Stock";
""
)
);;
ForAll(
col_stock;
{
Stock: Sum(
Filter(
Stock_movement;
Stock_movement [@MatNumber] = col_stock [@MatNumber]
);
Amount
)
}
)
