Answered

D365 FO Execute action - Workflow Workitem complete - Error

(2) Share

Report

Posted on by PratikK

Hello All,

I am trying to complete D365 Workflow Workitem using Power Automate. I am using D365 Execute action and its failing continuously. Can anyone please help .

Error -

An error has occurred. Exception occurred while executing action complete on Entity WorkflowWorkItem: Unable to complete because action is not in a state that can be completed. Exception has been thrown by the target of an invocation.
clientRequestId: 1ad7232a-0b7f-41df-9dca-423a7ceef526

Steps to reproduce the issue -

Create flow with template - Complete Dynamics 365 for Finance and Operations workflow work items (PU29)
Assign D365 workflow workitem as trigger
Submit D365 FO workflow used as trigger above
It will trigger this flow and try to complete workitem in D365 (which is failing)

I am facing same issue for multiple clients and raised support case with MS support as well but no resolution yet.

Categories:

Building flows

I have the same question (1)

All responses (15)

Answers (1)

Sort by

AbdulAleem810 2 on at

Like (1)

Report
Copy link

Link copied!

Hi Pratik, did you got the solution for this problem? I am facing this too.

Was this reply helpful? Yes No
SteveMcGraw 19 on at

Like (1)

Report
Copy link

Link copied!

Same here, this issue started shortly after the 10.0.39 F&O update. We noticed that if the workflow is in stopped status, approvals are successful. The issue appears to be related to the validation function on WorkflowWorkItem. It is driving us crazy. If you find a resolution please let us know.

Was this reply helpful? Yes No
Verified answer

SteveMcGraw 19 on at

Like (1)

Report
Copy link

Link copied!

Ok so our wonderful consultant figured this out for us. Here is what he wrote:

There is a MS standard bug which I found in the class “VendInvoiceWorkflowValidation”.
It is taking the invoice as duplication record and make the flag “isInvoiceNumberfreeForUse” = false
That is the reason it is throwing error that “Unable to complete because action is not in a state that can be completed.”

Basically the complete action includes a validation, the validation sees its own invoice number, and since the invoice is under review, the validation fails.

He also said that we don't have access to touch this code ourselves and will have to wait on a fix from Microsoft. I am putting in a ticket now.

Was this reply helpful? Yes No
PratikK 40 on at

Like (1)

Report
Copy link

Link copied!

@SteveMcGraw - That's great! I also have ticket open with Microsoft for serveral month. I will let them know these steps. Hope to get it fixed soon.

Was this reply helpful? Yes No
SteveMcGraw 19 on at

Like (1)

Report
Copy link

Link copied!

Here is our microsoft ticket number. I included code screenshots of exactly where the validation fails in the referenced function: 2405010040002963

Was this reply helpful? Yes No
Justin Berry 10 on at

Like (1)

Report
Copy link

Link copied!

Adding our SR to the very same puppy pile, 2405030010004870... MS support has not had much to say as of yet...

Was this reply helpful? Yes No
SteveMcGraw 19 on at

Like (1)

Report
Copy link

Link copied!

Our consultant is going to meet with microsoft tech support and demonstrate the error in the code. Shout out to HSO, they do great work!

Was this reply helpful? Yes No
SteveMcGraw 19 on at

Like (1)

Report
Copy link

Link copied!

Bug submitted by MS support

Was this reply helpful? Yes No
Justin Berry 10 on at

Like (1)

Report
Copy link

Link copied!

I got them to submit a bug as well... There is a kill switch flight for the new code that they can enable to fix the issue, it's on the VendInvoiceCheckDupNumInRunningWorkflowFlight...

Was this reply helpful? Yes No
SteveMcGraw 19 on at

Like (1)

Report
Copy link

Link copied!

Thanks Justin, is that the fix or a workaround? I don't know what unintended consequences this would have. Thank you!

Was this reply helpful? Yes No