Inactivate a record in canvas app?

(0) Share

Report

Posted on by Cooper01

664

I am trying to inactivate a record through PowerApps using the standard Status field:

Patch(
 Employees,
 LookUp(
 Employees,
 pre_employeeid = SelectedEmployee.EmployeeId,
 {statecode: 'Status (Employees)'.Inactive,
 statuscode: 'Status Reason (Employees)'.Inactive}
 )
);

When running this (through OnSelect of button), I get an error: "statecode: The specified column is generated by the server and can't be specified."

I am not sure if statuscode is required in the patch but added it so the code and reason would align. Is there a different way I should be going about inactivating a record through the app?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Hamish Sheild 3,005 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Cooper01 ,

I think you might have your brackets in the wrong place. You have the statecode and status code inside the Lookup function. Try the following

Patch( Employees, LookUp( Employees, pre_employeeid = SelectedEmployee.EmployeeId), {statecode: 'Status (Employees)'.Inactive, statuscode: 'Status Reason (Employees)'.Inactive} );

Was this reply helpful? Yes No
Cooper01 664 on at

Like (1)

Report
Copy link

Link copied!

😳

Thank you. I did not need the Status Reason after fixing that, the update worked on statecode only

Was this reply helpful? Yes No