Answered

Manually updating the Sign-Off column

(0) Share

Report

Posted on by RogerFLOW

I was wondering if I could manually update the sign-off column somehow? For example, I sent a document for approval, approver viewed document in excel online, didnt close it and approved the document. I recieved the following email below.

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, the sign off column didn't update and stayed on Pending. Only way to change that status to approved is to resend the the approval and the the approver needs to make sure to close the document before approving.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yuazh-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @RogerFLOW,

Yes, as you said, the only way is to resend the the approval and the the approver needs to make sure to close the document before approving.

Since if the approver viewed document in excel online, didnt close it and approved the document, the update action in your flow would run failed to update the column beacase the file is locked by the approver.

And there is no any way to manually update the sign-off column.

Best regards,

Alice

Was this reply helpful? Yes No
Counie 2 on at

Like (0)

Report
Copy link

Link copied!

Manually updating the column IS possible. i.e. directly from the details pane in SharePoint, I can select the item and update the [sign-off status] column to any text string I like.

I've done some testing on this Flow myself and I'm getting the same result as the original poster.

I suspect that anyone who has replied with suggested solutions for this has not themselves tested this Flow.

If someone could demonstrate this Flow experience end to end and show where the [sign off status] gets updated automatically to "Approved" , I'd love to see it.

Was this reply helpful? Yes No