Forum Discussion

Brass Contributor

Aug 20, 2024

Solved

Powershell error with the below code

Hi Champions, Can someone please help me with the below powershell code which i want to upload the key vault secrets excel csv file to azure key vault. But it is giving below error. $keyVault...

azure powershell

LainRobertson
Aug 26, 2024
Rambo363636

Replace the following existing line:
$secretName = $row.$secretName

With:
$secretName = ConvertTo-SecureString -AsPlainText -String $row.$secretName -Force;

The error's telling you that Set-AzKeyValutSecret wants a secure string, not a plain text string.

Cheers,
Lain

Rambo363636

Brass Contributor

Aug 26, 2024

oliwer_sundgren LainRobertson
Hi Oliwer & Lain,

I ran below and got the below output.

Looking forward to hear from you.

Regards,
Rambo

LainRobertson

Silver Contributor

Aug 26, 2024

Rambo363636

Replace the following existing line:

$secretName = $row.$secretName

With:

$secretName = ConvertTo-SecureString -AsPlainText -String $row.$secretName -Force;

The error's telling you that Set-AzKeyValutSecret wants a secure string, not a plain text string.

Cheers,

Lain

LainRobertson
Silver Contributor
Aug 27, 2024
Rambo363636

The error is telling you that the values for Secretvalue in the XLSX may only contain:

Numbers (0-9);
Lowercase letters (a-z);
Uppercase letters (A-Z);
The minus/hyphen/dash symbol (-).

Cheers,
Lain
Rambo363636
Brass Contributor
Aug 27, 2024
LainRobertson oliwer_sundgren
Hi Lain & Oliwer
I have edited and ran the below code and now i get the below error.
Please advise the workaround.

Looking forward to hear from you.

Regards,
Rambo
Rambo363636
Brass Contributor
Aug 27, 2024
LainRobertson oliwer_sundgren
Hi Lain,
I ran the below as advised and received the below output.

Looking forward to hear from you. Thanks.

Regards,
Rambo