Approval Flow

Like (1) Share

Report

Posted on 7 May 2016 12:16:15 by Roberts2727

193

Hello,

I created a 3 stage approval flow using the new flow tools, currently I have all three of the results from the previous approvers being mailed to me, I evaluate and if 2 of the 3 approvers approve then I hit the approve button on the fourth approval mail that kicks off the move from my proposed sharepoint list to my approved list and deletes the item in the proposed list. Working amazingly well! What I would like to do is use a conditional paramater to evaluate the result of the first 3 emails so that there is no manual intervention needed. Possible? I guess the question is does the conditional paramater accept an evaluation argument?

I have the same question (0)

All responses (10)

Answers (0)

Roberts2727 193 on 11 May 2016 at 15:33:04

Like (0)

Report

Re: Approval Flow

Ok, I have edited the flow to write the results to an excel file with 2 columns named approved and denied, as well as a few other fields like title, assigned to email, and description for tracking purposes.
Next I run a get rows command and specify to retrieve all of the rows in the spreadsheet.
Next I have a condition

@greaterOrEquals(body('Get_rows')['Approved'], 2)

if yes create item
if no send email

Is that the appropriate logic for the condition to evaluate the approved columns?

Was this reply helpful? Yes No
Roberts2727 193 on 10 May 2016 at 19:26:15

Like (0)

Report

Re: Approval Flow

I do not mind storing in an excel file. I will attempt this and get back with you.

Was this reply helpful? Yes No
Sunay on 10 May 2016 at 18:53:48

Like (1)

Report

Re: Approval Flow

I checked, the way it works today is that as soon as any one of the approvers approve the flow will continue. This wouldn't work since flows are inherently stateless.
We do plan to light up the For-each feature very soon (~2 weeks), which will make this scenario possible.
Alternatively, you can choose to store the state in an excel file and if conditions are satisfied copy over the item

Was this reply helpful? Yes No
Roberts2727 193 on 10 May 2016 at 16:36:42

Like (0)

Report

Re: Approval Flow

@Sunay

First stage mails 3 approvers, if 2 of the 3 approve, then I want to move from the proposed to the approved list.

Was this reply helpful? Yes No
Sunay on 10 May 2016 at 16:16:45

Like (0)

Report

Re: Approval Flow

@Roberts2727 I think I understand your scenario. Your approval flow basically needs 2 approvals in stage 1 and then 1 approval in stage 2 for the copy to happen.
Let me look into it. I will update the thread soon.

Was this reply helpful? Yes No
Roberts2727 193 on 10 May 2016 at 14:14:52

Like (0)

Report

Re: Approval Flow

@Sunay Is Staff available to help, I have been working on this for a while and cannot figure it out! Thanks in advance. I understand if its not possible.

Was this reply helpful? Yes No
Roberts2727 193 on 09 May 2016 at 20:03:17

Like (0)

Report

Re: Approval Flow

Still not quite there...

@or(equals(body('Send_approval_email,Send_approval_email_2')['SelectedOption'], 'Approve'), equals(body('Send_approval_email,Send_approval_email_3')['SelectedOption'], 'Approve'), equals(body('Send_approval_email_2,Send_approval_email_3')['SelectedOption'], 'Approve'))

Was this reply helpful? Yes No
Roberts2727 193 on 09 May 2016 at 17:43:00

Like (0)

Report

Re: Approval Flow

When a new item is created in my list I want 3 approval emails to go out, then I want the conditional parameter to evaluate the responses, if 2 of the 3 = Approve then Yes, if not then no.

Was this reply helpful? Yes No
flowuser 24 on 09 May 2016 at 16:47:49

Like (1)

Report

Re: Approval Flow

Format for logical and/or is basically @and(condition, or(condition, condition))

I don't quite understand what you're doing though, so I'll just leave it at that.

Was this reply helpful? Yes No
Roberts2727 193 on 09 May 2016 at 15:52:08

Like (0)

Report

Re: Approval Flow

@equals(body('Send_approval_email')['SelectedOption'], 'Approve')
and
@equals(body('Send_approval_email_2')['SelectedOption'], 'Approve')
or
@equals(body('Send_approval_email')['SelectedOption'], 'Approve')
and
@equals(body('Send_approval_email_3')['SelectedOption'], 'Approve')
or
@equals(body('Send_approval_email_2')['SelectedOption'], 'Approve')
and
@equals(body('Send_approval_email_3')['SelectedOption'], 'Approve')

Anyone that can help me make something like the above work?

Was this reply helpful? Yes No