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

All responses (12)

Answers (1)

Verified answer

Jorge S on at

Like (0)

Report

RE: Multiple instances of real time workflow update same field

I solved it by updating the record prior to the main update.

thanks for your replies
Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: Multiple instances of real time workflow update same field

All 250 records are updating same Leave entitlement record?
Jorge S on at

Like (0)

Report

RE: Multiple instances of real time workflow update same field

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.
Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: Multiple instances of real time workflow update same field

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.
Jorge S on at

Like (0)

Report

RE: Multiple instances of real time workflow update same field

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

Like (0)

Report

RE: Multiple instances of real time workflow update same field

Hi, increment by is the only operation I do in the workflow. There is only the required check before the increment.
Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: Multiple instances of real time workflow update same field

You can set increment before any other operation.
Rawish Kumar 13,758 on at

Like (1)

Report

RE: Multiple instances of real time workflow update same field

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.
Jorge S on at

Like (0)

Report

RE: Multiple instances of real time workflow update same field

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
Jorge S on at

Like (0)

Report

RE: Multiple instances of real time workflow update same field

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.