Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Uncategorized

VIDEO – SharePoint Online Open in Explorer with Microsoft Edge

Wanted to record demo for how to check and apply the new SPO cmdlet setting “ViewInFileExplorerEnabled” to provide File Explorer functionality with MS Edge browser 93 or higher. Cheers.

Video

Code

Connect-SPOService https://spjeff-admin.sharepoint.com
Get-SPOTenant | select ViewInFileExplorerEnabled
Set-SPOTenant -ViewInFileExplorerEnabled:$true

>> TerminatingError(Set-SPOTenant): "The requested operation is part of an experimental feature that is not supported in the current environment."

References

VIDEO – Query Blackboard REST API with PowerShell (HTTP POST)

Wanted to share full demo for how to query Blackboard REST API including steps below and PowerShell code.

1) Create Amazon AWS EC2 instance from AMI template
2) Default “administrator” login with instance ID
3) Register on Blackboard Developer portal (https://developer.blackboard.com)
4) Grant access to Amazon AWS instance of Blackboard
5) Run PowerShell for access token
6) Run PowerShell for query Courses (JSON success)

Cheers.

Video

Code

Screenshots

References

SharePoint Migration Tool (SPMT) – Move TEMP Drive

Running migration jobs with SPMT requires TEMP storage. Often 50+ GB and more than available C:\ drive. We see Windows O/S drive fill 100% with no free storage.

By default SPMT writes temp storage to [C:\Users\%USERNAME%\AppData\Roaming\Microsoft\] in the User Profile for current user running SPMT “microsoft.sharepoint.migrationtool.advancedapp.exe” Note how SPMT installs to the User Profile folder at [C:\Users\%USERNAME%\AppData\Local\Apps\SharePointMigrationTool\SPMT]

Before running SPMT migration, run CMD prompt and MKLINK /D to point a Symbolic Link folder and move TEMP drive. SPMT application will see the same original folder. However, files and folders added written are directed to different destination. Avoids full C:\ drive and halted migration. Cheers.

Video

Screenshots

Code

REM — REPLACE DRIVE LETTER X: AS NEEDED —

cd C:\Users\%USERNAME%\AppData\Roaming\Microsoft\
mklink /D MigrationToolStorage X:\MigrationToolStorage

References

VIDEO – Query MS Dataverse tables with FetchXML Builder and XRMToolBox

Wanted to share awesome demo with complete end-to-end steps for how to download, install, configure, and use Fetch XML Builder to query Microsoft Dataverse Tables for PowerPlatform, PowerApps, PowerAutomate, and more.

Cheers

Video

Code

<fetch top="50" aggregate="true" >
  <entity name="contact" >
    <attribute name="address1_stateorprovince" alias="contactstate" groupby="true" />
    <attribute name="contactid" alias="contactcount" aggregate="count" />
  </entity>
</fetch>

Screenshots

References

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲