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:

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Pstork1 69,543 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
koneill2020 on at

Like (0)

Report
Copy link

Link copied!

@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:

Was this reply helpful? Yes No
Verified answer

Pstork1 69,543 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
koneill2020 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
ambi95 34 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Pstork1 69,543 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No