The Baretta

##RUN POWERSHELL AS ADMINISTRATOR ##Use this when you need to make configuration changes to your Exchange environment that can't be done via the GUI ##Connect to Exchange Online via Powershell Set-ExecutionPolicy RemoteSigned $UserCredential = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection Import-PSSession $Session ##How to Allow File Types to be opened in Exchange Online Get-OwaMailboxPolicy OwaMailboxPolicy-Default | Select -ExpandProperty BlockedFileTypes | Sort Get-OwaMailboxPolicy OwaMailboxPolicy-Default | Set-OwaMailboxPolicy -BlockedFileTypes @{Remove = ".xml"} Get-OwaMailboxPolicy OwaMailboxPolicy-Default | Set-OwaMailboxPolicy -AllowedFileTypes @{Add = ".xml"} Get-OwaMailboxPolicy OwaMailboxPolicy-Default | Set-OwaMailboxPolicy -BlockedMimeTypes @{Remove = "text/xml...

Today we will be learning how to create a excel report connected to a SharePoint library using Power Query.  I will also address all issues found along the way. The reason we are connecting to our library via Power Query instead of via the 'Export to Excel' option is because our library contains InfoPath forms that have repeating table data in the columns that we need to report on. Power Query   Is a free excel add-in available from Microsoft for both Excel 2010 Professional Plus & Excel 2013.  It is used when you need a way to transform data that isn't quite in the format you need. Step 1: Connecting to your SharePoint Library via Power Query. Open up Excel.  Click Power Query Tab > From Other Sources > From SharePoint List > Insert SharePoint Site URL Here's our first issue.  Only Lists are appearing in the Navigator.  Not to worry, Right-Click any of the Lists showing and click Edit to open up the Query Editor.   You should ...

Power Query uses Microsofts M Language.  I couldn't find out how to comment out code so I could write notes inside the Advanced Editor.  It's the same as C# and many other languages, use two right slashes: // COMMENT HERE!

First off, if you can get the cash, pay for Nintex Workflows.  It is worth it's weight in gold.  I cannot stress enough how easy it is to build, copy, manage, update workflows with Nintex. Simply, you're wasting your time/life if you are still building workflows in SharePoint Designer. However, if you're just working out how to keep using an old reusable workflow and it's not showing up as an option to use in your list, here's how I got it to show back up. Add another Content Type to the list (even if just temporarily), this seems to force the list to check which Workflows are available for the Content Types in the List, and the workflow should show up again.

This will remove versioning from the list you specify & update every item so that the old versions are deleted. Great for really large lists/libraries that don't require versioning when you want to free up some space. $web = get-spweb "http://root/site" $list = $web.Lists["List Name"] $list.EnableVersioning = $false $list.Update() foreach($item in $list.Items) { $item.URL; $item.SystemUpdate(); }