Getting the latest Approval Date from three Approvers

[ExtraRice]

Hello,

I am having a hard time to get the latest date of approval from the three approvers set on parallel approval in flow.

I wanted to get the latest approved date so that once the last approver approve the request, it will trigger the next approval flow..

Many thanks.

[v-jefferni · Accepted solution]

Hi @ExtraRice ,

Well, the solution is to use 2 conditions:

1. Condition1: compare variable 1 and 2, get the later one and store in variable 4.

2. Condition2: compare variable 4 and 3, get the later one which is the latest of the three.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[takolota · Accepted solution]

You should also be able to use the Max(date1, date2, date3) expression for this.

If the Max function doesn’t allow dates, then just use ticks, so 

addSeconds('0001-01-01',div(max(ticks(date1), ticks(date2), ticks(date3))),10000000))