Approval Status Not Updating

Like (0) Share

Report

Posted on 13 Oct 2023 14:40:37 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:

All responses (8)

Answers (1)

AlexJ01 31 on 01 Nov 2023 at 15:49:45

Like (0)

Report

Re: Approval Status Not Updating

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

BCBuizer 22,070 Super User 2025 Season 1 on 18 Oct 2023 at 08:33:27

Like (0)

Report

Re: Approval Status Not Updating

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.
AlexJ01 31 on 17 Oct 2023 at 13:22:24

Like (0)

Report

Re: Approval Status Not Updating

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"
}
BCBuizer 22,070 Super User 2025 Season 1 on 17 Oct 2023 at 13:12:53

Like (0)

Report

Re: Approval Status Not Updating

Hi @AlexJ01 ,

Can you please share the full error details of this flow run?
AlexJ01 31 on 17 Oct 2023 at 12:29:54

Like (0)

Report

Re: Approval Status Not Updating

Thank you @BCBuizer, the flow is failing by the looks of things:
BCBuizer 22,070 Super User 2025 Season 1 on 17 Oct 2023 at 09:30:11

Like (0)

Report

Re: Approval Status Not Updating

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?
AlexJ01 31 on 17 Oct 2023 at 07:59:55

Like (0)

Report

Re: Approval Status Not Updating

Hi @BCBuizer -I have tried refreshing, but it still shows as "Pending"
BCBuizer 22,070 Super User 2025 Season 1 on 13 Oct 2023 at 16:16:39

Like (0)

Report

Re: Approval Status Not Updating

Hi @AlexJ01 ,

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

Community site session details

Approval Status Not Updating

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates

Community site session details

Approval Status Not Updating

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Warren Belz – Community Spotlight

Congratulations to the April Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - Building Flows

Featured topics

Product updates