SOLVED

Approval Status Column Not Updating to Approved. Remains Pending.

Copper Contributor

Hi All,

 

I am quite new to sharepoint and flow. I have a sharepoint document library enabled with Setting Required Content Approval for Submitted items. So that i have the approval status column.  

 

I used this template in powerautomate: Request Approval (First to Respond) for a selected file and shared the power automate flow with 2 users 

 

It works fine. both users received and approved it. However the Approval Status Column Still shows Pending. 

 

I am trying to figure out why it is not automatically set as Approved? Is there something i need to enable in sharepoint document library ?

 

 

 

6 Replies
best response confirmed by KrisCachia (Copper Contributor)
Solution

Hello @KrisCachia, you have to add another action after that approval action: a condition needs to be prooved.

 

IF the result of the approval is "Approve", in the YES Branch you have to add the action of actualizing the file or item.

 

And in this step or actionthe approval status has to be changed to the new status "Approved". Hope, this helps. If so, pls give a LIKE. Greets, Eva

thanks added update file properties and entered the document library and used ID from the Get File Properties in previous Step and the Approval Field was now available to be updated.

Thanks a lot for the tip.

@KrisCachia, Hi there. I have a similar problem as you with regards to wanting the Approval Status to update from Draft or Pending to Approved. May I see what your flow looks like for reference so that I can fix my flow accordingly? Right now, any documents uploaded into the document library is set in Draft status. I'd like approved documents to become Approved, while rejected documents remain as Draft. I don't need the option, Pending. 

@Eddie365 Hi Eddie, 

did you get any feedback or solution?

Hi do you mind explaining the steps please?

@srusso @Eddie365 After approval action, configure your flow like below to check the outcome of approval action & then update list item: 

ganeshsanap_0-1660215776038.png

In "Update item" action: select your site, list & ID (ID will be from dynamic content in previous action for which you are running the approval) and update the approval status column value as per your requirements.

 

If you are running the approval for files in document library, you have to use the "Update file properties" action instead of "Update item" action.


Please consider giving a Like if my post helped you in any way.

1 best response

Accepted Solutions
best response confirmed by KrisCachia (Copper Contributor)
Solution

Hello @KrisCachia, you have to add another action after that approval action: a condition needs to be prooved.

 

IF the result of the approval is "Approve", in the YES Branch you have to add the action of actualizing the file or item.

 

And in this step or actionthe approval status has to be changed to the new status "Approved". Hope, this helps. If so, pls give a LIKE. Greets, Eva

View solution in original post