cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
koneill2020
Frequent Visitor

Power Automate How Best to Set the Approval Status Field in a Document Library

In my Power Automate flow - what is the best way to go about having the OOTB Approval Status field associated with a Document Library be set to Approved (and published) when an item is indeed marked as approved from a workflow as such: When I try and add a Update Item as such I don't see the value to set for the Approval Status column which I turned on in the document library:

 

powerautomate_update_approval_status_field.png

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

It doesn't look like you've got all the right things in the correct places.  Here's a working copy from a sample I built for one of my demos.  In the set Content Approval Status the ID is the item id for the file and the ETag should be a Dynamic field called 'ETag' in the output of the Get file metadata

image.png



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

View solution in original post

4 REPLIES 4
Pstork1
Dual Super User III
Dual Super User III

For the built in field you want the Set Content Approval action.  For a document library you will need to retrieve the files metadata properties to get the ETag also.

image.png



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

@Pstork1  OK so I added the Get file metadata as such with the Set content approval status as such as well and the error I get is  -> Error

Action 'Get_file_metadata' failed
The response is not in a JSON format. 
 
Therefore what is the best way to resolve I'm not too familiar with the best way of setting the eTag - as I utilized the Content Approval Status as that is the value I am trying to set:

powerautomate_get_file_metadat_approval_status_field.png

Pstork1
Dual Super User III
Dual Super User III

It doesn't look like you've got all the right things in the correct places.  Here's a working copy from a sample I built for one of my demos.  In the set Content Approval Status the ID is the item id for the file and the ETag should be a Dynamic field called 'ETag' in the output of the Get file metadata

image.png



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

View solution in original post

koneill2020
Frequent Visitor

@Pstork1 - many thanks that got me over that hurdle!

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (53,590)