Like Us
Plus One
Follow Us
Search
 Name Mikael Svenson  Blog Tech and me
 Location Oslo, Norway  Category SharePoint
 Articles 226  Views 89438

Articles from Tech and me

s
Blocking vs. non-blocking Flows      02-Oct-2017     141  
Microsoft Flow has many triggers and one of the most useful ones is the HTTP request trigger, where an external party can call a specified endpoint with a message which will trigger the workflow. B...
This is a super technical post and it goes like this: If you use NuGet and reference PnP as well as ADAL and Graph clients as I have above, and you write code to apply a pnp template you might r...
If you’ve followed my blog lately you know I’m experimenting with using Graph Extensions from the Microsoft Graph to persist metadata for resources in the graph, more specifically I’m storing metad...
I’m creating a couple of web parts using SharePoint Framework in my current project so I figured I’d share a small helper class I created for performing GET requests against the Microsoft Graph. Th...
[Read my follow-up post at: http://www.techmikael.com/2017/09/an-approach-to-working-with-schema.html]I’m trying to build out a solution for custom metadata for Office 365 Groups and it’s not that ...
I wrote a post last week about my issues with custom metadata and the Microsoft Graph. The week ended leaving me on the fence on which way to go. However, a couple of days off has sorted my brain a...
Europe’s Largest SharePoint, Office 365 & Azure Conference is approaching fast. I’ll be presenting How to Take Control of Your Office 365 Groups – Using Technology to Solve Business Processes, ...
[Update September 2nd, 2017] I’ve updated the steps to remove the node_modules forlder, as that seems to fix some of the build libraries. -- With the release of SharePoint Framework Extensions R...
This post relates to Azure functions written in C#, hosted as a Function App – and maybe the title is a tiny bit clickbaity ;) I’m in a project where writing small Azure functions to accomplish pi...
As Codeplex is shutting down the repository for the SharePoint Query Tool has been moved over to the PnP Tools repo. I’m very happy about this move, and if you want to make changes or additions, fe...
If you write Windows Applications or PowerShell scripts to connect to multiple tenants you have probably experienced the “That didn’t work” dialog where the web based login tries to log you in wi...
I’ve been working on a web part for a customer lately and was going to bundle it up and install it at the customers tenant. When I ran gulp --ship to prepare the bundle I got the following error: ...
The unique identifier for a Communication site is the web template used, and the name of the template for Communication sites is SITEPAGEPUBLISHING. With this piece of information there are a coup...
Enable external sharing on Communication sites      11-Aug-2017     25  
By default when you create a Communication site, external sharing has been disabled. As Communication sites are not listed in the site collection admin UI you need to turn to code or PowerShell to ...
What is Microsoft 365?      10-Aug-2017     19  
I’ve read numerous posts after the release of Microsoft 365 at Inspire stating that Office 365 now has a new name. This is not the case. Microsoft 365 is a combination of: Office 365 Wind...
With version 1.1.3 of the SharePoint Framework yeoman generator it is now possible to specify for a SPFx solution to be tenant wide available. This means that when you upload the solution to your t...
Yesterday I wrote about how the build process has changed for SharePoint framework web parts using the Office UI Fabric components and Fabric Core CSS. Previously you could take a dependency on w...
I was making some updates to a SharePoint Framework web part which utilized the React Office UI Fabric components today. Previously when I built the web part, the bundle .js size was about 10kb. Wh...
Yesterday I was helping another consultant with some search rank issues. We had an hour scheduled and managed to resolve the ranking well enough. But then I got the question, do we have time to add...
Typically the icon for a custom ribbon action in classic pages is 32x32 pixels. On modern lists the icon however is 20x20 pixels. If you use a 32x32 pixel image this is what it will looks like in c...
I’m working with a set of SharePoint framework web parts and finally got fed up of using JSOM to work with managed metadata. Referencing JSOM feels wrong for so many reasons in this modern day and ...
Note: This article is based on the preview of Communication Sites Microsoft announced the preview of Communication Sites in first release a little over a week ago. At first I was expecting more, b...
Fetching values from the query string of the URL is something developers are constantly doing, as in this sample URL where I have two parameters, mvp and status. https://madcow.sharepoint.com/?m...
I’m creating a web part which will talk to a signalR back-end service for some document archiving with SharePoint. signalR on the client requires jQuery, which is the tricky part. I tried a few t...
I’m doing minor work on a SharePoint 2013 installation every now and then and got a request to render the Related Items column introduced in SharePoint 2013 as an actual link instead of showing the...
This topic has been covered before (here and here), but I was recently in a conversation where this was brought up, so thought I’d do a short refresh. To sum it up quickly; you need to purchase se...
Re-introducing Microsoft Forms      20-Jun-2017     169  
About a year ago I wrote a post outlining the Microsoft Forms functionality which at the time was available only to educational tenants (EDU license). This time around Microsoft has decided to l...
I have previously written about how to change the layout type of a modern page using PnP PowerShell in order to get rid of the huuuuge top banner. Yes,  I know Microsoft is in the works of add...
You can find the complete sample web part at: https://github.com/wobba/spfx4fun/tree/master/GraphCallTest With the recent release of the Developer Preview of the SharePoint Framework it’s now poss...
I got this tip from Paul Schaeflein via Slack that if you navigate to https://aad.portal.azure.com you can access the AAD of your tenant without signing up an Azure subscription. Awesome for trial ...
As I’ve written about before, when you create a new Office 365 Group, the Team Site will get a random funky color, often pink – a color most organizations would like to change. This can be changed ...
This might be know to all PowerBI guru’s out there, but as I’m a newbie doing this and couldn’t find an article right away I figured I’d jot it down for future reference. And a big thank you to my ...
Office 365 Groups are here to stay and I’ve gotten to love them more and more, and for the past six months this is primarily what we at Puzzlepart are rolling out with our customers. If you’ve foll...
Azure information protection let’s you classify and add policies to documents regardless of where they are stored, but is tied to an Office 365 tenant. AIP operate directly on the Office files, and...
Yesterday Microsoft announced two new Insights endpoint (in beta) to the Microsoft Graph in addition to the trending one which was already there. The new endpoints are: Used - returns the most ...
Yesterday I wrote about how you can save an image from PowerApps to a SharePoint library using Microsoft Flow – after reading about Paul Culmsee’s approach using Azure Functions. Paul challenged me...
At the time of writing there is a gap using PowerApps with SharePoint which won’t let you save a captured image from PowerApps directly to SharePoint. There are numerous posts out there about this,...
While we’re waiting for full support for modern pages and how they work in Office PnP and the SharePoint Framework, here’s how you turn off the banner on article pages – basically setting them to...
Ever since private Office 365 Groups were launched we have been troubled with search in these sites. First it didn't work at all, but later Microsoft made it work in the site itself, in Delve a...
Creating a .pnp provisioning template file      21-Apr-2017     178  
After my demo on the PnP screen cast where I showed a provisioning solution based on PowerShell and Azure web jobs, I’ve had some questions about how you go about creating the .pnp files we use f...
Improved navigation for Office 365 Groups      21-Apr-2017     173  
A colleague showed me yesterday that now you can actually navigate from a Group site to any other resource. Just click the site title, and a menu appears. I have no idea when this was rolled out, a...
Why the new Microsoft is cool–rapid bug fixing      19-Apr-2017     161  
I had a customer report that the label when closing a card in Planner gave the wrong impression of the actual action. The term used was “Forkast”,(English “Dismiss”). The labeling gives the impress...
I had the pleasure of doing this web cast with Vesa Juvonen recently where I do a demo of how you can set up a pretty simple provisioning solution to let users order new team sites in SharePoint On...
Curious on what I sound like if you’ve never met me? Now is your chance. I was recently a guest at Tobias Zimmergren’s Rencore Tech Talk episode 6, where we talked about PnP provisioning and how y...
If you don’t care about the backdrop or thought process, skip to the end about how I envision Office 365 Groups to help organizations in the future.Once upon a time someone came up with the idea th...
SharePoint Search Query Tool v2.6      29-Mar-2017     150  
It’s been a year and figured I’d put out a small fix release. The tool should now work properly with ADFS, UAG and TMG. We’ve also fixed the issue with multiple SPO tenants, where the application ...
Johan Åslund tweeted about a support article showing how to restore an Office 365 Group using Powershell. This is a long wanted feature, and you will be able to restore a soft deleted Group wi...
Recently I wrote a post how to set classification on Office 365 Groups. If you want to restrict or govern who can create Office 365 Groups, you can basically use the same script. I’ve adapted the s...
There was a news item (MC96611) which peeked my interest in the Office 365 message center the other day about auto creating Office 365 Groups for “direct reports”. The support article states: Begin...
Microsoft has a support article explaining how to change the allow or deny policy of inviting external members to an Office 365 Group via PowerShell. This is all nice, but it doesn’t scale well in ...
I’m calling the Microsoft Graph with Office 365 groups these days and I stumbled upon a new SharePoint endpoint for Groups.If you call:https://graph.microsoft.com/beta/groups/821b0970-fae7-4640-bb2...
Ok, that’s not entirely true, but it might come in handy for sure… Unless you are all new to SharePoint pages, the chance that you have used at least one script editor web part or a content editor...
In a current project we are making heavy use of the modern layout for lists, libraries and pages in Team Sites. I’m very much known for scoping things down, but the huuuge header of modern pages ju...
Modern and it’s funky accent colors      06-Mar-2017     228  
I’m all about doing funky and random stuff, but the way accented colors are applied on modern pages in SharePoint Online has the distinct taste of fungi. The colors scheme of the tenant has no be...
A quick note, at the time of this writing you have to use the preview commandlets as the released one is missing the settings commands needed.First off you have to install the AAD Preview V2 PowerS...
I want full control over sites and Office 365 group creation and I’ve seen the setting in SharePoint Online Admin for ages to specify my own form URL. My bad for not testing this earlier. Well...
Before setting the scenario, the solution to my problem would be either an Office 365 group with dynamic Azure Active Directory membership where all services in the Office 365 group where opt-in an...
SharePoint web hooks has made it out from preview and into general availability, and is a great way for applications to act on changes to items in SharePoint. Think workflows where you want to run ...
How to consent to an Office 365 service app      08-Feb-2017     218  
At times you might want to create services which interact with the Microsoft Graph or Office 365 API’s.If your application has an actual web page you will get prompted for consent when you visit an...
This post outlines some of the differences between an Office 365 Group Modern Team Site and a plain old SharePoint Team Site as of February 7th 2017. The gaps may or may not affect you, but from a ...
Took me some testing to get this right, but turned out not that hard. You add a reference to the Title field with the out-of-box id fa564e0f-0c70-4ab9-b863-0177e6ddd247, and then change the display...
For some time now automatic managed properties in SPO are listed grayed out, with no settings shown. They sort of seem like ghost properties, not usable for anything. Fortunately this is not true. ...
By default when you run a search REST query against SharePoint Online results from private Office 365 Groups are not included. By adding &Properties=’EnableDynamicGroups:true’ to the URL, you ...
Ever since Office 365 Groups was released in preview the discussion “when to use what” has been going on between Office 365 Groups and Team Sites. I’ve been opinionated in the debate myself, bu...
The Calendar - Office 365 Groups Scenarios (1/4)      15-Dec-2016     225  
Ever since Office 365 Groups was released in preview the discussion “when to use what” has been going on between Office 365 Groups and Team Sites. I’ve been opinionated in the debate myself, but in...
My colleague Tarjei had a requirement to list items in a particular order on a page. The items were tagged with different phases and he wanted items to be listed in this order: Concept Pl...
Two SharePoint Online search nuggets from Ignite      10-Nov-2016     313  
Ignite is long over, but there were two very useful nuggets in the session BRK2045 – Explore new personalized, intelligence powered search experiences in SharePoint, Delve and O365. Disclaimer: We...
I was talking to Andrew Clark and he was pretty frustrated after debugging a search issue. Turned out the query template was written like this: {searchTerms}path:http://intranet.contoso.com/sale...
Whac-an-MVP - creating a PowerApp Game      03-Nov-2016     334  
PowerApps shows a lot of potential to enable power users to create line of business application for their organizations and teams. It’s cross platform, and I see a lot of good mobile use cases for ...
Creating a resize animation in PowerApps      02-Nov-2016     358  
PowerApps made general availability November 1st 2016, and provides a great way for line of business specialists to create no-code applications to solve business challenges they see in their depart...
There are numerous posts out there about how to do this, but thought I’d share my small script which includes the option to have images > 10kb. The script assumes you have a folder with with ima...
SharePoint Online Search Toolbox      15-Sep-2016     406  
Finally! It’s taken me a while to get this app ready as I’ve developed it in spare evening hours here and there. But it’s out, and I hope it fills a need. Get the app! Creating searc...
Just want to say that I’m not affiliated with Rencore in any way, and I write this review on my own merit – not being asked or forced to do so :-) Being an Office Server and Services MVP I know mo...
A couple of more weeks now and Ignite kicks off! I had a blast last year and I’m looking forward to see how this years event turns out as well as looking forward to hang out with new and old frie...
Back in April Microsoft released details of a new API do do bulk import of user profile properties in SharePoint Online. Say you have a field with an employee id, and you want to set this for all...
Custom hyperlink icon column using Flow      23-Aug-2016     309  
Laura Rogers (@wonderlaura) writes awesome end-user SharePoint posts, and recently wrote one which caught my eye – “Custom hyperlink icon column”. The write-up explains how you can add a custom col...
I’m building something using the pre-release of SPFx and by default when you start a project you have a SASS scss file for styles named something like MyPart.module.scss. This is all fine. Say yo...
Introducing Microsoft Forms*      23-Jun-2016     373  
June 20th, 2016 Microsoft announced the preview of Microsoft Forms, a new formative assessment and survey tool in Office 365. The caveat is that it’s targeted to Educational licenses only. This m...
Office 365 Groups comes with a real Exchange calendar, but accessing a Group calendar is a bit cumbersome via the Outlook 2016 client. You first have to expand the Groups listings in e-mail view, s...
SharePoint 2013 has been out for a good while now with SharePoint 2016 well on it’s way, and over the years there are some major flaws which has crystalized itself to me in SharePoint search - es...
Wow, that was a long post title indeed. The thing is, you cannot use OData filters on taxonomy columns in SharePoint, hence you see posts on the interwebs about using CAML instead to filter on ta...
Looking for a Visio file I discovered this one which I forgot to publish some time ago. So here’s a small diagram you can use when adding a new content source to cover the most important aspects yo...
Appending query terms to a search URL      20-May-2016     270  
I have written about appending query terms before without having them in the search box, and I’ve missed out at the best approach for this until now. Sometimes it takes years for the obvious solu...
Introducing SharePoint Framework!      04-May-2016     377  
Today Microsoft announced SharePoint Framework, the framework which will take SharePoint web development into 2016. At last, client side development has become a first class citizen of SharePoint d...
Hello, it is you we are looking for!      02-May-2016     372  
Are you an opinionated gutsy person in the Oslo, Norway area with at least some work experience who want to work with Office 365 and SharePoint? Maybe you should get in touch with Puzzlepart, ‘caus...
Search your internet site via Bing in SharePoint      28-Apr-2016     394  
I’ll credit this post to Dean Gross who did the legwork, and builds on my previous post about showing external RSS feeds in SharePoint via Search. If you want proper rendering of the results make s...
SharePoint Online’s support for sharing sites and documents with external users has been there a while now, but sharing with each individual users is quite cumbersome if you have to share with a vo...
Graham Sheeley posted a question in the Search Explained Yammer network about how to undo search schema changes at the site collection for SharePoint Online (which also applies to on-premises).The ...
When you create site columns in SharePoint they will have automatically created crawled and managed properties created for them. The naming convention for the properties is explained in detail at T...
If you create more than one managed metadata service in SharePoint and want to enter one of them via Central Admin, make sure BOTH are checked off as available services for the Central Admin web ...
Why the community is awesome!      21-Apr-2016     387  
I’m building out a custom form for a customer using AngularJS and Office UI Fabric. And I’m using the ng-officeuifabric directives to do so. In my case I needed a multi-line text field. When I sta...
I’m currently helping a government client move a SharePoint 2010 farm over to SharePoint 2013, but this post is just as valid if you move solutions over from 2013 to 2016.The backdrop for the migra...
SharePoint Query Tool v2.5 released      11-Mar-2016     449  
The most notable changes in this release are: Saving of query/connection presets Toggling of hidden constraints in the UI Show the final query including modifications Removal of 2...
Updates to Office 365 Video      03-Mar-2016     424  
Creative Commons by torbakhopperSeems the team behind Office 365 Video has had a ketchup effect lately and recently released new feature to the service, which in two weeks time have rolled out ...
If you are to query in SharePoint using search using the name of a content type, be sure to query using the managed property SPContentType and not ContentType. The latter contains extra data, and w...
Short version, if you delete a term, you cannot easily restore it.But it is possible! (solution at the end of the article)Read more »...
I know SPServices is old skool and so am I. We both go very well in hand with web services indeed, but we do enjoy the occasional re-write to new world of REST. Honestly! I have a form where bas...
Search schema mapping level explained      11-Feb-2016     528  
In SharePoint search you can map a crawled property to a managed property at basically three different levels. On-premises farm ahve SSA, site collection and site, while SPO have Tenant (subscripti...
Always fun to get to the bottom of weird issues when you didn’t write the code yourself. Take a look at the following method declaration. [OutputCache(Duration = 3600, VaryByParam = "none&qu...
A small alfanumeric sorter with numeric padding      10-Feb-2016     442  
I just got a support task where I’m pulling data from an API and need to sort the items based on a chapter like key. The data looks like this: ST.1.1 ST.1.2 ST.1.10 ST.2.20a The ...