Afternoon All,
So I have a simplistic set of dummy data which replicates my problem:
| UniqueID | Name | Date |
| 200379131 | Alpha | 2020-04-08 09:24:00 |
| 200397199 | Beta | 2020-04-13 14:35:00 |
| 200415040 | Gamma | 2020-04-18 08:20:00 |
| 200436155 | Delta | 2020-04-24 03:30:00 |
The idea being that this is part of a much larger list and the in the list, I need to reference back to the last UniqueID and see how many days it has been. This list has greater then 1000 lookups but decided to minimize to make sure I am doing it correctly after realizing i had an error.
I have the flow setup so that I am cross referencing via an append, and ignoring the rows where the UniqueID is the same and if they are not the same, calculate out the number of days between them. This works okay.
I then run a loop where I find via the summarize tool the minimum number of days for each one and join this back to the list of appended, but here is the problem, when asking the tool to calculate the minimum number of days, for 2 it works, for the last row, it gives me the maximum despite clearly a smaller number being present.
Flow attached.
What have i missed or is this a bug?
Thanks
