Help narrowing down When a record is created, updated or deleted

(0) Share

Report

Posted on by Cooper01

664

I am creating an automated flow using the CDS trigger When a record is created, updated or deleted.

The crossed out value is the internal name for a text field on the entity. What I want to happen is that every time this value changes, a different record is created in a separate entity. This is working fine.

What is happening is that every time the data refreshes between my SQL table and the entity, the flow is triggered

Is there a way to narrow this down so that I can only get actual value changes? Not sure if there's a better trigger or I should be using a filter expression...

All responses (1)

Answers (0)

DeepakS 2,301 Most Valuable Professional on at

Like (0)

Report

Re: Help narrowing down When a record is created, updated or deleted

Hi @Cooper01

It seems data refresh is triggering the update trigger.
here is what i would suggest :
Option 1)
- Add a new field in CDS entity to track the changes (so when actual value updated set this field to true else false)
- on your trigger check if new field is true if yes create new record else ignore

Option 2)
- On Create Record - Check if the record already exist before creating new one.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.