Create PowerShell Code in Excel A
Multiple Create-MyList Calls
A PowerShell with SharePoint tutorial
 In
earlier demos we have seen how you can use a PowerShell
script to create and remove multiple apps in very short
time.
When you have your app names - or something that can be
used as app names - in an Excel list formatted as a table,
you can use it to create the PowerShell code just as quickly.
In the demo below, Peter Kalmström shows how to create code
in Excel that will be used in PowerShell function calls
to create and remove multiple SharePoint apps.
In the
next demo, Peter shows another way to create code for
PowerShell in Excel. There, he uses the code for an array
and a forEach loop.
Both demos use the same list of department names, because
Peter wants each department to have a list with the same
name as the department.
In the demo below, Peter starts creating code in the first
cell to the
right of the first department name. When the code is finished,
he just have to press Enter to fill out the code for the
other departments.
|
