Multiple instances of real time workflow update same field

(0) Share

Report

Posted on by Jorge S

I've a real-time workflow that updates an integer field. The problem I have is when multiple instances of the workflow run at same time.

The first instance of the worklfow increments by 1 the integer field, but the second and later instnaces take the non updated value, i.e

First instance: Days = 1 -> workflow sets it to 2

Second instance: Days = 1 -> workflow sets it to 2 (Initial value should be 2 and updated value 3)

Third instance: Days = 1 -> workflow sets it to 2

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Suggested answer

Rawish Kumar 13,758 on at

Like (1)

Report

Hi Jorge,

if you cannot control these mutiple updates. I would suggest you to created a boolean field on the same entity & in your workflow when you are done with your logic , update this field to yes.

next before updating it on a trigger make sure you check if its not equal to yes then only proceed with update, otherwise stop the workflow.

hope it makes sense.

Was this reply helpful? Yes No
Dynamics365 Rocker 7,755 on at

Like (1)

Report

Can you please elaborate little more?

Is workflow is updating integer value in same entity or different one?

On which message your workflow get trigger?

Was this reply helpful? Yes No
Jorge S on at

Like (0)

Report

Hi Rawish, thnaks for your reply!

I thought of doing adding a boolean but waiting for the other instances to run until the value is Yes, but anyway all other waiting instances will run when the value changes again at same time, which will cause the same problem.

Was this reply helpful? Yes No
Jorge S on at

Like (0)

Report

The workflow only updates the field in one entity. It runs on a field change.

Related to Time entry and project approval of Dynamics PSA

Was this reply helpful? Yes No
Rawish Kumar 13,758 on at

Like (1)

Report

its a real time workflow - your update and this workflow will run in a single transaction. so all updates will have different transactions independent of each other.

Just play around with it - i am sure you will find a way.

Was this reply helpful? Yes No
Dynamics365 Rocker 7,755 on at

Like (0)

Report

You can set increment before any other operation.

Was this reply helpful? Yes No
Jorge S on at

Like (0)

Report

Hi, increment by is the only operation I do in the workflow. There is only the required check before the increment.

Was this reply helpful? Yes No
Jorge S on at

Like (0)

Report

It doesn't work as expected when multiple instances of the workflow run at same time.

Was this reply helpful? Yes No
Dynamics365 Rocker 7,755 on at

Like (0)

Report

First of all, I want to know that how multiple instances get execute?

As you said This workflow get execute when value of a field get change. It means user is changing value of a field very frequent.

If it is executing on multiple field change then I suggest you to create a separate workflow for each field change. it will resolve your problem.

Was this reply helpful? Yes No
Jorge S on at

Like (0)

Report

The workflow gets executed when the field ApprovedOn is updated. The user can select many records (up to 250) and approve all of them by cliking a button.

Was this reply helpful? Yes No