Need help setting _ModerationStatus of Sharepoint Document Library to 0 (Approved)

(0) Share

Report

Posted on by DJanssen

427

Hello all,

At the end of my Power automate Workflow I'm trying to send a HTTP request to my Sharepoint to set the file that is has been processed by the workflow to Approved (_ModerationStatus). I however get the error it can't find my library. What am I doing wrong?

Thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

v-yetonggu-msft on at

Like (1)

Report

Hi @DJanssen ，
Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
DJanssen 427 on at

Like (0)

Report
Hello @v-yetonggu-msft ,

Ah that seems to solve the issue that it cannot find the library. I reran the flow again but now it complains about the JSON body that I send along. I tried adding the spaces to the _metadata property but it still gives me the error about the metadata being wrong:

The parameter __metadata does not exist in method GetById.

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft on at

Like (1)

Report
Hi @DJanssen ,
Replace type with this expression.

SP.Data.IMS_x0020_Working_x0020_AreaListItem

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
DJanssen 427 on at

Like (0)

Report
Hello @v-yetonggu-msft ,

Thank you for your suggestions, I'm getting a lot closer to the solution 🙂 I implemented your suggestion but it failed on the first try again:

I then found another useful topic to try changing the POST to PATCH. I think PATCH is more accurate for my situation since the _ModerationStatus before running the workflow on this item is Pending (2). When I tried it with PATCH I got the following error:
Appreciate your thoughts!

Update:
I added the header:
If-Match: * and that fixed the eTag error. Now the error is:

A type named 'SP.Data.IMS_x0020_Working_x0020_AreaListItem' could not be resolved by the model. When a model is available, each type name must resolve to a valid type.

The IMS Working Area is a Document Library. Might this be the problem?

Was this reply helpful? Yes No
DJanssen 427 on at

Like (1)

Report
{ "__metadata": { "type": "SP.Data.IMS_x0020_Working_x0020_AreaItem" }, "OData__ModerationStatus": 0 }
This was the correct way to update it. Happy it works!

Was this reply helpful? Yes No