Forum Discussion

Test SharePoint's avatar
Test SharePoint
Brass Contributor
Oct 12, 2019
Solved

Trying to add multiple users to distribution group and getting error: Cannot validate argument

I am trying to add multiple users in a distribution Group. All users are in cloud. I have a CSV which has the following columns : DisplayName, Alias, PrimarySmtpAddress   I am trying the followi...
admin
Distribution Group
exchange
office 365
powershell
  • DanielNiccoli's avatar
    DanielNiccoli
    Oct 12, 2019

    Test SharePointThen either your csv file is malformed, or you need to modify the Import-Csv parameters.

DanielNiccoli's avatar
DanielNiccoli
Steel Contributor
Oct 12, 2019

Test SharePointSomething breaks during import. "Cannot validate argument on parameter 'Member'. The argument is null." Null means that it couldn't parse the csv, otherwise it would be an empty string.

 

Have you confirmed that the import actually works?

 

$Userslist = Import-CSV c:\users\user\ab.csv

$Userlist

$Userlist[0]
  • Test SharePoint's avatar
    Test SharePoint
    Brass Contributor
    Oct 12, 2019

    DanielNiccoli : thanks for your reply. I tried the above command and get this:

     

    Cannot index into a null array.
    At line:1 char:1
    + $Userlist[0]
    + ~~~~~~~~~~~~
    + CategoryInfo : InvalidOperation: (:) [], RuntimeException
    + FullyQualifiedErrorId : NullArray

    • DanielNiccoli's avatar
      DanielNiccoli
      Steel Contributor
      Oct 12, 2019

      Test SharePointThen either your csv file is malformed, or you need to modify the Import-Csv parameters.

      • mike36usmc's avatar
        mike36usmc
        Copper Contributor
        Jun 20, 2024

        DanielNiccoli  i fixed the issue,

        I had to put the actual name of what the -member $_email for example so in the excel sheet had to insert line that said email in line 1 and all the email addresses underneath that and it work imported 67 members at once to the distro group

Resources