Power Platform Community Forum Thread Details

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?

Categories:

General topics