How to update content approval status column for a selected file?

[Karen_H]

I am trying to create an approval flow that a user can run for a selected file and if approved the flow should update the Approval Status column that is created when the library has the Require content approval for submitted items set to Yes.

The files are stored in subfolders.    

The flow is erroring with the following message:

{"Etag":"\"{EB39C733-1377-47AF-A11F-F87D1EB8CE4F},5\"","Message":"The ETag of this item does not match the one used for setting content approval status. The contents of the item may have changed before the action was completed.","Succeeded":false,"ApprovalErrorCode":"etagMismatch","ApprovalLink":"https://lyondellbasell.sharepoint.com/sites/ads-ao/ECM%20Library/_Testing%20Site%20Migration/_Testin..."}
clientRequestId: f235a144-bcc1-4f58-af2e-a7fd757cde44
serviceRequestId: f235a144-bcc1-4f58-af2e-a7fd757cde44

[Pstork1]

Move the Get File Metadata action to after the approval response is received.  Use the Etag from that action to set the content approval.

[Karen_H]

I tried that as well but get this error now

The file /sites/KarenTestSite/1 does not exist.
clientRequestId: fd31af9f-6eff-46d9-b3f6-44e2eb1524d3
serviceRequestId: 1f98bc9f-6079-b000-d2e4-53b0cdac0dd1

[Pstork1]

The address in the error message doesn't match the link for the approval.  Are you sure you are getting the metadata for the right file?

[Karen_H]

I used the ID from the For selected file trigger

[Pstork1]

Is the Start and wait for an Approval based on the file or some list item?  Because your original error says the link is

https://lyondellbasell.sharepoint.com/sites/ads-ao/ECM%20Library/_Testing%20Site%20Migration/_Testin..."}

but the Get File metadata is on a completely different site

KarenTestSite?

[Karen_H · Accepted solution]

Thanks we found a solution by adding an action to Submit Content Approval Status first.