How to prevent the conversion of formatting in Power Automate

[rwebox]

Hi Folks,

I set up the following PowerShell script as a variable in Power Automate and need to execute it as an input. But Power Automate always converts this script into one line so that this script can be run because of syntax error. Is there a way to prevent Power Automate to stop the conversion of formatting? Thanks

$AzureSQLServerName = "%CurrentItem['serverName']%"
$AzureSQLDatabaseName = "%CurrentItem['dbName']%"

$clientID = "ee5982fb-a92e-4bb9-9543-79b6fc7e2740"

Connect-AzAccount -Identity -AccountId $clientID

Write-Output "Authentication complete..."

$accessToken = (Get-AzAccessToken -ResourceUrl https://database.windows.net).Token

Write-Output "Executing query..."

$SQLOutput = $(Invoke-Sqlcmd -ServerInstance $AzureSQLServerName -Database $AzureSQLDatabaseName -AccessToken $accessToken -Query "exec [dbo].[AzureSQLMaintenance] @Operation='statistics' ,@LogToTable=1" -QueryTimeout 65535 -ConnectionTimeout 60 -Verbose) 4>&1

Write-Output $SQLOutput
Write-Output "Executing query complete."

[OkanAT]

Hi,

A solution for this problem is to format your powershell code in one line within power automate. 

Powershell statements can be formatted in one line by separating each line with a semi colon.

For example, your first two lines would be:

$AzureSQLServerName = "%CurrentItem['serverName']%";$AzureSQLDatabaseName = "%CurrentItem['dbName']%";.....//the rest of the code

You could technically also split your string in separate strings and append each line to your powershell runbook.

Good luck.

I am interested in other solutions as well. 

[rwebox · Accepted solution]

Wow, it is an unexpected prompt response!!!

I will try it and thank you a bunch!

Ray

[rwebox]

Just tested. This solution works!!!

Thank you, OkanAT, agin!

[OkanAT]

No problem,

You might want to answer my answer as a solution for others to see 🙂

[rwebox]

Sorry, this is my first time posting a question. Do I just click on "Accept as Solution"?

Thanks

[OkanAT · Accepted solution]

Indeed.

[rwebox]

Done and thanks

[OkanAT]

You're welcome,

Keep us updates on any problems 🙂

[rwebox]

Power Automate is a great idea but currently there are so many bugs. I have been learning it in the past couple of weeks. Sometimes I feel so frustrated when I use it. For example, the same action worked yesterday but it reports an error today. Hopefully, it will get better soon.