Unanswered

PowerApps, Flow, SharePoint - Sending approval email to a list of users [Parallel Approval]

(1) Share

Report

Posted on by davidcastillo

Hi,

I'm trying to create a parallel approval process via Flow which works out fine because of Flow's parallel action functionality. Basically here is what I want the workflow to happen:

1. User fills out form and submits info via PowerApps (I have one column named "Approvers" which is actually a multiple person selection)

2. Flow trigger sends PowerApps data to SharePoint

3. Flow gets data from "Approvers" field from SharePoint

4. Flow sends approval email to all people included in that list via Outlook connector

5. When all approvers approved the transaction, send email to user on the approved transaction

Take note I did not include here the details such as SharePoint's status per item should be updated every step of the way (Approved, DIsapproved, Postponed, etc.) as I only need to know how to go about using PowerApps to have that functionality.

Another question is, if that is not possible, is there also a way in PowerApps in which there will be a + field to add approvers so I don't need to multi-select? I think this one is much more flexible and at the very least I can include people not currently in my organization to approve (our company has Google and Microsoft emails).

Any help would be appreciated. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!

Hi @davidcastillo,

Notice that in flow send an approval email action, the To field has this notification:

If you includ multiple approvers in one PowerApps output and fill it in the To field, this flow will fail. So this is not possible so far. You have to includ one approver in one PowerApps output and put each one in the To field. If you want to have multiple outputs, you can separate them by semicolons.

Regards,

Mona

Was this reply helpful? Yes No
davidcastillo 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your reply, @v-monli-msft. How about declaring a variable and storing the email there? Is this possible?

Was this reply helpful? Yes No
bean 568 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes - You can store emails to a variable and use that variable in the approval node.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I also need to know how to create this flow. Managers want to approve from email which would show up in PowerApp and SP

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I also need to create a similar flow so will be looking forward to the solution.

One more think that we need added is a pause in the flow until 1st approver responds, then goes to 2nd approver and pauses until 2nd approver responds. Finally, when 3rd (and final) approver responds,record reaponse in Status SP list colum and PowerApp field as completed. The final email is sent to all listed in flow with notification flow has been completed and status.

Was this reply helpful? Yes No
davidcastillo 18 on at

Like
a
(0)

Report
Copy link

Link copied!

@bean, thanks for the reply. Apologies for the late response to this thread also. I'll test that out this week or early next week and will update the thread if indeed that I can store emails in a variable and have that variable be entered in Outlook's action node.

Was this reply helpful? Yes No