How would one unpublish a SharePoint page using Power Automate

Like (0) Share

Report

Posted on 14 Feb 2025 08:45:55 by CU14020840-0

I've been looking for a way to unpublish a SharePoint page using Power Automate, but so far, I haven't found any out-of-the-box actions that seem to do the job.

I came across some posts suggesting the /unpublish HTTP request, but in my case, it throws this error:
"Cannot find resource for the request unpublish."

Has anyone successfully automated unpublishing pages via Power Automate? Any insights or workarounds would be greatly appreciated!

#SharePoint #PowerAutomate #Automation #Microsoft365

Categories:

Business Process Flows

All responses (1)

Answers (0)

RobElliott 10,166 Super User 2025 Season 2 on 15 Feb 2025 at 10:31:46

Like (0)

Report

How would one unpublish a SharePoint page using Power Automate

Yes this is quite easily do-able. In the image below the news item has been changed from Published (Promoted State = 2) to Unpublished (Promoted State = 0)

I've put the ID of the page into a variable varID.

In your flow add a Send an HTTP Request to SharePoint action with:

Method: POST
Uri: _api/Web/Lists/GetByTitle('Site Pages')/Items(@{variables('varID')})

Headers - accept - application/json;odata=verbose

Headers - content-type - application/json;odata=verbose

Headers - If Match - *
Headers - X-HTTP-Method - MERGE

Body - { '__metadata':{'type':'SP.Data.SitePagesItem'},'PromotedState':0 }

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)