Insert elements into array nested in a hash table

Question

I have a hash table like this:

$Arguments = @{
    Name = $DataSourceName
    DriverName = "MS Access"
    SetPropertyValue = @(
         "Server=$ServerIpAddress",
         "Description=$Description"
         "CurrentDomain=$DomainName"
    )
    ErrorAction = 'Stop'
}

If I want to insert entries into the array SetPropertyValue. How can I achieve this? I tried:

$Arguments.SetPropertyValue.Add("Database=$DatabaseName")

But this does not work.

The array type does not contain an Add() method (see Microsoft Docs). — Akaizoku
– Akaizoku, Commented Oct 29, 2018 at 11:54

Mark Wragg · Accepted Answer · 2018-10-29 10:50:43Z

3

Try this:

$Arguments.SetPropertyValue += "Database=$DatabaseName"

This will append an item to the existing array. The += operator is a shorthand equivalent of doing:

$Arguments.SetPropertyValue = $Arguments.SetPropertyValue + "Database=$DatabsaseName"

answered Oct 29, 2018 at 10:50

Mark Wragg

23.7k7 gold badges48 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matt · Accepted Answer · 2019-04-29 18:14:23Z

1

.Add() is a method associated with lists in PowerShell but not arrays. So one thing you could do it cast your initial SetPropertyValue as an array list. \

SetPropertyValue = [System.Collections.ArrayList] @(
     "Server=$ServerIpAddress",
     "Description=$Description",
     "CurrentDomain=$DomainName"
)

So with that in place your Add statement would succeed.

edited Apr 29, 2019 at 18:14

answered Oct 29, 2018 at 12:21

Matt

47.1k9 gold badges90 silver badges125 bronze badges

Collectives™ on Stack Overflow

Insert elements into array nested in a hash table

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related