ForAll(
Table1 As _T1,
With(
{
_Data:
LookUp(
Table2,
ID = _T1.ID
)
},
If(
_Data.Quantity <> _T1.Quantity || _Data.Date <> _T1.Date,
Collect(
colDiff,
{
ID: _T1.ID,
Name: _T1.Name,
Quantity: _T1.Quantity,
Quantity2: _Data.Quantity,
Date: _T1.Date,
Date2: _Data.Date
}
)
)
)
)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.