I am building a flow, where I want to find max value of a specific column in excel (e. g. project number) and add new row with incremented value. I don't want to use formula in table, because this field doesn't follow strict autoincrement formula (each month some suffix is added, but the rule that max value is latest project number is valid).
What is working:
- I can get latest (highest) project number and increment it
- I can add new row with incremented project number and I can see it it the document I have opened for preview
- I can access the value that was stored in the new row and use it in further flow steps
So basically everything seems to be working, but I noticed that triggering the same flow again shortly after previous one was completed doesn't seem to find the newly added row (even though I can see it in online editor of this file, which is irrelevant of the powerautomate - from this I conclude that the file was saved).
I use "List rows present in a table" step with Top count "1" and Order by "Number desc" and it still returns previous highest number and causes the same number to be reused for another row. When I wait between executions it runs smoothly, but I want to make sure that people triggering automation asynchronously won't cause any issues. Is there any way to force reload before searching for the top row or what is the issue here?