SEQUENTIAL APPROVAL - Update SharePoint Column to show approved/rejected

(0) Share

Report

Posted on by LC-10090949-0

Hi Everyone!

I have created a sequential approval flow which emails a team of people in sequence to seek approval of a document.

When the document has been approved or rejected, I would like the Approval Status column of my SharePoint List to be updated from Pending to Approved or Rejected accordingly.

Please can anyone tell me how to do this?

Lynzie

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (1)

Report

HI @LC-10090949-0

Is this a custom power automate approval you created, or are you using the build in SharePoint Approval?

If this is a custom power automate approval is it a built-in or dynamic sequential? Can you please share your approval flow.

As you are mentioning SharePoint, I am going with Dynamic.

Here is a dynamic example Manage sequential approvals with Power Automate - Power Automate | Microsoft Learn

Please let me know if this helps and if not share your flow and SharePoint column types for more help.

Cheers

Michael

Was this reply helpful? Yes No
LC-10090949-0 6 on at

Like (0)

Report

Hi @Michael E. Gernaey,

Thank you so much for your reply - please forgive my ignorance but how is best to share my flow? It is a custom power automate flow rather than a SharePoint one as I needed more than SharePoint could offer whilst it operates from a List.

Best wishes,

Lynzie

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (0)

Report

Hi @LC-10090949-0

Sorry for the confusion, what I meant was, if its a Custom one, that is using SharePoint as the back end (which sounds correct). This would be considered a dynamic sequential versus, if you just used a Single Approval, with it set to Sequential.

So, you would have to take pictures (screen shots) of your flow and paste them in here or attach them.

if I might ask a question, and of course this is without seeing your flow, if you are using a Dynamic sequential, where you send out an approval, get a response, then record it, then send another approval and wait for a response, you should be able to record that just by looking at the Outcome in a condition, then updating your SharePoint field to be whatever value it needs to be.

Thats why I was asking if its an Option Field, or a Text Field for your Status?

So if you can explain your flow, an use pictures so that we can easily see what the steps do and also, what is the Data type of the SharePoint field you want to record the outcome.

Cheers,

Was this reply helpful? Yes No
LC-10090949-0 6 on at

Like (0)

Report

Hi again@Michael E. Gernaey,

Thank you for your patience and your clarification... here is the abridged version of my flow. It starts with a whole bunch of variables:

Then it sequences through the approvers one at a time, sending a rejection email and ending the process if someone rejects the document. If it get s to the final sign-off stage, the submitter gets an email informing them of the final approval and the sharepoint list is supposed to update from 'pending' to 'approved'.

...and so on and so on until:

So, in summary, I want to update the List to go from 'pending' to 'approved' or 'rejected', to update when sending out a new approval request to show who the process is stuck with if they haven't responded to the request AND to put an actual hyperlink in the body of the email so they don't have to copy and paste it. It works just fine but needs a bit of refining. Here are my List columns:-

Was this reply helpful? Yes No