I am new to Powerapps. I am building app on Power Apps for Teams invironment. I am trying to Patch the new record/change to the collection and give me this error "Invalid argument type (Table). Expecting a Record value instead.".
Patch funtion when user press Save button
Set(
dataSaved,
true
);
Patch(
'Work Progress Trackings',
colTaskUpdates
);
Clear(colTaskUpdates);
Set(
X1,
0
);
Notify(
"Your grid changes have been successfully saved",
NotificationType.Success,
2000
)
Run on App "Onstart"
ClearCollect(
colTaskUpdates,
Defaults('Work Progress Trackings')
);
Clear(colTaskUpdates);
Set(
dataSaved,
true
);
Onchange funtion on the field box
If(
ThisItem.'Work Progress Tracking' in colTaskUpdates.'Work Progress Tracking',
Update(
colTaskUpdates,
LookUp(
colTaskUpdates,
'Work Progress Tracking' = ThisItem.'Work Progress Tracking'
),
{
'Work Progress Tracking': ThisItem.'Work Progress Tracking',
Description: description.Value,
'Due Date': date.Value,
Progress: progress.Selected.Value,
Priority: priority.Selected.Value,
'Work Item': workitem.Value,
Category: category.SelectedItems,
'Assigned To': person.Selected.Mail,
'Assigned To Display Name': person.Selected.DisplayName
}
),
Collect(
colTaskUpdates,
{
'Work Progress Tracking': ThisItem.'Work Progress Tracking',
Description: description.Value,
'Due Date': date.Value,
Progress: progress.Selected.Value,
Priority: priority.Selected.Value,
'Work Item': workitem.Value,
Category: category.SelectedItems,
'Assigned To': person.Selected.Mail,
'Assigned To Display Name': person.Selected.DisplayName
}
)
);
Thank you in advance
