I have created a list for keeping the temporary activity of this record and then if it approves, I will update it back to the main list. Because of the Temporary activity list, I create the field name "Temp_ID" to collect the unique ID.
After the user approves, I lookup it to patch in user_request_form
where Log_Activity>>>Record what happens
Temp_ID>>>fied name that collect the id from user_request_form
ForAll(
RenameColumns(
Filter(
CollectApp,
IsChoosen = true
),
"Temp_ID",
"Temp_ID"
),
Patch(
User_Request_Form,
LookUp(
User_Request_Form,
ID = Temp_ID
),
{
Note: "TEST",
Status: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: 1,
Value: "Activated"
}
}
)
);
Everything is fine.
Every line is patch.
but
