cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TrulsB
Helper III
Helper III

Automate updating CDS Entity is running continius

I have an Automate that updates a field in the Common Data Service.
The automate process calculates the week number, day of the week, etc. based on a date and updates the fields for week number, day of the week (text) and month (text).
I experience that the flow is continuous, even if no one uses the application, or updates data in any other way.

 

The trigger is: Wen a entry is created, changed or deleted.

d.cds-1.PNGcds-2.PNGcds-3.PNG

I need input on how I can avoid the flow going every single second, when the application is not in use.

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @TrulsB :

Firstly, let me explain why you encountered this problem.

The key is that this flow falls into an infinite loop. Any update to Produksjon will trigger this flow, and every time this flow runs, Produksjon will be updated.

Secondly, I suggest you add a conditional action to this flow.

Before executing Update a record, determine whether ProdukXXX and ProdukZZZ in the return value of trigger are equal to the value you want to update. Something like this:

v-bofeng-msft_0-1605253913940.jpeg

 

In this way, the second cycle triggered by the Update a record action will no longer execute "Update a record". The cycle will be interrupted.

Best Regards,

Bof

View solution in original post

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @TrulsB :

Firstly, let me explain why you encountered this problem.

The key is that this flow falls into an infinite loop. Any update to Produksjon will trigger this flow, and every time this flow runs, Produksjon will be updated.

Secondly, I suggest you add a conditional action to this flow.

Before executing Update a record, determine whether ProdukXXX and ProdukZZZ in the return value of trigger are equal to the value you want to update. Something like this:

v-bofeng-msft_0-1605253913940.jpeg

 

In this way, the second cycle triggered by the Update a record action will no longer execute "Update a record". The cycle will be interrupted.

Best Regards,

Bof

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (26,113)