This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Install ImportExcel module if needed | |
| # Install-Module -Name ImportExcel -Scope CurrentUser | |
| # Load the necessary module for Excel | |
| Import-Module -Name ImportExcel | |
| # Define the array of product IDs and names | |
| $products = @( | |
| @{ Name = "Finance and Operations cross-app capabilities"; Id = "e30c6971-52c8-e911-a968-000d3a4f3883" } | |
| @{ Name = "Supply Chain Management"; Id = "e1a941d5-d3b7-e911-a992-000d3a4f3343" } | |
| @{ Name = "Finance"; Id = "50a470c0-d3b7-e911-a992-000d3a4f3343" } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Based on http://nuts4.net/post/automated-download-and-installation-of-visual-studio-extensions-via-powershell | |
| param([String] $PackageName) | |
| $ErrorActionPreference = "Stop" | |
| $baseProtocol = "https:" | |
| $baseHostName = "marketplace.visualstudio.com" | |
| $Uri = "$($baseProtocol)//$($baseHostName)/items?itemName=$($PackageName)" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function Get-ParameterValues { | |
| <# | |
| .Synopsis | |
| Get the actual values of parameters which have manually set (non-null) default values or values passed in the call | |
| .Description | |
| Unlike $PSBoundParameters, the hashtable returned from Get-ParameterValues includes non-empty default parameter values. | |
| NOTE: Default values that are the same as the implied values are ignored (e.g.: empty strings, zero numbers, nulls). | |
| .Link | |
| https://gist.github.com/Jaykul/72f30dce2cca55e8cd73e97670db0b09/ | |
| .Link |