Office/Office 365

Embedded Power BI reports with ASP.NET Core

Last year I had some projects where I had to embed Power BI reports to ASP.NET Core applications. There were easy cases that solved practically with copy-paste but I also had more complex situation where server-side code was needed because application uses custom authentication instead of Azure AD. This blog post covers both scenarios for embedding Power BI reportis to ASP.NET Core applications.

Using CSOM from Azure Functions

I got back to active SharePoint development some months ago and first thing to do was to port bunch of workflows from in-prem SharePoint to cloud. Where I live we don’t usually have any simple workflows. Most of them need some backing code due to custom logic. So, my only option was to go with Microsoft Flow or Azure Logic Apps and Azure Functions. Here’s the project with one dummy function to get started.

Automatically describing and tagging pictures on SharePoint using Azure Cognitive Services

Azure Cognitive Services has wider audience than cool young guys developing very cool mobile apps. These services can be used in very different use cases. This blog post shows how to use Azure Cognitive Services to automatically describe and tag photos added to Office 365 SharePoint picture library.

Introduction to Microsoft To-Do

Microsoft launched yesterday a new cloud service called Microsoft To-Do. The aim of new service is to provide users with simple and familiar looking tool to plan a day. The new service comes with nice looking web interface and there are also apps available for most popular platforms, including Windows and Windows Phone. (more…)

Triggering Azure Functions from Office 365 SharePoint using Microsoft Flow

We cannot use classic SharePoint workflows on Office 365 but using Microsoft Flow we can create new era flow applications that are triggered by events that happen in different sources. This blog post shows how to use Microsoft Flow and Azure Functions to send out e-mail when new meeting is added to SharePoint list. The idea of this blog post is to illustrate how to create the flow where custom code takes over in some point.

Using OneNote API to count degustated beers

I am heavy OneNote user as OneNote is easybut still powerful application to keep important information and organize it the way I like. Not to mention powerful cloud back-end that makes my OneNote notebooks available for me on desktop, tablet and mobile phone. In this posting I will show you some code I use to update the number of degustated beers in beer diary.

OneNote as personal travel guide: Using OneNote on trip

We are ready to go and use OneNote as our main source of information when travelling around. Before going we have to make sure we have our travel guide available in our pockets. We need also some good plan how to use it and how to update it if needed. This posting tells you how to travel with OneNote effectively.

SharePoint 2013 Autohosted apps

MSDN subscribers can activate Office 365 developers benefit that gives them free Office 365 development instance for year. If you have this subscription then you can use your local Visual Studio to develop new style applications and then run and test them on Office 365 environment. In this posting I will introduce you hybrid development of Office 365 SharePoint applications.

OneNote as personal travel guide: Planning

In previous post we gathered and organized information about places we want to visit and we have now pretty good overview about what is where, how we can move around and what delicious things we want to try. It’s time now to make guiding plan for our trip, work out informative pages and share our travel guide with our friends.

OneNote as personal travel guide: Discovering places

When you know where you want to travel you can start with gathering information. This is time consuming process and I start with this as early as possible. This step in process produces a lot of information and you need some good way how to organize it so you don’t get lost. It’s easy for short trip to somewhere but when you plan to move around about week the situation is totally different. Let’s see how OneNote can help you out here.

OneNote as personal travel guide: Introduction

When going to travel then well done home work is must be – otherwise you spend a lot of valuable time on trip to find information and do time consuming planning. Poor planning means also way bigger expenses on mobile data traffic and most of your trip will be mess. I had problems like these when I was beginner traveller. For now I have elegant solution to this problem and here is how I use OneNote.

Reading OpenDocument spreadsheets using C#

Excel with its file formats is not the only spreadsheet application that is widely used. There are also users on Linux and Macs and often they are using OpenOffice and other open-source office packages that use ODF instead of OpenXML. In this post I will show you how to read Open Document spreadsheet in C#.

Adding multiple data importers support to web applications

I’m building web application for customer and there is requirement that users must be able to import data in different formats. Today we will support XLSX and ODF as import formats and some other formats are waiting. I wanted to be able to add new importers on the fly so I don’t have to deploy web application again when I add new importer or change some existing one. In this posting I will show you how to build generic importers support to your web application.

Using ExcelPackage to create Excel sheets on server

In one of my community projects I needed to output some listings as Excel file. As installing Excel to server is non-sense that I was easily able to avoid I found simple solution for Excel 2007 files – open-source project called ExcelPackage. In this posting I will show you hot to create simple event attendees report in Excel 2007 format using ExcelPackage.