SharePoint and Power Platform related Stuff

CD C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\PublicAssemblies Step 1: Launch Developer Command Prompt for VS 2017 Step 2: CD C:\Program Files\Microsoft Visual Studio\2017\Community\Common7\IDE\PublicAssemblies Step 3: Run below command gacutil -i Microsoft.VisualStudio.Shell.Interop.11.0.dll You should now see Assembly successfully added to the cache Restart Visual Studio and hopefully all will be well and you can add references.

Step 1: Select the range of cells you want to split values into columns, and then click  Data  >  Text to Columns . See screenshot: Step 2: In the first  Convert Text to Columns Wizard  dialog box, select the  Delimited  option, and then click the  Next  button. Step 3: In the second  Convert Text to Columns Wizard  dialog box, only check the  Comma  box in the  Delimiters  section, and click the  Next  button. Step 4: In the last  Convert Text to Columns Wizard  dialog box, select a cell for locating the splitting values in the  Destination  box, and finally click the  Finish  button. See screenshot: Now all the values in selected cells which were separated by commas are split to different columns as bellow screenshot shown.

Step 1: Connect-MsolService Step 2: $applist = Get-MsolServicePrincipal -all  |Where-Object -FilterScript { ($_.DisplayName -notlike "*Microsoft*") -and ($_.DisplayName -notlike "autohost*") -and  ($_.ServicePrincipalNames -notlike "*localhost*") } Step 3: foreach ($appentry in $applist) {     $principalId = $appentry.AppPrincipalId     $principalName = $appentry.DisplayName     Get-MsolServicePrincipalCredential -AppPrincipalId $principalId -ReturnKeyValues $false | ? { $_.Type -eq "Password" } | % { "$principalName;$principalId;" + $_.KeyId.ToString() +";" + $_.StartDate.ToString() + ";" + $_.EndDate.ToString() } | out-file -FilePath d:\appsec.txt -append }