Sitecore powershell script to change WorkFlow Status to Approved from particular node

Question

How to write sitecore powershell script to change WorkFlow status to Approved from particular Media Library Folder.

I have multiple documents to replace in bulk in Sitecore Media Library and have workflow enabled. And I want to change WorkFlow Status to Approved by Sitecore Powershell from particular Media Library Folder. Is there any way to do that?

Thank you

Answer 1

You can use below script as well. It uses BulkUpdateContext to make the operation faster and it looks through all the versions of media items for multilingual scenarios. Rest of the basics of item editing are same as in script shared by Sumit -

$rootItem = Get-Item -Path master:"Media Folder PATH"
$workflowApprovedStateID = "WORKFLOW APPROVED STATE GUID"
$items = Get-ChildItem $rootItem.ID -Recurse -Language * -Version *
New-UsingBlock (New-Object Sitecore.Data.BulkUpdateContext) {
    $items | ForEach-Object {
        $item = $_
        $item.Editing.BeginEdit();
        $item.Fields["__Workflow state"].Value = $workflowApprovedStateID 
        $item.Editing.EndEdit();
        Write-Host "$($item.FullPath)  --> updated to approved workflow state"
    }
}

Answer 2

You can wite you code something like this.

$rootItem = Get-Item -Path master:"START PATH"
$language = "en"
$workflowFinalState = "WORKFLOW STATE GUID"
foreach ( $item in Get-ChildItem -Item $rootItem -Recurse -Language $language)
{
    $item.Editing.BeginEdit();
    $item.Fields["__Workflow state"].Value = $workflowFinalState
    $item.Editing.EndEdit();
    Write-Host "$($item.FullPath)  --> Updated"
}

Hope this helps.