Hi @MaxWendorff ,
Could you please share more details about your scenario?
Do you want to move part amount from one location to another location?
If you want to move part amount from one location to another location, I think there is something wrong with the Collect formula that you mentioned. I have made a test on my side, please consider modify your formula as below:
If(
!IsBlank(LookUp(InventoryData, Title = StartLocation.Text && PN = PartNumber.Text)),
Patch( // Modify formula here. Modify QTY value in your New location within your InventoryData
InventoryData,
LookUp(InventoryData, Title = NewLocation.Text && PN = PartNumber.Text),
{
QTY: QTY + Value(QuantityOut.Text)
}
);UpdateIf(
InventoryData,
Title = StartLocation.Text && PN = PartNumber.Text,
{
QTY: QTY - Value(QuantityOut.Text),
'Last Scan': Now(),
User: "Name"
}
)
)
Please consider take a try with above solution, check if the issue is solved.
Note: The Collect function is used to add a new record into a data source rather than modify existing records in data source.
More details about the Patch function, please check the following article:
Patch function
Best regards,
