With(
{
_Item:
Split(
ThisItem.QRCode,
"#"
)
},
Patch(
colRecord,
ThisItem,
{
Material: First(_Item).Value,
Lot: Index(_Item, 2).Value,
ExpiryDate: Last(_Item).Value
}
)
)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.