HI @GITC ,
Have you tried the solution I provided above?
Based on the issue that you mentioned, I think you have something misunderstanding within the Patch function. Regarding the needs that you mentioned, I think you want to update record listed in your Gallery, right?
If you want to update an existing record, the second argument of the Patch function should be tied to the specific record you want to update. So you should add a button inside your Gallery, then each item in this Gallery would own a button next to it. Set the OnSelect property of this button to following:
Patch(
'Your SP List',
LookUp('Your SP List', ID = ThisItem.ID), // find the specific record you want to update using LookUp function
{
'Job Status': {
Value: "WIP"
},
date_started: Now()
}
)
Note: I assume that the Gallery has been bind to your SP List data source already.
If you want to add a new record in your data source, please try the following formula:
Patch(
'Your SP List',
Defaults('Your SP List'),
{
'Job Status': {
Value: "WIP"
},
date_started: Now()
}
)
Note: If you do not specify Defaults() function as the second argument of the Patch function, instead, specify the record which is not existed in your SP List, it would also add new entry in your SP List.
Please try above formula carefully, then check if the issue is solved.
Patch function usage
Regards,
