cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
samuelabbott
Level: Powered On

Sign Off Column Doesn't update

Sent document for approval, approver viewed document in excel online, didnt close it and approved the document. I recieved an email saying User signed off on your item. Note that we were not able to update the column in SharePoint because the file was locked by a user. When the approver closed the file, it still didnt update and stayed on Pending? Should this happen? Any help would be much appreciated. Thanks Samuel

7 REPLIES 7
Community Support Team
Community Support Team

Re: Sign Off Column Doesn't update

Hi @samuelabbott

 

Yes,this should happle.

Since if the approver viewed document in excel online, didnt close it and approved the document, the flow would run when the document is approved. however, the "Update item" action to update the document status would run failed because the approver viewed document and didnt close it.Event if the approver closed the file sometimes later, the flow already run failed and will not update the document status.

 

So please let the approver make sure to close the document firstly, and then approve the document.

 

Best regards,

Alice

 

 

samuelabbott
Level: Powered On

Re: Sign Off Column Doesn't update

Thank you, I really appreciate the response

 

Sam

Administrator
Administrator

Re: Sign Off Column Doesn't update

Hello, @samuelabbott!

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

-Gabriel
Microsoft Flow Community Manager
carolinebuckley
Level: Powered On

Re: Sign Off Column Doesn't update

 I have a similar issue but the file is not open and has not been opened drecently yet I get the message

 Note that we were not able to update the column in SharePoint because the file was locked by a user.

 

Also is there a way to use the signoff as a template as i would like to perform more actions after the sharepoint column is updated

pnthrzrule
Level: Powered On

Re: Sign Off Column Doesn't update

I have the same issue. Does anyone have an answer?

SharepointByes
Level: Powered On

Re: Sign Off Column Doesn't update

I also have this concern :

"Note that we were not able to update the column in SharePoint because the file was locked by a user."

> For me it's not a file like excel or word, but a simple item from a list in sharepoint..

pnthrzrule
Level: Powered On

Re: Sign Off Column Doesn't update

Hello Everyone,

 

I was able to fix this today by doing the following:

 

  1. Click the flow drop down and select, "Configure Flows."
  2. In the configure flows options menu, turn the toggle switch to "Off," then save.
  3. Refresh your browser. (I'm not sure if this is necessary or not...I still think it's a good idea anyway)
  4. Go back to the flow drop down and select, "Configure Flows."
  5. Change the toggle back to, "Yes." (make sure you set the approval mode to, "Request sign-off.")
  6. Refresh your browser.
  7. Now run the, "Request Approval," flow.

I have been working on this for weeks and even submitted a ticket to the PowerApps/Flow team. They were not able to fix it. Also, this was only occuring on a single doc library. I created a new library and everything worked just fine. I hope this helps.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 189 members 4,558 guests
Please welcome our newest community members: