Multiple Approval updates (Comment box on sharepoint)

(0) Share

Report

Posted on by shertech25

108

Hi!

Im doing up a flow for multiple approval, and each time when the approver approves, would need to reflect it under SharePoint's comment box. Currently, im only able to reflect the first's approval

First Approval:

Second Approval:

However, for the 2nd update after 2nd approval approved, i receive this error message

Any help is greatly appreciated!! Thank you 😄

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (0)

Sort by

PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

Where in the flow you are using Update List Item action? Also what approval property you are using to approve? Are you looping through responses?

Was this reply helpful? Yes No
shertech25 108 on at

Like (0)

Report
Copy link

Link copied!

Hi @PrasadAthalye

I would use Update List every time after an approval process (e.g Start and wait for approval -> Condition -> Update List)

Currently each approval is kind of "hard code" on the flow itself, but im also trying to figure out how to retrieve email/user from Approval List (another list on sharepoint)

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

Okay. Can you please upload screen shot of Update Action ? It appears that you are using Reponses array as against outcome..

Was this reply helpful? Yes No
shertech25 108 on at

Like (0)

Report
Copy link

Link copied!

This is my whole sequence:

replace(body('Create_HTML_table'),'<table>','<table border="1">')

Was this reply helpful? Yes No
shertech25 108 on at

Like (0)

Report
Copy link

Link copied!

I've also tried another method:

It will only reflect the first approver. Once the 2nd approver responded, it will become the one shown below (Approved By: Approve..)

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

okay. Approval Action has 2 outputs. If you have only single approver in the process, you can check outcome. But if you have multiple, you will have to work with Responses Collection. So you can not write a condition like 'Outcome' is Approve. Please refer below thread..

https://powerusers.microsoft.com/t5/Building-Flows/Issue-updating-list-item-after-approval-Flow/m-p/815802

You will have to loop through responses collection and use update item inside the loop...

Was this reply helpful? Yes No
shertech25 108 on at

Like (0)

Report
Copy link

Link copied!

So does that mean i cant use the select and table html method? Dont quite get the sequence exactly.

Was this reply helpful? Yes No
shertech25 108 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
PrasadAthalye on at

Like (0)

Report
Copy link

Link copied!

Instead of checking Outcome equals Approve, Check Response Approver Response property of approvals inside the loop.

Was this reply helpful? Yes No
shertech25 108 on at

Like (0)

Report
Copy link

Link copied!

Is this the way?

On a sidenote, im trying to retrieve the approver's e,ail via "Approval List" on sharepoint list. I've used an additional coloum - Dept Value as the trigger to pull specifically to retrieve which approval;s email (e.g Admin1, Admin2, etc)

But im not sure why the 2nd request, its still sent back to first approver for approval.

Thank you!!

Was this reply helpful? Yes No