News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Automate updating CDS ...

Power Automate - Using Flows

Answered

Automate updating CDS Entity is running continius

(0) Share

Report

Report

Posted on by TrulsB

144

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.

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

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: Automate updating CDS Entity is running continius

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:

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

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,668 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans