Answered

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

(0) Share

Report

Posted on by koneill2020

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:

All responses (6)

Answers (1)

Pstork1 66,864 Most Valuable Professional on at

Like (0)

Report

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

You don't need the ETag when updating an Item, only a document. So the steps are the same except you don't need to get the metadata to get the ETag because its not needed.
ambi95 34 on at

Like (0)

Report

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

Hi @Pstork1
how do we use the same method you suggested, but for lists? how can i get list metadata?
koneill2020 on at

Like (0)

Report

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

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

Pstork1 66,864 Most Valuable Professional on at

Like (0)

Report

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

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
koneill2020 on at

Like (0)

Report

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

@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:
Pstork1 66,864 Most Valuable Professional on at

Like (0)

Report

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

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.