Home >Tips >PowerShell with SharePoint from Scratch >Create PowerShell Code in Excel A kalmstrom.com site map icon Site map  

Create PowerShell Code in Excel A

Multiple Create-MyList Calls

A PowerShell with SharePoint tutorial

PowerShell iconIn 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. PowerShell icon

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.

Excel sheet

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.


back icon next icon
Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved