I have a flow that is supposed to trigger every time a specific column is changed.
My issue is that the "Get changes for an item or a file (properties only)" action is inconsistent with the data it pulls and it causes the flow to fire more often than it should. Sometimes it pulls a version range of 2 (the Current Version and the version directly prior) and sometimes it pulls 3 (the Current Version and 2 versions directly prior).
I had a file with the following version history:
Modified Date | Modified Time | Version Number | Specified column was changed |
9/17/2023 | 12:32 AM | 34 | No |
9/17/2023 | 12:45 AM | 35 | No |
9/17/2023 | 1:08 AM | 36 | Yes |
9/21/2023 | 10:31 AM | 37 | No |
9/21/2023 | 10:43 AM | 38 | No |
9/21/2023 | 10:49 AM | 39 | No |
Even though my specified column has not changed since 9/17/2023, my flow was triggered twice today (9/21/2023).
From what I can tell it is because the "Since Version Number" sometimes pulls too far back.
See Run History:
Run Date | Run Time | Since Version Number | Until Version | Has Column Changed: Column Name | |
9/21/2023 | 10:24:36 AM | 36.0 | 37.0 | No | |
9/21/2023 | 10:29:51 AM | 35.0 | 37.0 | Yes | Triggered Flow |
9/21/2023 | 10:30:21 AM | 36.0 | 37.0 | No | |
9/21/2023 | 10:31:39 AM | 35.0 | 37.0 | Yes | Triggered Flow |
9/21/2023 | 10:36:57 AM | 37.0 | 38.0 | No | |
9/21/2023 | 10:38:26 AM | 37.0 | 38.0 | No | |
9/21/2023 | 10:39:17 AM | 36.0 | 38.0 | No | |
9/21/2023 | 10:40:17 AM | 36.0 | 38.0 | No | |
9/21/2023 | 10:42:31 AM | 36.0 | 38.0 | No | |
9/21/2023 | 10:43:33 AM | 36.0 | 38.0 | No | |
9/21/2023 | 10:44:21 AM | 37.0 | 38.0 | No |
The run at 10:24:36 AM on 9/21/22023 ran as expected, but then the runs after that at 10:29:51 AM and 10:31:39 AM suddenly pulled older version numbers. I am at a complete loss.
Why is this happening? what can I do to change this?
Still in need of some help. @FLMike, can you assist?
@trice602 - might you be able to help?
Yes, the trigger condition is set to "Has Column Changed: Column Name" is equal to "true".
The problem is not the condition but the output from the "Get changes for an item or a file (properties only)" action.
If you look at my table in the original post you will see sometimes it pulls the past 2 file versions and sometimes the last three.
Did you consider trigger conditions?
Trigger conditions - just what I needed - Powering your Apps (sudeepghatak.com)