cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Karen_H
Helper I
Helper I

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

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.    flow.PNG

 

 

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

6 REPLIES 6
Pstork1
Dual Super User III
Dual Super User III

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



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

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
Dual Super User III
Dual Super User III

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?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

I used the ID from the For selected file trigger

Karen_H_0-1617984993453.png

 

Pstork1
Dual Super User III
Dual Super User III

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?



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

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

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,338)