Using outputs of Powershell in Github Actions

Question

I am trying to get connection string using Powershell and pass this argument to another step in the actions, but I am getting this error:

Input required and not supplied: connection-string

But I am following a similar behaviour that I use before but I am not sure why it is not working, Here is part of my script:

      - name: Secrets to Key Vault
        uses: azure/powershell@v1
        env:
          POWERSHELL_TELEMETRY_OPTOUT: 1
        with:
          inlineScript: |
            $sqlConnectionString = (az keyvault secret show --vault-name <keyVaultName> --name <secret-name> --query [value] --output tsv)
            echo ::set-output name=sqlConnectionString::$( $sqlConnectionString)
          azPSVersion : '3.1.0'
        

      - name: Deploy Core Module
        uses: azure/sql-action@v1
        id: sqlConnection
        with:
          server-name: <sqlServerName>
          connection-string: ${{ steps.sqlConnection.outputs.sqlConnectionString}}
          dacpac-package: './Database.dacpac'

I think problem is related to the output of the variable but I use similar syntax previously just in a simple run and it worked. Could it be related to the behaviour of the Powershell?

baywet · Accepted Answer · 2024-06-21 18:22:27Z

Since the commands syntax to set the output is now deprecated in GitHub Actions, it can be set using the GITHUB_OUTPUT environment variable. So something like this:

        - name: Secrets to Key Vault
        uses: azure/powershell@v1
        id: setSqlConnection
        env:
          POWERSHELL_TELEMETRY_OPTOUT: 1
        with:
          inlineScript: |
            $sqlConnectionString = (az keyvault secret show --vault-name <keyVaultName> --name <secret-name> --query [value] --output tsv)
            Write-Output "sqlConnectionString=$($sqlConnectionString)" >> $Env:GITHUB_OUTPUT
          azPSVersion : '3.1.0'
      - name: Deploy Core Module
        uses: azure/sql-action@v1
        id: sqlConnection
        with:
          server-name: <sqlServerName>
          connection-string: ${{ steps.setSqlConnection.outputs.sqlConnectionString}}
          dacpac-package: './Database.dacpac'

Note: using the output variable in a later step remains unchanged.

Krzysztof Madej · Accepted Answer · 2022-03-21 09:43:09Z

2

Plese add id to you first action:

      - name: Secrets to Key Vault
        uses: azure/powershell@v1
        id: setSqlConnection
        env:
          POWERSHELL_TELEMETRY_OPTOUT: 1
        with:
          inlineScript: |
            $sqlConnectionString = (az keyvault secret show --vault-name <keyVaultName> --name <secret-name> --query [value] --output tsv)
            echo ::set-output name=sqlConnectionString::$( $sqlConnectionString)
          azPSVersion : '3.1.0'
        

      - name: Deploy Core Module
        uses: azure/sql-action@v1
        id: sqlConnection
        with:
          server-name: <sqlServerName>
          connection-string: ${{ steps.setSqlConnection.outputs.sqlConnectionString}}
          dacpac-package: './Database.dacpac'

and then use it to access output ${{ steps.setSqlConnection.outputs.sqlConnectionString}}

edited Mar 21, 2022 at 9:43

answered Sep 8, 2021 at 14:02

Krzysztof Madej

42.1k10 gold badges117 silver badges141 bronze badges

1 Comment

Rhys van der Waerden Over a year ago

Apparently ::set-output has been deprecated

Collectives™ on Stack Overflow

Using outputs of Powershell in Github Actions

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related