Unanswered

Approval Status Not Updating

(0) Share

Report

Posted on by AlexJ01

Hi all,

I have flow which seems to be running okay, however when the document is approved, it is still showing "Pending" on the library. Any ideas? Flow below:

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @AlexJ01 ,

The flow itself seems correct. Did you refresh the SharePoint page after the approval for the change to reflect?

Was this reply helpful? Yes No
AlexJ01 31 on at

Like (0)

Report

Hi @BCBuizer -I have tried refreshing, but it still shows as "Pending"

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @AlexJ01 ,

Then let's have a look at the flow runs. Can you share one for an items where the status is not updating?

Was this reply helpful? Yes No
AlexJ01 31 on at

Like (0)

Report

Thank you @BCBuizer, the flow is failing by the looks of things:

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @AlexJ01 ,

Can you please share the full error details of this flow run?

Was this reply helpful? Yes No
AlexJ01 31 on at

Like (0)

Report

Hi @BCBuizer - I'm not sure exactly what you want to see? I'll add some bits below, but if there's anything else you need to let me know where to find it!

From the "body" section:
{
  "error": {
    "code": 502,
    "source": "flow-apim-europe-001-northeurope-01.azure-apim.net",
    "clientRequestId": "eb1e2832-02a5-495f-8db0-69beeea6e823",
    "message": "BadGateway",
    "innerError": {
      "status": 500,
      "message": "The current state of the item is Draft and the following action Approve cannot be implemented\"\r\nclientRequestId: eb1e2832-02a5-495f-8db0-69beeea6e823\r\nserviceRequestId: eb1e2832-02a5-495f-8db0-69beeea6e823"
    }
  }
}

From the "Header" section:
{
  "Cache-Control": "max-age=0, private",
  "Vary": "Origin",
  "X-NetworkStatistics": "0,4204800,0,0,143785,0,37246",
  "X-SharePointHealthScore": "1",
  "X-MS-SPConnector": "1",
  "X-SP-SERVERSTATE": "ReadOnly=0",
  "DATASERVICEVERSION": "3.0",
  "SPClientServiceRequestDuration": "100",
  "SPRequestDuration": "101",
  "X-DataBoundary": "EU",
  "X-1DSCollectorUrl": "https://eu-mobile.events.data.microsoft.com/OneCollector/1.0/",
  "X-AriaCollectorURL": "https://eu-mobile.events.data.microsoft.com/Collector/3.0",
  "SPRequestGuid": "eb1e2832-02a5-495f-8db0-69beeea6e823",
  "request-id": "eb1e2832-02a5-495f-8db0-69beeea6e823",
  "MS-CV": "Mige66UCX0mNsGm+7qboIw.0",
  "Strict-Transport-Security": "max-age=31536000",
  "X-Frame-Options": "SAMEORIGIN",
  "Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.microsoft365.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;",
  "MicrosoftSharePointTeamServices": "16.0.0.24204",
  "X-Content-Type-Options": "nosniff",
  "X-MS-InvokeApp": "1; RequireReadOnly",
  "P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
  "X-AspNet-Version": "4.0.30319",
  "X-Powered-By": "ASP.NET",
  "Timing-Allow-Origin": "*",
  "x-ms-apihub-cached-response": "true",
  "x-ms-apihub-obo": "false",
  "Date": "Tue, 17 Oct 2023 11:00:50 GMT",
  "Content-Length": "485",
  "Content-Type": "application/json",
  "Expires": "Mon, 02 Oct 2023 11:00:50 GMT",
  "Last-Modified": "Tue, 17 Oct 2023 11:00:50 GMT"
}

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @AlexJ01 ,

As per this article, you can't change from Draft directly to Approved, as the status first has to be set to Pending:

https://tomriha.com/how-to-set-content-approval-status-with-power-automate/

The solution is to first set the status to Pending, and to Approved straight after.

Was this reply helpful? Yes No
AlexJ01 31 on at

Like (0)

Report

@BCBuizer That sorted it out! Thank you for your help 🙂

Was this reply helpful? Yes No