LazyAdmin

Tips from an other Admin

Copy Sharepoint list items to another list with Powershell and PnP

You can easily copy Sharepoint list items to another list with Powershell and PnP. First connect to the source Sharepoint site. You can use one of mine connector scripts for it here at Technet. Or connect to Sharepoint with:

Get the list items Now we need to retrieve the list items that we want to copy:

Copy the items…

Continue Reading →

Remove thunderfly bug from your screen

Working outside in the porch today I got myself a life bug in my laptop screen. I heard about it before, but never had one until now. They are called thunder flies and are little nasty bastards that crawl in your lcd screen. They are a few ways to get rid of them, most important, don’t crush him until he…

Continue Reading →

Mouse freezes when previewing an Excel file in Outlook 2016

Does your Outlook freezes when previewing an Excel file in Outlook 2016? Well it’s easy to fix, there is no need to disable Excel add-ins or running Outlook in safe mode. Just disable scroll inactive windows in the settings menu. To fix the issue, goto: Settings > Mouse  (or start and type “mouse settings”) Disable  Scroll inactive windows when I hover…

Continue Reading →

Share Sharepoint files and folders from a Office365 Group

Sharing files in Sharepoint, that shouldn’t be that hard right? Well if you are using Office 365 Groups you might have noticed that you are not able the share a file or folder from the Groups Sharepoint site to external users. When you try to use the Invite People option you will get the following error: Your organization policies do…

Continue Reading →

Deploy ODBC connection

You can deploy an ODBC connection in 2 ways, with a GPO or with a reg file which can be deployed with also an GPO or deployment software. The GPO Way Create a new GPO and navigate to Computer or User Configurator > Preferences > Control Panel Settings > Data Sources. Create here a new Data Source and fill in…

Continue Reading →