Posts

Nintex Workflow - How To Set a DateTime field to Current Date AND Time

Image
What:  Surprisingly had some trouble with this simple task, so here's how you can avoid wasting 20 minutes of your life.  If you have a list column that is of type Date AND Time, it can be difficult to set it to the current date and time inside a workflow. Why:  You might like to do this if you were logging changes to items to a separate list for reporting on later. How (quick): Create a string variable called 'CurrentDateTime', set the string variable to equal 'CurrentDate[space]CurrentTime'.  Set your DateTime list column to equal the workflow variable CurrentDateTime. How (detailed): Create a Workflow Variable called ' CurrentDateTime ' of type ' Single line of text ' Create a 'Set Variable' step and set CurrentDateTime to equal value: Current Date[space]Current Time (these two values can be found under common variables tab). Update the field on the list item to equal the Workflow variable you just set.  In my ...

How To Set Up a Personalised Shortcuts List on a SharePoint Site

Image
What is this?   A tutorial on how to set up a cool list on SharePoint where staff can manage their favourite links, ideally on the homepage of your intranet. This keeps all their commonly accessed web-stuff 1 click away, and it means you do not have to fill up your SharePoint navigation with 100's of useless links that only 5-10 people use. Woah that sounds sweet, how is that even possible!?   Well I'm going to show you how, in this tutorial we are using SharePoint Online, because then this post will be relevant for more than a year. Step 1:  Create a Custom List called 'Personal Shortcuts' by clicking Settings > Add an app , and selecting 'Custom List'. Step 2: Create a new column in your new list by clicking the List Tab > Create Column .  Call the new column ' Shortcut ', Set the Type as ' Hyperlink or Picture ' & make sure the column requires a value . Step 3: Now we need to remove the Title column from this list...

SharePoint - What Should Be Allowed to go in Global Navigation?

I'll make this real easy.   IF EVERY SINGLE USER NEEDS IT , then it can go on global navigation. Otherwise, you're wasting precious navigation space for links nobody wants. Still really need a selection of staff to have one-click access to something?  That's fine, you should look at implementing a personalised list of shortcuts on the homepage that each user can manage themselves.  That way that specialised safety system they access everyday takes up their screen space and no one else's. That brings me to : How To Set Up a Personalised Shortcuts List on a SharePoint Site This is almost a golden rule for me, what're your thoughts?

The Best OOTB Cross-Site Collection Navigation Solution for SharePoint Online

**UPDATE: This post is now outdated & I suggest using SharePoint Hub Sites to get Cross-Site Collection Navigation I will start by saying:   This solution sucks, but I've done my fair share of research/testing/swearing so you don't have to.  This is the best option you can currently achieve with OOTB (Out-of-the-box) functionality. Problem:  Many large companies moving to SharePoint Online have the same problem.  They have enough data that it needs to be spread out across multiple site collections.  How the data should be split up is a different story .  The fact is, they would like to have consistent Global Navigation across all site collections. Reasons why you would want the same global navigation across all site collections:  Visibility of everything that exists within the SharePoint Online Tenant Consistent navigation simplifies the User Experience, allowing them to be comfortable in any Site Collection without having to remember a ...

MS Ignite - Power BI: The Developer Edition (DAT341)

Image
some brief notes on what was learnt in this MS Ignite session Link to session video:   https://msftignite.com.au/sessions/session-details/1776/power-bi-the-developer-edition-dat341 Covered in the session: A feature to publish Power BI Desktop reports to SQL Reporting Services is coming soon! The Power BI Team is working on tiles able to be embedded on a web page and viewed by anonymous viewers.  Will be able to embed entire dashboard at some point. Link for developer information is at the bottom of power BI home page (https://powerbi.microsoft.com/en-us/developers)  How to extend Power BI using custom visualisations Can embed Power BI Tiles into PowerPoint presentations REST Api's are available to do things like  list all tiles & dashboard & datasets and tables and groups Can find approved custom visuals here: http://app.powerbi.com/visuals Can't pin custom visuals to dashboards yet.  team estimates late December You can download Custom Vi...

Power BI Suites - Which One Do I Use?

Image
I'm presuming you've seen the god-like feature set of Power BI.  I reckon you've probably even opened up browser edition and had a quick play.  Then you've come to the realisation that yeah it is just as awesome as that presenter advised!   But how does it fit together with the rest of the Office 365 suite, and why are there so many different ways to use it!? Here's a quick historical view of the product and a brief introduction into the pros/cons of each option to help you choose a path based on what your business requirements are.  Truth is, you'll probably want all options available to you, however each new solution might require a certain platform. If you take ANYTHING away from this post, remember there are three ways you can use the Power BI suite:  Excel Add-Ins, Power BI Online App, Power BI Desktop App... Excel Power BI Suite (PowerPivot, PowerQuery, PowerMap, PowerView) Before Power BI became an entity of its own, it was initially birthed as ...

HP Laserjet 1022 Printer - Can't Print on Windows 10

If you are having trouble getting your laserjet working on Windows 10, here's how I resolved the problem: Go to Devices & Printers Find your printer & go to Printer Properties > Advanced Tab Set Driver to: HP LaserJet 1022 Class Driver & Apply If HP LaserJet 1022 Class Driver is not available.  download from this site:  http://support.hp.com/us-en/drivers/selfservice/HP-LaserJet-1000-Printer-series/439424/model/439431   Print a test page.