blog.atwork.at

news and know-how about microsoft, technology, cloud and more.

Groups Governance Toolkit Part 1-Overview

IT-Governance is an important topic, especially in large organizations. At Microsoft Ignite conference, we showed the "Groups Governance Toolkit" with a bunch of useful tools to regulate and monitor Office 365 groups and Microsoft Teams. Here, we will show the step-by-step guidance how to implement that toolkit with Microsoft 365 and Microsoft Azure. Let's start with an overview what topics we cover in this article series.

Use SharePoint view column formatting for displaying pictures and conditional formatting

Today I want to share just a quick tip for custom formatting views in SharePoint lists since I need them from time to time. My goal was to show a picture of a text field with an URL and to use conditional formatting with a traffic light system to visualize the sentiment of tweets that are written to a SharePoint Online custom list from a Flow. See the formatting options here.

Download Microsoft BUILD 2018 conference sessions

Microsoft BUILD conference 2018 took place two weeks ago in Seattle with over 350 sessions covering Azure, Visual Studios, Microsoft 365, and more. Although you can watch the sessions online at mybuild.microsoft.com/sessions, sometimes it’s helpful to have them downloaded. You can do so with the following PowerShell script.

Looking for Microsoft SQL Server Configuration Manager?

In former versions of Microsoft SQL Server, the SQL Server Configuration Manager was an extra app for configuring the SQL Server services. Since this is gone since some versions, we often get the question where to find the configuration tool nowadays with the modern versions of SQL Server…

Use Visual Studio Code and the Code Runner extension

Visual Studio Code (currently, Version 1.22 is available) is a very cool developer tool providing a modern and fast code editor with a bunch of extensions. With extensions as Code-Runner, it’s easy to run a code file or active text directly from the VS Code text editor. Check out this quick description how to configure and use Code Runner.

How to access files stored in OneDrive or in a SharePoint site with Microsoft Graph and the Excel API

The Microsoft Graph API is the new unified endpoint for developers accessing data from an Office 365 tenant. Amongst many other features, you can work with OneDrive and SharePoint files with the Graph REST API. Additionally, you can directly work with Excel files through the Graph Excel API. Since all samples I found just use the personal OneDrive for Business (OFB) file storage, I wanted to document how to access files that are stored in a SharePoint Online site (SPO) as well. So, here we go!