Flow is skipping over variable

[lardo5150]

In my SPO list, I have a flow that is using Microsoft Graph and grabbing teams presence.

The SPO List will have the following columns.

Activity, Availability,TimeStampofState,TimeInState

I am grabbing activity and availability and then marking the TimeStampofState with current date/time.

When it runs again, it checks to see if the status has changed.

if it has, it stamps the TimeStampofState.

If the status has NOT changed, it will take the current time, subtract the TimeStampofState, to give me how long they have been in that state.

This is working....except for half of my SPO List.

I am finding that it is randomly doing this for people in my SPO List.

I am getting the current time

{

  "body": "2022-08-23 19:33:17Z"

}

I then take that current time and use ticks and set it to minutes.

DIV(ticks(body('Convert_time_zone_2')),600000000)

This is my StartDate

I then grab the TimeStampofState from SPO and do the same thing:

DIV(ticks(body('Convert_time_zone_3')),600000000)

In the flow the conversion is this for my non working example:

StartDate - 

1063281333

EndDate - 

1063281329

Now, I SET a variable, to do the difference:

 

sub(variables('StartDate'),variables('EndDate'))

For some of the people in SPOList, it will subtract the two numbers.

For others, I am seeing this:

It is like it is loading up the variable with only the enddate, thus giving me the negative enddate number.  It seems to forget the StartDate.  That value is just my enddate with a negative symbol in front of it.

I can't figure out why this is happening.

Again, same list for all, works for some others no.

[lardo5150]

So I had concurency set to 20.

when I took this off, the flow went from running in 10 seconds, to taking 3 minutes, but I did not have the issue above.

Any way to speed this up, and not lose functionality of my varaible?

[lardo5150 · Accepted solution]

I resolved this by getting rid of the set variables and using compose.

I then could turn on concurrency and all is working.

Seems set variable is affected by that, but not compose.