Answered

Patching "Status" column of dataverse

(0) Share

Report

Posted on by ynaing

I would like to patch a record making status "Inactive".

But it shows error "Network error when using Patch function: The specified column generated by the server and can't be specified."

Is there any way to patch the "Status" and "Status Reason" columns?

My code is as follow:

 Patch(
 'Service Options',
 Defaults('Service Options'),
 {
 Service: "Field App",
 Option: "Upload / Download Fail",
 Status: 'Status (Service Options)'.Inactive,
 'Status Reason': 'Status Reason (Service Options)'.'Incomplete Information'
 }
 )

I don't want to make default "Status" as "Inactive".

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (4)

Report
Copy link

Link copied!
Hi @ynaing,

Yes you can Patch a record as inactive but it cannot be done on create, it must be done after the record is created. So first created the record and then you can update it as inactive like this:

Patch('Service Options', Patch( 'Service Options', Defaults('Service Options'), { Service: "Field App", Option: "Upload / Download Fail" } ), { Status: 'Status (Service Options)'.Inactive, 'Status Reason': 'Status Reason (Service Options)'.'Incomplete Information' } )

You can also update directly if the item is selected from a gallery meaning it has already been created:

Patch('Service Options', MyGallery.Selected, { Service: "Field App", Option: "Upload / Download Fail" Status: 'Status (Service Options)'.Inactive, 'Status Reason': 'Status Reason (Service Options)'.'Incomplete Information' } )

Hope this helps!

Was this reply helpful? Yes No
ynaing 91 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your answer.

Was this reply helpful? Yes No