Working with SharePoint Drop Off Libraries

One of the major challenges businesses face is how to ensure their digital information is stored in the correct location. Unless people know exactly where it needs to go it will probably end up where it isn’t supposed to be.

A smart way to approach this problem is to use automated processes governed by rules that allow people to upload information to a single location and then for it to automatically routed to the right location without them having to think about it.

SharePoint has plenty of automation features available out of the box. One of these is a feature known as Document Routing. This allows you to basically configure a number of rules so when a file is uploaded to a special ‘drop-off’ area in SharePoint it is automatically moved to other locations based on these rules.

image

Firstly, navigate to the SharePoint Team Site where you wish to enable this.

image

In the top right of the window select the COG and then Site Settings from the menu that appears.

image

From under the Site Actions section in the right column select Manage site features.

image

Locate the feature Content Organiser and ensure that it is Active as shown above.

image

Once the Content Organizer feature is active it will automatically create a new Document Library in the Team Site called Drop Off Library as shown above.

image

Go back to the Site Settings area in the Team Site and locate the Site Administration area options as shown above.

Here you will now see two additional options – Content Organizer Settings and Content Organizer Rules.

Select Content Organizer Rules.

image

image

You can follow through the options on the page but here, enable the ability to Send to Another Site which is not enabled by default.

image

At the bottom of this page you find the ability to send email notifications when data remains in the Drop Off Library. This means that the data doesn’t match any of the in place rules and needs to be manually resolved.

Here you can nominate which users will receive email notifications of this and how many days the system will wait before notifying them.

Scroll down to the bottom of the page and save your changes.

image

Now select the Content Organizer Rules link. This will take you what appears to be a standard SharePoint list. Select the option new item to create a new rule to organise your data.

image

Give the rule a name and set the priority. Rules work based on SharePoint Content Types. In this case, because we want to route standard images, select the Document Content Types which then allows the selection of Picture for type. This means the rule will only apply to pictures uploaded to the Drop Off Library.

image

You now need to create a condition that will test the information uploaded. In this case the condition used will be when the Title field is set to begin with ‘Home’. Remember, that when you upload a picture file to SharePoint it will also ask you for a range of meta data (Title, Keywords, dates, etc) at the point of upload. This rule will look at that information and make routing decisions on what it finds in the ‘Title’ field.

image

If you scroll down, you’ll find a location to specific the location where any matching documents will be moved to. Select the Browse button.

image

You then locate the destination in the current Team Site. In this case it will be the Picture Library ‘Pictures’.

It is important to remember that you can only send matching documents from this rule (which uses a specific Content Type) to destination locations that also include that same Content Type. In this case, the ‘Document Types’ content is being used because it contains a type ‘Pictures’ which is the same Content Type that is applied to the Picture Library ‘Pictures’. In essence, you can’t move different types of file to locations that don’t accept that style of file. For example, you can’t move documents to a Team Site Calendar.

Once you have selected the destination from the tree, scroll to the bottom of the page and select the OK button to save your changes.

image

That path should now appear in the Destination field as shown above.

Scroll down to the bottom of the page and save your changes.

image

You should now be returned to the rules overview page as shown above, where the rule you just created appears.

image

Navigate to the Drop Off Library in the Team Site and select the option to upload a file.

image

The standard upload dialog box will appear but you should now see additional text at the top indicating that the Content Organizer feature is active.

Select a file to upload using the Choose file button and then OK.

image

The standard file properties dialog will appear that allows you to enter additional information about the uploaded file as shown above. Again, note the additional text at the top of the window indicating that Content Organizer is in operation.

image

In this case, to allow the organising rules to apply, ‘Home’ is added to the Title field.

Select the Check In button in the top left to save these changes.

image

If all is correct, the rule previously created should now be applied and you should receive a message like that shown above indicating that the document uploaded has been successfully re-rerouted to the destination you defined in the rule. In this case the uploaded image is re-rerouted to a Picture Library called ‘Pictures’.

image

If you now navigate to that location, you should see the document you just uploaded.

image

If a document is uploaded to the Drop Off Library and it doesn’t match any of the rules in place you will see the message above. This is basically saying that the document will remain in the Drop Off Library until further action is taken by an administrator.

image

The file will remain in the Drop Off Library until it is updated so the properties match one of the rules and it can be routed.

image

If email notifications have been enabled, those people will receive notification that items remain in the Drop Off Library and require attention before they can re-route as shown above.

In an upcoming post I’ll cover how a document can be re-routed using a similar method to a location outside the current Team Site.

Automating standard processes and procedure is the key to being productive. SharePoint includes many automation features to make life easier and importantly more consistent. Using Drop Off Libraries is but one method and hopefully as I have been able to illustrate, it is easy to set up and use.

Microsoft PowerApps

One of the most powerful aspects technology now provides us is automation. The problem is that I don’t see a lot of people letting the ‘bots’ do the hard work for them.

I have written about Office 365 automation here:

Office 365 automation

I’ve also highlighted how upskilling is required to stray relevant in todays environment.

Skill up or fade away/ It’s that simple

and such re-skilling up also means a greater focus on software rather than hardware.

Personally, I’ve been playing with Azure Logic apps to provide even more automation functionality but Microsoft has now made that even easier with Powerapps.

You’ll need to request an invite from the PowerApps site:

https://powerapps.microsoft.com/en-us/

and you should do so with your Office 365 login.

image

Once confirmed you’ll see a new tile appear on your Office 365 app launcher as shown above.

image

Selecting this will take you to the Powerapps canvas as shown above.

image

The place to start is the Connections option at the bottom of the menu on the left hand side. You should go there and connect up all the accounts you have including Office 365 Outlook, OneDrive, SharePoint Online, Twitter and more.

Once you have connected up to the different services you then need to elect whether to now create a Logic Flow or an App.

A Logic Flow is very much like an IFTTT recipe. That is, when something changes, take some action. An App is a bit more involved and typically means developing some basic screens for input and storing the data somewhere.

image

The Apps you create are then access via a PowerApp application on your device (Windows 10 and iOS so far).

image

Given that a Logic App is easier to create I’ll cover that. If you select the Logic App option from the menu on the left you’ll be take to a canvas on the right that allow to use an existing template or create a new Logic App from scratch.

image

You start a new Logic Flow by selecting a starting action.

image

In this case, I’ve chosen the trigger to be when a tweet including #office365 is found.

image

I then add an action or condition.

image

Here I added an action to send an email to my Office 365 inbox with the contents of the tweet.

I then save that Logic Flow.

image

The Logic Flow is then active and will run every time it is triggered.

I can continue to create more Logic Flows as desired.

It is still early days for PowerApps but I am very keen to see it develop and mature. I believe it is another key opportunity provided by the cloud for IT Professionals to move beyond merely maintaining IT to actually using IT to solve real world business challenges and streamlining business processes.

My advice? Get on board with PowerApps now!

CIAOPS Basic SharePoint Online Administration course now available

I have create a new short Introduction Sharepoint Online Administration online training course.

spo-admin

It’s a bit different from my other online courses in that it is much shorter and the cost is also much lower. I’m using it to see whether there is demand for these style of ‘short courses” and then maybe developing more along these lines. I’d love to know what you think about these style of ‘short courses’.

If you are interested, I’d encourage you to take a look at the new course and sign up. I’d also appreciate you referring the course onto others who may who might benefit.

You’ll find all my online courses at:

www.ciaopsacademy.com

and if nothing there takes your fancy, please contact me (director@ciaops.com) and let me know what you’d like to see so I can create it.

Azure and Windows 10 Enterprise State roaming

The march of Azure and Windows 10 integration continues on with the announcement of Enterprise State Roaming public preview.

image

This option basically allows Windows 10 machines that have their primary connection to Azure AD to have their settings roam between machines much like the situation now with Windows 10 and personal accounts.

To enable this you’ll need the most current build of Windows 10 and Azure AD Premium. You’ll then need to enable the setting in both Azure and Windows 10. This blog post from Microsoft outlines all the details:

More Azure AD and Windows 10 goodness: Enterprise State Roaming public preview!

To me this is further evidence of the growing native integration between Windows 10 and Azure AD. It also indicates why you should be payign close attention to this as it is becomes more powerful and feature rich.

Introduction to SharePoint Online

Here’s a longer webinar that I have created on the an Introduction to SharePoint Online.

In it you’ll get an understanding of how SharePoint Online integrates with Office 365, what plans are available and how to perform some of the most common operations with Sharepoint Online.

I’ve also made the slide deck of the presentation available on my docs.com here:

https://doc.co/RfbBqT/qcihGm

and embedded it below:

https://docs.com/d/embed/D25194776-8118-2654-5680-000630277702%7eMd4186d87-61d5-259a-4d26-00a8bd86cfff

If you want to learn about SharePoint Online beyond these basics, I’ll direct you to my:

Free SharePoint Online training course via email

Getting Started with SharePoint Online course

Configuring Shared Document Access using Office 365 Team Sites course

Working with Private Documents using OneDrive for Business course

SharePoint Level 1 course

Let me know what you think of this tutorial and what more you’d like to see me do around Sharepoint Online.

Get a free Display Dock for Lumia 950 and 950XL

Microsoft Display Dock

Microsoft is offering a free display dock for Australian customers who purchase a Lumia 950 or 950XL between November 2015 and March 2016. The display dock allows you to connect your Lumia 950 or 950XL phone to external devices such as keyboards, monitors, mice, etc. This supports the continuum features of Windows 10 Phone.

To take up this offer follow these steps.

image

Fire up your Lumia 950 or 950 XL and open the Lumia Offers apps. If you don’t have this app on your phone simply download it from the store.

wp_ss_20160203_0001

When you opne the app you should see the Display Dock Offer as shown above. Select this.

wp_ss_20160203_0002

Ensure that you email address is listed in the box on this next screen and select the claim button at the bottom of the page.

image

You should then receive an email with a promotional code and a link to a site where you can enter the code.

image

Just enter the code you received in the email and select Submit. The code will be verified and if all is correct you’ll then need to enter a shipping address for the dock.

image

You’ll then receive a confirmation email that you claim has been submitted and you should receive your dock in 6 – 8 weeks.

I think the display dock is a ‘must have’ for Lumia 950 devices and now there is no reason not to get one. Good on ya Microsoft.

Need to Know Podcast–Episode 96

Marc Kean now joins me on a regular basis with the podcast to share his knowledge and experience on Azure and PowerShell. Marc also lined up our guest for this episode, Reid Purvis, Microsoft Cloud Infrastructure Technical Specialist based in Sydney.

Reid explains what Azure Express Route is all about and why it makes sense for even the smallest organisation these days. If you want to learn about Azure Express Route then this is episode for you.

You can listen to this episode at:

http://ciaops.podbean.com/e/episode-96-reid-purvis/

or subscribe to this and all episodes in iTunes at:

https://itunes.apple.com/au/podcast/ciaops-need-to-know-podcasts/id406891445?mt=2

The podcast is also available on Stitcher at:

http://www.stitcher.com/podcast/ciaops/need-to-know-podcast?refid=stpr

Don’t forget to give the show a rating as well as send me any feedback or suggestions you may have for the show. 

Resources

Azure Service Updates – https://azure.microsoft.com/updates

Azure Resource Manager – a holistic view of Azure Resource Manager – https://resources.azure.com

Australian Azure Express Route – Getting Started

https://azure.microsoft.com/en-us/services/expressroute/

http://resources.azure.com/

https://azure.microsoft.com/en-us/

Reid Purvis

Microsoft Cloud Infrastructure Technical Specialist (Sydney)

Email: reid.purvis@microsoft.com

Mobile: +61 427 038 685

Follow Me On Twitter: http://www.twitter.com/rpurvis  (@rpurvis)

Need to Know Podcast–Episode 95

In this episode I’m joined by returning guest James Eling from Extreme Networks to talk about leadership, especially business leadership. James shares both his extensive knowledge and experience of being a leader both personally and in business. You’ll get some great insights here about what skills it takes to lead people and organisations through the process of improvement.

As always, a big thank you to Marc Kean for producing this episode and doing the intro and outros.

You can listen to this episode at:

http://ciaops.podbean.com/e/episode-95-james-eling/

or subscribe to this and all episodes in iTunes at:

https://itunes.apple.com/au/podcast/ciaops-need-to-know-podcasts/id406891445?mt=2

The podcast is also available on Stitcher at:

http://www.stitcher.com/podcast/ciaops/need-to-know-podcast?refid=stpr

Don’t forget to give the show a rating as well as send me any feedback or suggestions you may have for the show. I’m also on the hunt for some co-presenters so if you are interested on being a regular part of the show please contact me.

Resources

Get Started with the OneDrive for Business Next Generation Sync Client in Windows

Enabling Office 365 Planner

Retaining your OneDrive bonuses

Beware of malware Office 365 statements

Enterprise Mobility Suite

CIAOPS Academy

James Eling
www.extremenetworks.com.au
jeling@extremenetworks.com.au

@extreme_james

Mastering the Rockefeler Habits – Verne Harnish