Developer

Yesterday I documented in “Get data from SharePoint as HTML table with Azure Logic Apps” how data is retrieved from SharePoint Online with an Azure Logic app. To dig a little deeper into working with SharePoint list data, here are a few more helpful tips. Query for empty fields (eq null) To find items in an SPO list that have NO value in an Azure Logic App SharePoint Get items action, we can use “<field> eq null” (and not eq ‘’ ). Simple as that, but good to remember. So in our sample, the ODATA filter query is as here: SubscriptionEndDate lt addDays(utcNow(),-30) and Invoice eq null ...

Sometimes it´s good to get data from a data source as a table and as quickly as possible in an automated way. While this can be done with multiple ways, here´s a quick solution if you want to get the items from a custom list in SharePoint Online sent as a HTML table in an email with Azure Logic Apps (or Power Automate). In this sample, we assume we have a custom list in a SharePoint Online site that includes some hundred lines of data with license requests and billing information. We want to get specific items that will expire in near future where there´s no invoice set. We will do this with a filtered query. The result shall be formatted as HTML table and sent to an email address. Azure Logic Apps and Power Automate (Flow) is perfect for such a quick task. ...

Cloud architecture diagrams need to look good. Get the new Azure architecture icons v3 here! Open docs.microsoft.com/en-us/azure/architecture/icons, agree to the terms and download the file Azure_Public_Service_Icons_V3.zip. Check out the pretty new Azure icons for your cloud diagrams!

Today´s a quick tip for users working with Azure Logic Apps. This article shows how you can continue to work in a flow if an action has failed. This sample accesses an Excel file from a Microsoft teams SharePoint site and searches for a key. If the key was not found, the flow shall continue and deliver a useful error code with a message. See how this works here. The scenario The following Azure Logic App is triggered by an HTTP request and gets some data from another system. The purpose is to lookup a campaign and some data from an Excel file that is stored in a SharePoint site of a Microsoft 365 Group (a team site) and to continue to work with that data. Furthermore, the Logic App generate a voucher and sends emails. But that´s another story. Here we concentrate on the failure handling. ...

Deutsche Version Alle Jahre wieder … Gegen Jahresende gibt es immer wieder die Anforderung, die Kostensätze für Ressourcen für das Folgejahr einzutragen. Hier stelle ich ein Makro bereit, der das Ganze mit VBA vereinfacht. Mit dem Code können Sie Kostensätze für jeweils eine Kostensatztabelle ändern. Für Änderungen in einem einfachen Projekt mit lokalen Ressourcen öffen Sie dieses Projekt für Enterprise Ressourcen aus Project Online oder Project Server öffnen Sie die Unternehmensressourcen im Client zur Bearbeitung von Ressourcen in einem gemeinsamen Ressourcenpool öffnen Sie den gemeinsamen Ressourcenpool Wenden Sie eine Ressourcenansicht, z.B. Ressource:Tabelle. Blenden Sie Kostenspalten ein, die noch nicht in Verwendung sind (Kosten1 – Kosten 10, ….). Ich verwende in diesem Code vorhandene Kostenfelder, um Probleme mit Einheitsbezeichnungen und Währungskennzeichen beim Import zu vermeiden. Wenn Sie nur den Standardsatz ergänzen möchten, ist ein Kostenfeld ausreichend. Für Überstundensatz oder Kosten pro Einsatz benötigen Sie bei Bedarf ebenfalls je ein Kostenfeld. Tragen Sie in diese Felder die neuen Kostensätze ein. ...

I recently ran into this problem: I had to install the Azure Az PowerShell module from the PowerShell Gallery on a new computer. Interestingly the installation with Install-Module -Name Az failed with the error message “WARNING: Source Location ‘https://www.powershellgallery.com/api/v2/package/Az.Accounts/1.9.3' is not valid.”. See my solution here. The Azure Az PowerShell module provides access to the world of Azure. See more at Introducing the new Azure PowerShell Az module. So, if you run into this issue when executing ...

Recently, I stumbled across a strange behavior when running self-developed SPFx webparts in various browsers. When the SPO app was deployed, it worked well with Single-Sign-On, but in some browsers, the webpart was blocked. Instead, a grey box saying “login.microsoftonline.com refused to connect.” was displayed. I experienced that behavior in Chrome, and Edge, while FireFox, Safarai and Opera showed the webpart. Also, there was a different experience when working in the normal mode, or in the In-Private mode. If that happens to you, check out the solution here. ...

Global Microsoft 365 Developer Bootcamp is back! This year the event will take place virtually from more than 100 cities worldwide. Join us at our Microsoft 365 Developer Bootcamp - Austria on November, 13th, 2020! The Global Microsoft 365 Developer Bootcamp is here for the 4th year straight. Check out Microsoft 365 Events Bootcamps and join us at our bootcamp in Austria using Microsoft Teams. Register now! We are excited to kick off the virtual Global Microsoft 365 Developer Bootcamp Austria 2020! The Microsoft MVPs and community leaders invite YOU to attend this bootcamp to learn the latest on Microsoft 365 platform such as Microsoft Graph, SPFx, Microsoft Teams, the Power Platform, Bots, AI and more. Learn how to apply the latest technologies to your future projects. ...

To ensure the security of your Microsoft 365 client, we recommend implementing an appropriate governance and security strategy. An effective measure is to determine the current administrators and their permissions. In this article, we want to identify administrators with permanent roles and administrators who can use roles with Privileged Identity Management (PIM). PIM provides just-in-time privileged access to Azure AD and Azure resources. See how to find all Administrators, including PIM, here. ...

Deutsche Version Nachdem ich jahrelang Zeit verbraucht habe, mit rechten Mausklicks Module für BackUp-Zwecke zu exportieren und neue oder geänderte Module zu importieren, habe ich vor einiger Zeit Code geschrieben, womit ich das automatisiere. Ich habe den Code jetzt etwas abgewandelt, da UserForms nicht als Plaintext bereitgestellt werden können. Code bietet die Auswahlmöglichkeit. Alle Module eines ausgewählten Projekts in einen Ordner zu exportieren Alle Module eines ausgewählten Projekts in einen Unterordner zu exportieren und alle Module aus dem darüberliegenden Ordner zu importieren. Eventuell bereits vorhandene Module werden bei Bedarf zuvor entfernt ...