Blog Categories

Subscribe to RSS feed


Follow Microsoft Technologies on Pinterest

Archive for the ‘SharePoint’ Category

Free Microsoft Training with the “Know it. Prove it.” Challenge

Know It. Prove It. 28 days to rock your tech skills.Microsoft Virtual Academy held the “Know it. Prove it.” 28-day challenge during the month of February 2015. The challenge was a month-long learning binge with 8 challenge tracks to choose from. Along with more than 55,000 people around the globe; I rocked the challenge during the month of February and leveled up my skills. As an overachiever, I actually completed 2 challenges and learned a lot. Even though the challenge is technically over, you can still commit to and complete these challenges, so there’s still plenty of time if you haven’t started one yet. Read the rest of this post »

What To Call Your My Site

Use “Your” instead of “My” when labeling things that are considered belonging to a user! Read the rest of this post »

On-Premises Claims Authorized SharePoint and Hybrid Apps in Azure

I recently needed to deploy a SharePoint-hosted App that would work in both SharePoint Online and On-Premises. My client had an Azure license, and we are hosting the App there. Now, how to get the On-Premises farm to work with my App? I started by reading this MSDN article on the subject.

This article had 90% of the information required, and as usual the other 10% is where the hair pulling happens. Here, I will attempt to fill in the other 10%.

  1. Patch your environment to the November 2014 CU for SharePoint Server. There are fixes in the August CU that affect this configuration and without them it will not work. Why the November CU then? Just take a look at the August install instructions and you will see why. If for some reason you cannot do the November CU the August will work, but set aside a day.
  2. Your Claims Provider class needs to implement the SupportsUserKey property, the GetClaimTypeForUserKey method and the GetUserKeyForEntity method. If you are using the Codeplex project Claims Provider Here and are using ADFS for your STS then you are fine. I had one that was upgraded from 2010 and had these methods and property missing and that left for lots of hair pulling.
    public override bool SupportsUserKey
        get { return true; }
    public override string GetClaimTypeForUserKey()
        return Microsoft.IdentityModel.Claims.ClaimTypes.Upn;
    protected override SPClaim GetUserKeyForEntity(SPClaim entity)
        if (entity.ClaimType == this.GetClaimTypeForUserKey())
            return entity;
            string token = OperationContext.Current.RequestContext.RequestMessage.ToString();
            XmlNodeList claimList = GetClaimsList(token);
            XmlNode upn = claimList.OfType<XmlNode>().Where(c => c.Attributes["AttributeNamespace"].Value.ToLower() == "" && c.Attributes["AttributeName"].Value.ToLower() == "upn").FirstOrDefault();
            return new SPClaim(Microsoft.IdentityModel.Claims.ClaimTypes.Upn, upn.InnerText, AdClaimValueType, SPOriginalIssuers.Format(SPOriginalIssuerType.TrustedProvider, SecureStoreClaimsSettings.Default.ProviderName));
  3. The User Profile Service needs to be completely set up and functioning. The OAuth procedure with Apps uses the UPA to match the string value of user ID from the token to look up and rehydrate a user in SharePoint so that it can operate on its behalf. If it can’t find the user in the UPA you will get a 401 when the app requests information.
  4. If, like me, you are working in a development environment and have deployed Apps that are now not working I would recommend deleting any App Catalogs and your App Management Service and rebuilding them as corrupted App installs were giving me some issues.
  5. The PowerShell scripts listed in the above article seemed to be a bit out of date. Steve Peschka made some updates to them on his blog, but the MSDN article does not seem to have those updates. I have combined the 4 steps listed in the article along with Steve’s updates into one script with step by step instructions that I hope will help the next guy. The scripts can be found here.
  6. Deploy your App to you App Catalog and cross all available limbs.

Sources for this post:

5 Ways the BI Experience in SharePoint is Evolving

A post on the Microsoft Office blog today entitled “Evolution of SharePoint”  grabbed my attention.  In it, Office Product Management team General Manager Julia White discussed ways the SharePoint platform is changing to fit its niche in the cloud and on premises.

As I read the article, I started thinking about how SharePoint BI has also evolved and is continuing to co-evolve with the host platform:

1) Less Excel, more Power BI

In SharePoint 2010, Excel Service and Power Pivot were big deals — not to mention the introduction of PerformancePoint Services.  By 2013, these same features had been streamlined for on-premises users, but SharePoint Online users kinda got the short end of the stick.  Enter Power BI, and the integration with Excel became even deeper with Power View and the BISM Connector providing additional functionality.   But now, Microsoft has basically unyoked Power BI from Excel with the introduction of Power BI Designer.

What exactly this means for SharePoint users is as yet unclear — especially those in the on-premises scenario.  One can expect that the Power Pivot Gallery will live on.  There are promises of being able to embed Power BI artifacts in SharePoint online pages or web apps, as well.  But what seems most likely is that a Power BI App will be made available to on-premises users of SharePoint 2016.

2) On-premises to Cloud

Progress marches on, and nowhere is that truer than in the BI realm.  From the long list of services and features provided to expand the BI experience in SharePoint 2013 on premises, we’ve seen the entire industry pivot to the cloud.  For SharePoint, this has essentially meant expansion of Office 365 and SharePoint Online in competition with the on-premises product.  And to date, it’s the cloud path has really gotten the most lavish attention from Microsoft with Power BI.  It remains to be seen how SharePoint 2016 will be positioned in that light, and whether we might see a new story for on-premises SharePoint BI take form.

3) Performance Point is dead

No, really.  I would bet one of my digits (although not a significant one, yuk yuk yuk) that PerformancePoint Services will be deprecated in SharePoint 2016.  We’ve already seen it dropped from the existing cloud offerings; if you want PPS in the cloud, you’ll need to run SharePoint on Azure VMs.  So, what takes its place?  Nothing in Power BI has the exact same feature set, but upcoming Power BI Dashboards (based on Power View) should be able to at least provide a visual analog — if not the sophisticated drilldown capability.

4) Mobile on the rise

You don’t have to be too perceptive to note the surge of importance in mobile.  SharePoint 2013 made major strides in terms of browser compatibility by moving strongly towards HTML 5 standards, thus improving the UX for mobile users. SharePoint 2016 is strongly expected to be fully HTML 5 compliant, and to improve that mobile experience even more.  Similarly on the BI side, while the initial release of Power View was not HTML 5 based, Microsoft has made good on their promise to rebuild included visualizations to be HTML5 based.  The recent release of Power BI apps for iOS devices underlines the desire for the service to be both platform and device agnostic.  Basically, we are seeing Microsoft bend these platforms to the way usage patterns are changing.  Count on both SharePoint and Power BI to continue in that vein.

5) App Oriented

Based on what we are seeing from Microsoft, it appears that we can expect SharePoint to become more app-centric — both in the Cloud and On-Premises contexts.  SharePoint 2016 is rumored to include a manifestation of an App store.  Power BI Sites is a SharePoint Online app and, as mentioned above, I would expect a version of that app might be made available for on-premises SharePoint 2016.  Add to this the embracing of mobile, and an App based approach seems to be the best choice an increasing number of scenarios.

Overall, the direction for both SharePoint and Power BI is clearly to the Cloud.  Old tools and approaches are being turned over in favor of new ones.  And there is some uncertainty resulting from that for on-premises users of SharePoint.  But Microsoft seems to be standing by the platform no matter what, so I would expect to get a better idea of the BI story for SharePoint 2016 as CTP versions start hitting the Web.




How Delve Makes your Life Easier!

For some time now Microsoft has been working on an intelligent fabric- machine learning. This algorithm is (now more than ever) becoming an Delve Img1integral part of many new platforms and products, especially office graph which powers the new Office app called “Delve”. Delve is part of the Office 365 suite and is available for all tenants with “First Release” turned on.

I blogged about Delve in its early days here & here  but since then it has evolved quite a bit. What I wanted to share with you is how Microsoft is rolling new functionality into this app so that life for an end user becomes simpler. There are many aspects when we look into a “day in the life” of an end user but one of the most important ones is organizing and email. Won’t you agree? Taking these two in consideration, let’s look at how Delve makes your everyday life easier!

But before we look into the new enhancements, let’s take a small walk down the memory lane and see what is Delve. Office Delve brings most relevant content to you. This is based on what you’re working on and what is trending around you (your connections, groups etc.). Helps you discover new connection, be it People, documents, or new ideas. All this is done by Delve constantly learning your work habits/styles and creating a globe of information in and around you. Office Graph incorporated signals across Office 365 and content primarily from OneDrive for Business, SharePoint Online team sites and the new Office 365 Video portal.

Now let’s explore the latest enhancements that has been keeping the Delve team pretty busy.


This feature helps you organize various content and make it readily accessible and share friendly. Think of this as the same exercise you are Image 001used to, of applying sticky on a board to gather all relevant ideas and suggestions. This feature takes this traditional approach, digital.

Image 002Everyone in your organization can view and contribute to an existing board or create a board—but they can only see and open documents that they have permission to access.  From within Delve, you can search for a board, follow it to stay informed and discover other boards—all without having to know or remember where individual pieces of content live. Watch this youtube video to get a better idea.

Image 003


Boards does not allow you to embed external pages yet; so in essence no public boards!
Currently you cannot add context to the content on a public board. It’s simply pinning a document without any comment or context around it. (Sounds like a yammer integration in the play here)

Image 004


I bet you would not disagree with me when I say email is single handedly the most used/abused application today. People use it to share ideas, circulate announcements, send attachments etc. This is a the latest in the list of additions to Delve. On the Delve home page, attachments found in email show up in the “Home” view. The attachments are presented in cards that provide some context including information about who sent the message and some text from the message body. If a message contains multiple attachments, each attachment is presented in a separate card.

It won’t show you attachments sent by you.
Attachments will only show in the two week time frame. Delve will show items that are of interest to you based on insights it has gathered and analyzed in the Office Graph database. The same kind of signal-driven rationale is used to surface documents stored in SharePoint and OneDrive for Business libraries.
You obviously can’t delete items from Delve – that’s due to the reason that Delve is a machine learning algorithm based on search.

Overall great additions to the Delve family. I’m certainly looking forward to the next one – Yammer integration.



Image source: Microsoft Office blog

The (updated) SharePoint app model development approach

I was recently invited to attend a session at the Microsoft campus in Redmond titled “Transitioning SharePoint Full Trust Code to Application Model Solutions Airlift”.  So, aside from the long title, what exactly was this session going to provide?  I did get a chance to see the preliminary agenda so I did have some idea what the main topics were, but I still wasn’t exactly clear on what I was going to get out of this.  Nevertheless, I was intrigued and knew from the agenda that there were some great topics being discussed so I made my travel arrangements and headed to Redmond.  Little did I know at that time that I was about to attend a session that really put things into perspective with the current state of SharePoint and change how I think about approaching both on-prem and SharePoint Online projects going forward.  In this post, I will go over the key topics that I took away from these sessions and the recommended guidance to address these topics.

airlift intro

At a high level, the primary goal was to bring partners and clients up to speed on converting SharePoint Full Trust Code (FTC) to app model.  Topics ranged from initial deployment, to maintenance, upgrades, migrations, etc., the whole gambit, essentially.  I have been following the Office 365 Developer Patterns and Practices Team (PnP) for some time so I did have some idea of this before the event, but after sitting through the sessions, going through the labs, and talking with others at the event, it really put things into perspective and made me realize the paradigm shift the platform started with SharePoint 2013 and how important it is to get on board now, even if you’re an on-prem customer.

App model != apps/app parts/app webs

When SharePoint 2013 was making its debut, SharePoint apps were all the rage… many a session was attended discussing SharePoint apps, app webs, host webs, etc.  What seems to have gotten lost in a lot of that shuffle was the focus on the app model and not just SharePoint apps.  It seems that Microsoft is aware of this and the PnP team is trying to help guide everyone to focus on app model (client side code) and not just SharePoint apps.  While apps have their place, they are not the star in my mind and too much focus has been around apps in general since SharePoint 2013 was released.  Focusing on the app model in general (not just apps!) is key and, for those more involve with ECM and Intranet style projects, it’s necessary since apps don’t always have the best fit with those types of projects.

Read the rest of this post »

Universal, Touch-Friendly Office Released for Windows 10

Windows 10 maybe not be coming until later this year, but Microsoft is busy at work building application for it, including probably the most important consumer application – Microsoft Office.

Yesterday Microsoft released early preview builds of Universal (meaning that it will run on any flavor of Windows 10 – desktop or mobile) Office applications for Windows 10.

Excel_UI_900x530Applications could be downloaded now from Windows 10 Store:
Word Preview
- Excel Preview
- PowerPoint Preview

It took Microsoft a while to completely revamp Office application to make them touch-friendly. When Windows 8 was released in 2012 it provided a full touch support and was optimized to run on touch screen computers. The Office 2013 however wasn’t exactly touch friendly. Sure, it’s possible to use finger when working with Windows desktop UI, but this experience is not exactly enjoyable.

Microsoft Surface RT which was a first Microsoft’s foray into computer manufacturing bundled a free copy of Office 2013 which was rebuilt to operate on ARM CPU, but … still didn’t support Modern UI. I guess desktop Office was the only reason for adding desktop mode to Windows RT.

In 2014 Microsoft finally released touch-friendly Office for iPad and then later for iPhone and Android. And now a full-featured Office with Modern UI is coming to Windows 10 as a first class citizen.

Much Awaited OneDrive for Business comes to Mac and iOS

This announcement should be music to the ears, for all the Mac and iOS diehards using Microsoft apps. Earlier I had blogged about an interim solution for these devices, you can read it in my post here. Last week, Microsoft announced new ways that you can access and manage your OneDrive for Business (ODFB) files from your Mac and iOS devices. The good news is that ODFB works like OneDrive (Personal): You get a virtual drive in the Finder so that you and your apps can access ODFB files normally. That means that Office for Mac can now access files in your corporate ODFB account (which should have always worked). New capabilities in how you view, manage, and share your photos and it now allows you to connect to one or more ODFB accounts.

Previously Microsoft had shipped two separate apps – one for your personal files and one for business files – now you can do this all within the one app. For a business user you can access all your files plus all the files that have been shared with you. You can even access your most recent files plus recover accidentally deleted files from the Recycle Bin. You can download the iOS app from the app store, and the Mac sync client preview from the Microsoft Download Center. You can also take a first look at the new Mac sync client on Office Mechanics. I share below some screenshots from my iPhone, that goes to show how easy it is to add ODFB to your existing app. Read the rest of this post »

SharePoint 2013 Search: External Content Relevancy Boosting

Where’s my External Content?

The first time you bring in external content into your search index, whether that be from BCS or Custom Connector, your search ranking and relevance for that content will most likely be buried under all of your SharePoint content. This is quite common. Don’t worry however, we will go over some of your options to bring that content to the top, also known as relevancy boosting.

Query Rules for the Admins

It has been said and it has been done a lot. Query Rules have become somewhat of a staple in SharePoint 2013. I won’t cover it in detail because there’s a huge amount of resources out there (check out Chris Hines’ post here), however I will leave a small tidbit below.

Often when you are pulling multiple entities from BCS, you end up with a single content source with quite a few different entities that are of different types of content. Good news is that you can split them out.

Accessing Individual BCS Entities

Look for a crawled property called EntityName (might be two of them), and map them to a managed property. For our sake, we will call it MPEntityName. You will want this managed property to be queryable.

Then you can query your BCS entity by running a simple MPEntityName:NameOfEntity.

Read the rest of this post »

Update: SharePoint Server 2015 now SharePoint Server 2016

SharePoint-logoIn March last year, we first heard Microsoft’s commitment to the next server version of SharePoint, dubbed SharePoint 2015. It’s been more than a few months since that announcement, and we have yet to hear anything further. Until today!

Julia White, General Manager of the Office Product Team (SharePoint is part of Office), released a very detailed blog today detailing what’s next for SharePoint – online and on-premises. There are some really big announcements in this blog, I encourage you to read through it. Here are a few of my key takeaways:

1. Microsoft is committed to on-premises

A big amount of text in this post was dedicated to reassuring on-premises customers that there will in fact be a new server release. Because of the amount of time since SPC in March, customers have become very concerned with the lack of information, and rightly so! A number of our clients at Perficient are in this position, they have made large commitments to SharePoint on-premises and they are not yet ready (or can’t yet) move to the cloud. In this announcement, Microsoft stepped up in a big way to reassure these customers.

2. Microsoft is committed to Experiences

As we’ve seen the Microsoft Cloud continue to grow, specifically in Office 365 with Office Delve, Office Graph, and the NextGen Portals, we are starting to see the new paradigm for Microsoft – Experiences. From Search to BI to Social to Groups – the new focus in the cloud will be experiences. Read the rest of this post »