Problem: The flow posts the same comment on two consecutive days, even though it is supposed to post only once.
- I created a flow that posts a comment to notify users that their case will be closed if no action is taken.
- Flow action: Search for all cases that have been resolved for 20 days.
- Condition: Case status is "Resolved" and 19 days < "Resolved At" < 21 days.
- Trigger: Every day at 23:30:00.
The flow correctly identifies the relevant cases, but it posts the comment on the same day and the following day. When I checked a case updated twice by the flow, the dates were 14/10/2024 and 15/10/2024. However, my colleague (in another city) sees different dates: 15/10/2024 and 16/10/2024.
Temporary solution: I created a custom date field that gets updated when the flow posts the comment, and I added a condition to prevent the flow from updating the record if this date is less than 24 hours old.
I'm looking for a more practical solution, possibly a default feature in ServiceNow. Has anyone encountered a similar issue?
