Marking a Task as complete via Patch()

(0) Share

Report

Posted on by Spinner

101

I'm trying to use Patch to mark a Task row as Completed, following this method:

Patch(Tasks,MyTask,{'Status Reason':'Status Reason (Tasks)'.Completed, 'Activity Status':'Activity Status (Tasks)'.Completed})

Instead, I get this error:

Error: Key statecode with type State/Microsoft.PowerFx.Types.OptionSetValueType is not supported yet.

I can use Patch to update another Task column of the Task. Any ideas on how to do so for the status columns?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

v-jefferni on at

Like (0)

Report
Re: Marking a Task as complete via Patch()

Hi @Spinner ,

As it is said in the solution, you need to update two columns statecode and status code at the same time:

Patch(Tasks,MyTask,{statuscode:'Status Reason (Tasks)'.Completed, statecode:'Activity Status (Tasks)'.Completed})

Best regards,

Was this reply helpful? Yes No
Spinner 101 on at

Like (0)

Report

Re: Marking a Task as complete via Patch()

@v-jefferni That's what I'm trying to do, as shown in my code above. Yet it fails with that error.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Re: Marking a Task as complete via Patch()

Hi @Spinner ,

I can use both your and my formulas to update the task status reason column with no problem:

What's the variable MyTask? How does it get created?

Best regards,

Was this reply helpful? Yes No
Spinner 101 on at

Like (0)

Report
Re: Marking a Task as complete via Patch()

@v-jefferni It's actually a placeholder to simplify the problem presented. My actual code contains a LookUp instead, as follows:

Patch(Tasks,LookUp(Tasks,Task=GUID(TaskID)),{'Status Reason':'Status Reason (Tasks)'.Completed, 'Activity Status':'Activity Status (Tasks)'.Completed})

The LookUp() call works elsewhere so I don't see it causing an issue here.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Re: Marking a Task as complete via Patch()

Hi @Spinner ,

Then what is TaskID? Where does it come from?

Best regards,

Was this reply helpful? Yes No
Spinner 101 on at

Like (0)

Report

Re: Marking a Task as complete via Patch()

It's the GUID of the Task record - the record's standard unique identifier.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Re: Marking a Task as complete via Patch()

Hi @Spinner ,

I still cannot reproduce this issue. Please consider raise a ticket on Power Platform Admin Center:

Help + support | Power Platform admin center (microsoft.com)

Best regards,

Was this reply helpful? Yes No
Spinner 101 on at

Like (0)

Report

Re: Marking a Task as complete via Patch()

I wonder if it is linked to the fact that this is being done from a Card for PowerApps. The documentation does not seem to indicate that there is any restriction on how Patch() works but maybe there is a bug.

Was this reply helpful? Yes No
Spinner 101 on at

Like (0)

Report

Re: Marking a Task as complete via Patch()

Hello @v-jefferni ,

Does your code work in Cards for PowerApps as well as regular PowerApps?

Was this reply helpful? Yes No