cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Knivy
Frequent Visitor

Dataverse When a row is added, modified or deleted triggering intermittently

I have a flow that uses the Update step on the Dataverse 'when a row is added, modified or deleted action' to trigger but it seems to be triggering intermittently. I know that this flow hasn't triggered on all of my records because it should be updating fields on the record which triggers it and I have audit history turned on for that record.

 

I have no failed runs, failed checks or checks (no new data), either flow runs or it doesn't trigger at all.

 

My environment is a sandbox enviornment with admin mode turned on and background processes are turned on.

 

On the occasions when the flow runs it doesn't fail, it runs without an issue.

 

Dataverse Trigger.PNG

2 REPLIES 2
ManishJain
Solution Sage
Solution Sage

Hi @Knivy ,

 

You have added column filter as statuscode which says this flow will only trigger if the statuscode is changed on those records, otherwise it wont. Please look at the records for which it did not trigger and see if the field value changes that took on those records.

 

Thanks

Knivy
Frequent Visitor

Hi @ManishJain,

 

Yes that is the issue, the statuscode was being updated but the flow wasn't triggering, apologies for not making that clear in my initial post.

 

I spoke to microsoft about this and apparently on occasion when the status reason updates rather than running an update step it runs an activate step, which isn't picked up by the flow.

Record activate.PNG

To combat this I created a workflow that on status change of this record updates another field and added that field into my column filters. This worked for some records but not for all, I'm not sure how to rectify this.

 

Please see below the audit history where the flow was triggered:

Record triggered.PNG

And the audit history for the record where it was not triggered:

Record not triggered.PNG

They look exactly the same to me so I don't understand why one triggered and one didn't.

 

Any help would be much appreciated

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,569)