blog.atwork.at

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

How to create or renew Service Principal Names in Azure Active Directory

When an automated task or an app needs to access data from Office 365, you need to create an app in the tenant’s Azure Active Directory (AAD). For having full control, e.g. for deleting objects in AAD, a so called Service Principal Name (SPN) can be used. That is similar to a Global Admin in Office 365, but just for apps and usually with a predefined expiration date. Which is good. Or?

Impressions of Microsoft Tech Summit Paris 2018

After we returned from MVP Summit, we were proud to be part of Microsoft Tech Summit from March 14th to 15th in Paris. The cost-free roadshow took place in Paris Expo Porte de Versailles and delivered two days of news and How-To’s of the Microsoft cloud services. See some impressions here.

Join us at SharePoint Conference North America!

Celebrate the Return of the SharePoint Community to Las Vegas! After four years, SharePoint Conference North America is back from May 21st to 23rd 2018 at MGM Grand in fabulous Las Vegas. Meet the Microsoft SharePoint team, community members and peers from around the world there. We from atwork are happy to be there as well to meet and contribute to SPC 2018!

Impressions of Microsoft Tech Summit Frankfurt 2018

This week, the Microsoft Tech Summit roadshow took place in Frankfurt, Germany. On two days, from February 21-22, 2018, the cost-free roadshow informed about topics from Azure to Microsoft 365. We were happy to be part of the Tech Summit. See some impressions here!

Tips for PowerApps-Using SharePoint Customize forms with Bing Maps visualization

PowerApps are very powerful and simple to use.Through the integration in SharePoint Online lists, we now can create our custom forms within a SharePoint site and add additional features as calculations, modifications and even visualizations. See here, how to integrate a map for showing a location instantly directly in SharePoint without any coding!

Joining the Microsoft Graph Community Calls

Microsoft Graph is the unified endpoint to programmatically access resources and services in Office 365. To inform the developer community with the latest news, the Microsoft Graph team organizes a monthly Microsoft Graph API community call. We, Toni and I, were happy to contribute a use case at the last call showing a scenario of an Office 365 Group orchestration workflow with PowerApps, SharePoint, Azure Functions and Microsoft Graph. You can watch the recorded session here.

Download the free Azure Serverless Computing Cookbook

Serverless Computing is popular. With Microsoft Azure, IT people can concentrate on their tasks and apps without taking care of managing any server infrastructure. One of the key Platform-as-a-Service (PaaS) components from Microsoft is the new, extensive Azure Functions service. Learn how to use Azure Functions with the cost-free Azure Serverless Computing Cookbook!

How to restrict access and to connect to a single SQL Azure database only

As of today, many organizations use various Microsoft Azure services. SQL Azure databases are popular among them. Often, IT Administrators want to allow departments or vendors full access to just one specific SQL Azure database and to restrict their access to other resources. See here how this works.

CU at SharePoint Saturday Bremen 2018

We are looking forward to see you at the SharePoint, Office 365 and Azure community event next week on January 20, at the first SharePoint Saturday North Germany 2018, in the city of Bremen. There will be a lot of interesting sessions and a great speaker’s lineup. CU there!

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!