Forum Discussion

Brass Contributor

Oct 12, 2019

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...

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

DanielNiccoli

Steel Contributor

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

Test SharePoint

Brass Contributor

Oct 15, 2019

DanielNiccoli : thank you.. i created a new csv and that worked.

jimbarrgpboston
Brass Contributor
Jan 18, 2021
Some info on exactly what you did would be helpful. I've wasted over an hour on this and I'm ready to just add the 114 people via the web interface, given there is no definitive way to validate any error message in Powershell. Test SharePoint
- DanielNiccoli
  Steel Contributor
  Feb 02, 2021
  Error messages in PowerShell are mostly straight forward. He also said exactly what he did: create a valid csv file to use for the import.
  - P_Nap
    Copper Contributor
    Mar 16, 2021
    DanielNiccoli
    
    Not really, I have also created csv file from Excel using their export function and it does not work.
    
    What was the error in the creation of the csv file - or more appropriately what was the error if one follows the instructions as written in various postings, ie:
    
    Alias,Name,UPN
    my1.alias,My1 Aliasm,my1.alias@myserver.com
    my2. ...
    .. etc