Setting a hyperlink column’s value using Power Automate is a bit different than setting other column types’ values. In SharePoint, a hyperlink column has two components – address and description. If you update this column type using Power Automate’s “Update item” action, your address and description are both set to the same value.
In SharePoint Designer workflows, we could do this easily with the usual “Set field” action:
But in Power Automate, we only get one field which maps to the URL/address part of the hyperlink field, and is duplicated as the description as well in SharePoint.
And if you’re thinking it could work with a comma, as some other field types might, it won’t. You’ll get “Enter a valid uri.”
To get this to work so we can set both address AND description as separate values, we have to use an HTTP request action instead of (or in addition to) the Update item action. This isn’t as complicated as it may sound. Here are the steps:
1. Add the Send an HTTP request to SharePoint action
2. Choose or enter your site for Site Address
3. Set Method to POST
4. Set the Uri to the following, changing List Name to your list’s name, and replacing [ID] with the ID field from dynamic content
Test that out. When it’s working and you’re ready to take it to the next level, you can replace the static url (like Google’s in my example) with dynamic content. For example, you could create convenient one-click links to an item’s version history:
If you’re trying to import a spreadsheet as a new list in SharePoint, you’ll need to use a browser that supports ActiveX controls or you’ll get the error:
“This feature requires a browser that supports ActiveX controls.”
Chances are you’re running a browser other than IE, or you’re running IE version 11. ActiveX controls are not supported in IE11, or most browsers. We can work around this error message by having IE pretend it’s version 10 momentarily.
Open SharePoint in Internet Explorer (IE)
Quick access: Hit Windows key, type IE, hit enter
Press F12 to open Developer Tools and select the Emulation Tab
Change Document mode from 11 to 10 (supports ActiveX). Page will reload so you can try again in version 10.
Now try to import the spreadsheet again and it will work fine, opening your spreadsheet and prompting you to select the table or relevant data for import.
You may have already seen some new options when sharing links to files in SharePoint (and OneDrive). Here’s what’s available in my tenant today:
If you use the “Anyone with the link” option (for anonymous access) you can choose a date on which the link will expire and access will no longer be granted via that link.
You can block people from downloading only if you uncheck “Allow editing” for the link types that support it.
Your basic options are to allow anonymous users (with or without an expiration date) to:
Edit & Download
View & Download
View Only
You can also easily share with people only in your tenant, even if they don’t have prior access, and choose whether they can edit, view and download, or just view.
People with existing access is useful just to Skype/Teams someone a quick link to get to the file. Their pre-existing permissions apply.
Finally, “Specific People” can allow you to share with external users but they must use the address you share with, as they’ll be sent a verification code to validate their identity. This adds a layer of security to otherwise anonymous share links.
Enter addresses you’re sharing the file with and click send or copy the URL to share through another avenue.
The user receives an email with a link that takes them to a page to validate the email address.
Then they’re emailed a unique security code to validate their identity/ownership of the email address.
Note: You may not be prompted to enter your email address if opened directly. But if the email is forwarded, user will be asked to verify email before they’re able to send a code.
A newer feature in SharePoint allows you the option to “Notify your team” after a new file is uploaded. Your upload process is the same, but then your “upload complete” dialog now has an additional option:
When you select “Notify your team” you’re presented with options like sharing with SharePoint groups, or just individuals manually entered.
When finished, click “Notify” and the intended recipients receive a link that only works for them when logged in.
If you attempt to share with someone not in your tenant, you will receive an error as you can only notify people with existing access.
For these external users, you can instead separately share via the usual “Share” dialog when a file is selected. Here you’ll also find a newer feature that allows for blocking downloads if the “Allow editing” box is unchecked. This would prevent people making edits offline and creating multiple versions in silos.
I’ll be speaking this Saturday at SPS Cinci (#SPSCinci2018). I’ll be presenting my brand new, magical session on content management, archiving and retention for the third time this year. Don’t miss it!
SharePoint wizardry for content management, archiving & retention
Are your muggles muddying up your servers and site storage with duplicate files, pictures from a 2008 staff party and files named “April” in folders called “Jane’s stuff”? Learn how to most effectively destroy the 8th horcrux using out-of-the-box functionality in SharePoint brewed with bits of governance, content strategy and just a little help from SharePoint Designer to help automate processes. It’s just like magic!
I’ll be speaking this Saturday at SPS Baltimore (#SPSBMORE). I’ll be presenting my brand new, magical session on content management, archiving and retention for the second time this year. Don’t miss it!
SharePoint wizardry for content management, archiving & retention
Are your muggles muddying up your servers and site storage with duplicate files, pictures from a 2008 staff party and files named “April” in folders called “Jane’s stuff”? Learn how to most effectively destroy the 8th horcrux using out-of-the-box functionality in SharePoint brewed with bits of governance, content strategy and just a little help from SharePoint Designer to help automate processes. It’s just like magic!
My local SharePoint Saturday, SPS Kansas City, is coming up THIS WEEKEND (#SPSKC). I’ll be speaking about one of my favorite topics – building a modern intranet:
Building the Intranet of the Future: Using SharePoint to Empower Collaboration
Automation, organization, incredible search capabilities and user interactivity; all things your organization can have in choosing to build an intranet with SharePoint. We’ll discuss avoiding File Dump 2.0 by exploring best practices in internal communications and collaboration via intranets. We’ll also cover rethinking forms and minimizing busy work by utilizing automation capabilities via workflow and designing intuitive navigation.
I’ll be speaking this Saturday at SPS Denver (aka SPS Colorado) (#SPSColo). I’ll be presenting a brand new, magical session on content management, archiving and retention:
SharePoint wizardry for content management, archiving & retention
Are your muggles muddying up your servers and site storage with duplicate files, pictures from a 2008 staff party and files named “April” in folders called “Jane’s stuff”? Learn how to most effectively destroy the 8th horcrux using out-of-the-box functionality in SharePoint brewed with bits of governance, content strategy and just a little help from SharePoint Designer to help automate processes. It’s just like magic!
The 3rd annual SharePoint Saturday Pittsburgh (#SPSBurgh) is coming up this Saturday. I’ll be speaking about one of my favorite topics – building a modern intranet:
Building the Intranet of the Future: Using SharePoint to Empower Collaboration
Automation, organization, incredible search capabilities and user interactivity; all things your organization can have in choosing to build an intranet with SharePoint. We’ll discuss avoiding File Dump 2.0 by exploring best practices in internal communications and collaboration via intranets. We’ll also cover rethinking forms and minimizing busy work by utilizing automation capabilities via workflow and designing intuitive navigation.
Based on his 100th blog post, Nate Chamberlain presents “The ABCs of SharePoint: 26 ways SharePoint can enhance your digital workplace”. Can you think of something in SharePoint for every letter of the alphabet? This book will help you fill the gaps teach you more about things you could implement in your own existing SharePoint environments. From Automation to Zone Templates, Nate shares 26 features and topics that set SharePoint apart from any other collaborative platform.
Work within a single site collection and perform advanced approval processes, metadata automation, permissions management and more using SharePoint Designer
Automatically generate new items and documents, send emails and more based on if/then statements you create
Calculated columns
Your lists and libraries already track who is creating, when they’re creating and information from users’ profiles. Add to this automatically-collected metadata by creating calculated columns to extract “Year” from date, sum multiple columns for a total, or display the duration until/since a date
B | Buttons & Iconography
Iconography is important in digital workplaces. Your users should, on any one page, be able to recognize where they are and what they can do easily by observing navigational elements (breadcrumbs, menus, etc.) and buttons/icons. Instead of simple text links, use buttons/images to give a more polished look that provides for quick visual recognition.
Check out Stacy Deere-Strole’s “Quick Wins: #4 – Promoted Links” to learn of a quick anyone-can-do-it method of adding icons/buttons to your pages using the Promoted Links app. You can also add a hyperlink to any image to create a single “button” experience.
C | Content Types
Content Types are essentially templates for lists and libraries. While your list may have 15 columns, content types allow you to show only certain fields conditionally. For example, a person may submit an item with 4 fields and a workflow can change the content type to an “Admin” content type which might “add” two additional fields for approval and comments.
In Document Libraries, content types allow attaching any office file as a template to each content type. This means when a user clicks “New” their options could be “Vacation Request”, “LOA Request”, “Time Off Request”, etc. And each content type could have its own separate workflow process, metadata, views, etc. But they all exist in one library.
D | Document Sets
Document sets are great for collecting many files that all share the same metadata. For example, when working with projects all documents associated with it would have the same client, vendor, organization, project number, project manager, contact info, etc. The document set works as a sort of folder, and all documents added to it then get the same metadata automatically. You can also set a document set to include certain templates or links by default so that upon creation, a document set already has all the forms, templates and folders it needs.
E | Embeds
SharePoint, especially SharePoint Online, allows for embedding all kinds of items in your pages:
YouTube Videos
Code
Power BI Reports
PowerApps forms
Other web pages (if the content is allowed in iframes)
Any SharePoint media content or files
See “W | Web Parts” below for more ideas of what could be embedded in your SharePoint pages
F | Forms
Whether a customized PowerApps form or an out-of-the-box SharePoint form, every list and library is able to give users a “form-like” experience for completing metadata. You could, for example, have a list for time off requests and use the default newform.aspx page or you could use SharePoint Designer (server/on-prem) or PowerApps (O365) to create custom new item forms. Each content type (see “C | Content Types” above) can have its own new item form as well.
Governance is an essential component of any digital workplace. Governance typically involves a group of individuals with different experience levels, and different departments/business processes. These individuals help guide decisions around appropriate usage and standards for your intranet and its content.
Check out How to create a SharePoint Governance Plan (includes template) for ideas on how your governance committee could get started in creating a more consistent, clean and user-friendly intranet with priority and focus on relevant content and its maintenance.
H | Hub Sites
“[Hub sites] are the ‘connective tissue’ you use when organizing families of team sites and communication sites together.”
Hub sites are relatively new and available in Office 365. Think of them as buckets in which you’ll organize your existing sites, or landing pages for groups of sites. Learn more here.
I would venture to guess that intranets are the number one usage of SharePoint. With all the possibilities in automation, content management and strategy (including retention/archiving), communication and document collaboration it makes it a natural choice for companies needing more than just shared documents. And with Office 365, your intranet is everywhere with you thanks to the SharePoint mobile app and mobile compatibility.
Being able to customize sites, pages or just lists with your own javascript and JSON is a must for many. On classic/on-premise sites, you can implement your own javascript and css. Check out this example of using javascript and jquery to create customized, floating headers for SharePoint list.
In the modern experience, you’ll need to learn about SPFx and can use JSON to do things like conditional column formatting.
Knowledge management is just as important as the technology we use to contain it. If you haven’t read Content Strategy for the web, you need to. It’s one of my absolute favorite resources I turn to repeatedly. I was surprised at how ready SharePoint was to incorporate the practices and concepts in this book – it’s a perfect pair.
This book helped me recognize the importance of nurturing good content management practices as well as developing and maintaining efficient content managers. It clearly defines separate content and people concepts and leaves you with many ideas you can begin exploring or implementing right away to improve your organization’s knowledge management, no matter the scale. And it’s a fun read – it’s written with light humor which makes an otherwise ordinary topic an exceptional read.
So if you want better search, less frustrated users, relevant content, effective and active archiving and retention policies, a sense of content ownership and clearly defined roles this book will help you get there.
L | Lists & Libraries
Lists and libraries are the main, most frequently used, web parts (see W | Web Parts below) in SharePoint.
Lists function like spreadsheets, and can create a sort of “dashboard” where you use list views to display the most important data from each list item/form submission and then you can open the item to see full detail. You can attach documents to list items, but it’s not easy to later pull all those attachments or move them. A library might suit your process better if you’ll have lots of attachments.
Libraries contain documents (of all types) and are basically an upgraded version of lists. The emphasis is placed instead on the actual document to which you can assign metadata just the same. Thanks to co-authoring, workflows, versioning and item-level permissions, libraries in SharePoint are at the forefront of digital collaboration.
M | Metadata
Metadata is a love letter to your intranet’s future. By setting up metadata (additional columns in lists and libraries) you’re making it possible to:
Simply rearrange all documents or items in just a few clicks
Improve search
Perform workflows based on metadata values
Enable reporting with better filters, sorting and counts (using Power BI or exporting to Excel)
Eliminate the need for folders in favor of views
Create “lookup columns” of coordinating metadata from other lists for a database-like experience
N | Navigation
Navigation is critical to user-adoption. As mentioned in “B | Buttons & Iconography”, users should be able to recognize where they are, what they can do and where they can go from any page on your intranet. You can use a combination of visuals and menus to achieve this. Also consider placing emphasis on search in SharePoint – it’s perhaps the most efficient way to find what you’re looking for if maintained and set up correctly.
Make sure your menus are consistent. No matter what page a user is on, the navigation should be similar, if not identical, throughout. It’s nice to customize and personalize, but it’s nicer when a user knows just where to look for similar information across different departments.
O | Office 365 Integration
SharePoint integrates seamlessly with other O365 apps to create a one-stop shop experience. Whether embedding, building workflows or customizing content you’re likely to experience any of the following apps within your SharePoint environment:
In SharePoint you can use item-level permissions, site or object-based permissions or any combination of the two. But of course it’s best practice to minimize the breaking of inheritance and try to manage permissions on a group basis rather than individuals.
For example, at LMH we manage our security groups in AD rather than SharePoint so that when people leave, we don’t need to remember to remove them from multiple SharePoint groups as well since they’re already being deactivated in AD. But find what works best for you and your sysadmins and make sure you’re on the same page in routine management of those groups.
One of my favorite things about SharePoint is how it’s security trimmed so that people won’t even see links to sites or find search results to things they don’t have permission to access. Everyone in an organization could, in theory, have a completely custom and different experience thanks to search, permissions and the office graph.
Q | Queries & Search
As mentioned before, search could well be the best way to navigate in SharePoint. But aside from search, you can also use the content search and content query web parts to search for certain content across your collection(s) and display them in a block on any page. For example, maybe you want to aggregate all calendar items from multiple sites into one list on your home page. Or you could link a button to the most recent document uploaded to a library, such as always linking to the current lunch menu.
You can also customize search and build your own search results display template, filters, etc. and limit the scope of a search. For example, I’ve built mini-search pages for video libraries to give departments a YouTube-like experience which only searches their videos and has custom search refinement panel on the left with specific metadata to filter results.
R | Roadmap
Stay up-to-date on what’s been released, what’s coming soon and what’s in development by watching the SharePoint Roadmap.
S | SharePoint Saturdays & Conferences
There are many free opportunities for professional development near you. SharePoint Saturdays bring in industry experts, including many MVPs, MCTs, etc., to share what they know and love. Learn from the pros, at no cost to you, and take home some new knowledge (and swag).
Matt Wade has done a phenomenal job listing many of the upcoming SharePoint events (free SPS events as well as paid registration conferences) on his site. You can subscribe to his calendar or download the listing here. You can see me at these upcoming events.
T | Tasks & Timelines
One of my largest use-cases is project management in SharePoint. People are very interested in task lists that can email you and remind you when things are overdue.
Workflows in SharePoint Designer can assign tasks which are posted to the Workflow Tasks or Tasks list in SharePoint. You can set overdue reminders on these as well in SharePoint Designer that send at a regular interval until completed. Those assigned can also reassign tasks.
Even without workflow, you can have any number of task lists you manage in SharePoint and associate that list with a timeline. It’s an easy way to share with your team what’s going on and who is responsible for what. Pair a list with a timeline or Gantt chart for an added “wow” factor.
U | Usage Reports
Analytics are incredibly important for measuring the success (or lack thereof) of content and communication. It’s also nice to understand popularity trends. Out of the box, SharePoint has some usage and search query reports (site settings –> popularity and search reports) but you’ll want to pair this with Google Analytics or another analytics service to get more robust insights on user trends and behaviors.
V | Versioning
By activating versioning, you’re allowing users to see what changes have been made to metadata, compare the current version of an item or document to a previous version, or restore a previous version. You can also allow both major (published) and minor (draft) versioning.
W | Web Parts
Web parts are the building blocks of SharePoint pages. These can be static or dynamic, for display or for interaction. Depending on whether your page is modern or classic, you have different options:
Modern web parts:
Classic web parts:
X | XML and XSL
You might be editing XML and XSL if you’re on-premise or using server and attempting to change a look or layout the old fashioned way. If online/O365 you’ll likely be modifying the SharePoint Framework (SPFx) instead.
Y | Yes/No Functionality
The default “yes/no checkbox” option as a column type is great for placing boxes on forms for quick checking
Use a choice field with Yes and No as options and a bit of javascript to conditionally display fields based on the response
Build if/then workflows in SharePoint Designer or Microsoft Flow that move to different stages/steps based on a user’s response to yes/no prompts
Z | Zone templates
If on-premise/server, you may be creating custom layouts using zone templates in SharePoint Designer, or just wanting to learn more about web part zones.
