Hi
So you have 2 possible things
1) That your LookUp is returning NO row and therefor it updates nothing
2) that your variables are bad and have no data, BUT if that's the case, I would expect that in the SharePoint List, the values would be blank.
3) Lookup columns are garbage, never use them, like ever, no matter who tells you they rock they do NOT. Simply map the ID of the Row in the other table into this table, and then if you have to, do a lookup to pull its value. In your code, you could simply do a lookup to the other table, even in what you have to set the LookUp value, versus trying to do it like a record. Again.... they... are ... horrible... never... use them...
So I believe its #1 not #2.
So how do you validate this first.
Change your code to do this
What this will do is first pull back the record IF there is one that you want to patch.
If its there then it will patch, and it will TELL you that it was in the Patch section of the IsBlank check
If its Not there, meaning your LookUp didnt find a record, then it will tell you that.
then we can figure out why your fmr_Fleet.LastSubmit.ID is bad.
With(
{TimeCardRecord: LookUp('Truck Driver Time Card', ID = frm_Fleet.LastSubmit.ID) },
If(!IsBlank(TimeCardRecord),
Patch('Truck Driver Time Card',LookUp('Truck Driver Time Card', ID = frm_Fleet.LastSubmit.ID),
{
'Driver Name': {
Id: varDriver.ID,
Value: varDriver.'Full Name'
},
'Vehicle Type': {
Id: varVehicleType.ID,
Value: varVehicleType.'Vehicle Type'
},
Vehicle: {
Id: varVehicle.ID,
Value: varVehicle.'Vehicle Details'
}
}
);
Notify("Form Submitted Successfully!",NotificationType.Success);
ResetForm(frm_Fleet);
Navigate(scr_Fleet_Main);
Set(varDriver, Blank());
Set(varVehicleType, Blank());
Set(varVehicle, Blank());
,
Notify("ID was Blank so record returned from LookUp")
)
);
