Forum Discussion
Powershell error with the below code
Replace the following existing line:
$secretName = $row.$secretNameWith:
$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
Could you try and run the script again and share a screenshot of error message again?.
After the script has ran, run $Row.Name in the terminal and see if it outputs something as well
Cheers
Oliwer
It'd need to be $Data.Secretvalue rather than $Data.Value. Other than that, as you say, the data appears fine now, but wouldn't have at the start given the $null error.
Cheers,
Lain
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
LainRobertson oliwer_sundgren
Hi Lain & OliwerI 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,
RamboLainRobertson oliwer_sundgren
Hi Lain,
I ran the below as advised and received the below output.
Looking forward to hear from you. Thanks.
Regards,
RamboReplace the following existing line:
$secretName = $row.$secretNameWith:
$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
oliwer_sundgren LainRobertson
Hi Oliwer & Lain,
I ran below and got the below output.
Looking forward to hear from you.
Regards,
Rambo- LainRobertson
Yeah I noticed that I missed that it said SecretValue in the CSV 🙂 Thanks for clarifying
Cheers!
