App

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. ...

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. ...

Storing credentials, SSL certificates, connection strings and other secrets in Azure Key Vault is recommended for every software project in the (Azure) cloud. This is easy to do when using certificates, such as for a website hosted in Azure App Services. Learn how to configure a SSL certificate once and then have it automatically updated when you update it in the Key Vault, called automatic rotation. See a step-by-step description here. ...

Using an Azure Logic app is often a quick fix for small computing tasks. So my scenario is as follows: I want to use a form on a website to offer text fields and file upload. The submit button is intended to send the data to a Logic App. The Logic App receives the data and writes it to a SharePoint Online list and sends a notification if necessary. See the implementation here. ...

The Governance Toolkit 365 (GT365) is a software-as-a-service solution that offers insights into a Microsoft 365 tenant and is part of the Microsoft Applied Cloud Stories initiative (#AppliedCloudStories). GT365 reads cloud data, stores the data and offers IT administrators monitoring and reporting functions to get a tenant overview at a glance, for example as a newsletter, in Power BI, as API or as a Bot that can be integrated in Microsoft Teams. The GT365 workloads are fully processed in Microsoft Azure using serverless computing. Here are some architectural insights on how to avoid throttling and how to use fan-out functions. ## The application ...

Multi Factor Authentication (MFA) reduces the risk of compromise by 99.9%. Therefore, it is a good idea to use it for every user in an organization. This article provides step-by-step instructions for setting up MFA with the Microsoft Authenticator app on a smartphone. If you have MFA enabled and you switch to a new device, follow the steps here. My colleague Martina Grom (@magrom) points out the importance of using MFA at every security session, as here at Modern Workplace Conference Paris 2019 last December. Thanks for your support to write this article, Martina. ...

Delegate365 is using the Microsoft 365 and Azure standards to sign-in and to communicate with the Microsoft APIs. Here´s the best practice how to secure your environment for using Delegate365. 1. Secure your Microsoft 365 tenant Microsoft 365 provides a bunch of features to harden a tenant and to raise the Secure Score. Every administrator should start improving the security with setting Conditional Access, MFA, and policies. You can learn more about Microsoft Secure Score here. This demo tenant screenshot above is not properly configured and should definitely be secured. If your need support, we got you covered, see our Enterprise Security & Compliance Workshop offering. ...

We are excited to kick off the Global Microsoft 365 Developer Bootcamp in Vienna, Austria, on November 27, 2019! The Microsoft MVPs and community leaders invite YOU to attend this cost free developer bootcamp to learn the latest on Microsoft 365 platform such as Microsoft Graph, SharePoint Framework, Microsoft Teams, Bots, Actionable Messages and more. Learn how to apply the latest technologies to your future projects! The Global Microsoft 365 Developer Bootcamp takes place at the Microsoft Office in Vienna: ...

Effective October 1, 2019, the new licensing model for Microsoft PowerApps and Flow will apply. To clarify which functions are included where, we have compiled an overview at a glance here. To make it short, here are the key data: Every user who uses PowerApps or Flow requires a license. PowerApps can be tested for free for 30 days. PowerApps licenses will continue to include Microsoft Flow capabilities. PowerApps and Flow licenses are included in the Office 365 Academic (A), Enterprise (E) and F1 plans - as before. See the complete list at PowerApps licensing overview. So, to create and use a PowerApp or a Flow, the included license is often sufficient. ...

A very quick tip today: When using an Azure Logic App in combination with an Azure SQL Database, filtering rows can be done like here. As example: A T-SQL query as this one… SELECT - FROM [dbo].[Customers] WHERE [StorageDataSentDate] IS NULL ORDER BY [Id] …will be formulated as filter expression with an OData query as here. The definition for the Get_rows_(V2) action looks similar as here: … "Get_rows_(V2)": { "inputs": { "host": {"connection": {"name": "@parameters('$connections')['sql']['connectionId']"} }, "method": "get", "path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('[someserver].database.windows.net'))}, @{encodeURIComponent(encodeURIComponent('governancetoolkit365'))}/tables/ @{encodeURIComponent(encodeURIComponent('[dbo].[Customers]'))}/items", "queries": {"$filter": "(StorageDataSentDate eq null)", $orderby": "Id"} }, "runAfter": {"Initialize_variable": ["Succeeded"]}, "runtimeConfiguration": { "paginationPolicy": {"minimumItemCount": 5} }, "type": "ApiConnection" }, … Depending on the data size, remember to configure pagination. ...