Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
PowerShell for Office 365

You're reading from   PowerShell for Office 365 Automate Office 365 administrative tasks

Arrow left icon
Product type Paperback
Published in Jul 2017
Publisher Packt
ISBN-13 9781787127999
Length 222 pages
Edition 1st Edition
Languages
Arrow right icon
Authors (2):
Arrow left icon
Prashant G Bhoyar Prashant G Bhoyar
Author Profile Icon Prashant G Bhoyar
Prashant G Bhoyar
Martin Machado Martin Machado
Author Profile Icon Martin Machado
Martin Machado
Arrow right icon
View More author details
Toc

Table of Contents (10) Chapters Close

Preface 1. PowerShell Fundamentals FREE CHAPTER 2. Managing Office 365 with PowerShell 3. Azure AD and Licensing Management 4. Managing SharePoint Online Using PowerShell 5. Managing Exchange Online Using PowerShell 6. Script Automation 7. Patterns and Practices PowerShell 8. OneDrive for Business 9. PowerShell Core

Formatting data to be used for bulk account management

To create multiple users, assign licenses to multiple users, or do both at the same time, we can use data stored in a CSV file, text file, or even a SharePoint list.

In the following example, we will cover bulk user creation using a CSV file.

As mentioned previously, to create a new user the mandatory parameters are userprincipalname and DisplayName.

The CSV will need to be in the following format:

  • FirstName, LastName, Country
  • Bob, Smith, USA
  • Sanjay, Shah, UK

To implement this, we will need to connect to the Office 365 service first and import the input file; the next step is to store the info in variables, and the last step is to create the users in Office 365:

$users = Import-CSV "C:\Users.csv"
foreach ( $user in $users){
$FirstName = $user.FirstName
$LastName = $user.LastName
$DisplayName = build it as per...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime