Flow Designer flow triggered on first update only

Renee-17 · ‎06-18-2024

Created a trigger in flow designer.

Trigger fires off when table is updated and a value in the OutOfStock field changes to Y or QuantityOnStock changes 0. I've specified this trigger to run (For Every update) and also tried (For each unique change).

I have a record in the table for test. The very first time the OutOfStock value was changed to Y, it sent a notification as designed.

In testing the same record, I changed the value to N and then changed it back to Y. I was expecting to see another notification, but didn't see any.

Is there some rule, that says it will only fire once for each record?

Zach Koch · ‎06-18-2024

Before doing anything, ensure that your flow is being reported on.

Go to your Flow in Flow Designer, click the three dots, click Flow reporing settings

If it's not already, turn it on Full

Next, click the three dots again, then click on Executions

It will take you to a list view of your flow executions. Sort by created. Click on into the record, and it will take you to another record. Click the Open In Operations View related link

This will take you to the context view of your flow in flow designer

Meet your conditions for the flow to fire, check your flow contexts, fire it again, ensure that it ran again.

If this information helped resolve your issue, please remember to mark response correct and thumbs up to help future community members on this information, thanks!

View solution in original post

Zach Koch · ‎06-19-2024

If the notification subject is the same, then then one way might be to query the sys_email table, and look to see if a notification was already sent in a time span with a query such as:

and if it finds a record with this query, don't send it. You could adjust the time to whatever you desire, and you should be able to prevent sending the notifications within that period.

If this information helped resolve your issue, please remember to mark response correct and thumbs up to help future community members on this information, thanks!