I have a CI/CD pipeline on Azure. I have set up a .yaml file and a variable called SerialNumber, set to 000000 directly in the Azure interface (not in the .yaml). I want it to be used inside of the pipeline and the updated, adding 1 on every iteration.

The .yaml looks like this:

variables:
  myPipelineVariable: $[variables.SerialNumber]

jobs:

- job: Update_Variable
  timeoutInMinutes: 0
  steps:
  - task: PowerShell@2
    name: "task1"
    displayName: this is task1
    inputs:

      targetType: 'inline'
      script: |
        echo "the value of the variable is : $(myPipelineVariable)"
        $newValue = [int]$(myPipelineVariable) + 1
        $formattedValue = "{0:D6}" -f $newValue  # Format the number with leading zeros
        Write-Host "##vso[task.setvariable variable=myPipelineVariable;isOutput=true]$formattedValue"
    enabled: true

the problem is if i save and run the pipeline the number in the Azure interface then doesn’t change, and the next time starts from 000000 again. I also tried inserting another job in the .yaml:

- job: Show_Variable
  timeoutInMinutes: 0
  steps:
  - task: PowerShell@2
    name: "task2"
    displayName: this is task2
    inputs:

      targetType: 'inline'
      script: |
        echo "the new value of the variable is : $(myPipelineVariable)"
    enabled: true

but it prints: 000000

how can i handle this operation to update the value of the variable inside of Azure, so that every build that i trigger uses it and then adds one to the number automatically?