Author Archives: Dan

Hacking DocX files to fix Quick Parts in Word Online

Posted on December 18, 2020 by Dan

Microsoft Word documents can have Quick Parts connected to SharePoint fields, so that the value of the field is displayed inside the document. But Word Online (still) does not fully support this. It will display Quick Parts with a a … Continue reading →

Posted in Development, Tips | Tagged , , , , , , | Leave a comment

Migrating data from Access to SQL Server

Posted on April 30, 2020 by Dan

Suppose that you have a simple Microsoft Access database that you need to migrate to another database such as MS SQL Server. You model the tables and relationships in the new database, and now you need to export the actual … Continue reading →

Posted in Development, Tutorials | Tagged , , , , , , | 1 Comment

Applying SharePoint Retention Labels Programmatically

Posted on February 10, 2020 by Dan

So you’ve created and published Retention Labels in Office 365 and now you want to apply labels by CSOM code. It’s not very well documented. The following (crude) code should help you get started applying labels to both individual items … Continue reading →

Posted in Development | Tagged , , , , , , , , , | 4 Comments

If Snipping Tool freezes and blocks your screen…

Posted on January 17, 2020 by Dan

Note: Be sure to read the comments for more help! Today when I used the Snipping Tool in Windows 10 it stopped working. I could select an area over and over again, but it never closed after that as it … Continue reading →

Posted in Tips | Tagged , , | 56 Comments

How to create searchable user profile properties in SharePoint Online

Posted on November 21, 2019 by Dan

In this post I will go through the steps of creating a custom user profile attribute that is searchable and shows on the user profile in Delve. It’s not very hard but involves quite a few steps to keep track … Continue reading →

Posted in Tutorials | Tagged , , , , , , , , | 1 Comment

Popup opens as new browser window in Edge and Internet Explorer

Posted on November 20, 2019 by Dan

Problem: Opening a popup with JavaScript in Edge or Internet Explorer results in a new browser window instead of a popup window. For example:

Communication between the new window and originating site is not possible either, since both popup (above) … Continue reading →

Posted in Development | Tagged , , , , , | Leave a comment

How to quickly get the Group ID for an Office 365 Group

Posted on November 19, 2019 by Dan

Microsoft Graph typically requires us to use the Group ID when working with O365 groups and modern sites. But Group ID can be tricky to find since it is rarely displayed. Here are some ways I found to quickly get … Continue reading →

Posted in Tips | Tagged , , , , | 2 Comments

Excluding external users from search results in SharePoint Online

Posted on January 31, 2019 by Dan

Search in SharePoint Online returns both internal and external users by default. This may  not be desirable. Here’s how to exclude external users from the search results. External users have account names containing #ext# which makes them easy to filter … Continue reading →

Posted in Tips | Tagged , | 1 Comment

Try this if sound in Windows stops working

Posted on August 19, 2018 by Dan

Several of my computers have had problems with sound suddenly not working. Typically this seems to happens when switching context, such as going from plugged in to battery, but sometimes it seems random. At work we use Skype for Business. … Continue reading →

Posted in Tips | Tagged , , , , , , | Leave a comment

Enable Mometum on an Alps Glidepoint Touchpad

Posted on August 15, 2018 by Dan

My old computer has a touchpad from Synaptics with a feature called “Momentum”. (I’ve also seen this called “Inertia” och “Inertial Scrolling”.) It causes the mouse pointer move a little bit before stopping after you’ve released your finger, as if … Continue reading →

Posted in Tips | Tagged , , , , | 1 Comment