Posts

Showing posts from June, 2015

Connect to Exchange Online via Powershell & Allow File Types

##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", "applic…

Report on Multiple-Choice Fields in SharePoint Using The Excel add-on Power Query

Image
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 now see a screen showing the d…

How to comment out code in Power Query Advanced Editor

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!


SharePoint 2010 - Global Reusable Workflow missing from Workflow List

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.

SharePoint 2010 - Powershell Script to Disable Versioning on a specific List & Delete Old Versions

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();
}