Delegate365 - Secure and setup your tenant

Delegate365 - Secure and setup your tenant

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

October 11, 2019 · 5 min · Toni Pohl
Join us at the Global Microsoft 365 Developer Bootcamp in Vienna!

Join us at the Global Microsoft 365 Developer Bootcamp in Vienna!

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

October 5, 2019 · 1 min · Toni Pohl
Overview of the new pricing models for Microsoft PowerApps and Flow

Overview of the new pricing models for Microsoft PowerApps and Flow

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

September 27, 2019 · 3 min · Toni Pohl

Project Makros mit Datumsfeldern in mehrsprachiger Umgebung - Macros with Date Fields in Multilanguage Environment

Deutsche Version Im Artikel Project: Formeln mit Datumsfeldern in mehrsprachiger Umgebung / Formulas with Date Fields in Multilanguage Environment habe ich beschrieben, wie man Fehler in Formeln mit potentiell leeren Datumsfeldern in einer mehrsprachigen Umgebung vermeidet. Potentiell leere Datumsfelder wie Geplantes Ende, Datum1, … werden abhängig von der Sprachversion als NV, NA, … dargestellt. Wenn in Formeln auf diesen Textwerte einer Sprache geprüft wird, führt das zu Fehlern bei Verwendung einer anderen Sprachversion von Project. Das gleiche gilt auch, wenn diese Felder mit VBA ausgewertet werden. In Code sehen Sie drei Beispielmakros: ...

September 27, 2019 · 3 min · Barbara Henhapl
Use the PowerApps PowerShell modules to automate tasks with the Microsoft Power Platform

Use the PowerApps PowerShell modules to automate tasks with the Microsoft Power Platform

PowerShell helps automate processes, especially in the Microsoft 365 world. That´s true for the Microsoft Power Platform as well. See how to access PowerApps and Flow with PowerShell here. So, here´s a very quick introduction for using PowerShell with PowerApps and Flow. Find the full documentation at PowerApps cmdlets for administrators. Install the PowerShell modules Install the PowerApps (preview) module from the PowerShell Gallery once with the following PowerShell statements as Administrator on your machine: ...

September 22, 2019 · 2 min · Martina Grom
Azure Logic Apps Toolbox 1-Use the OData Filter for Azure SQL Databases

Azure Logic Apps Toolbox 1-Use the OData Filter for Azure SQL Databases

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

September 19, 2019 · 1 min · Toni Pohl
How to copy table data between Azure SQL Databases

How to copy table data between Azure SQL Databases

Working with Azure SQL Databases is handy. Just, how can I copy data from one Azure SQL database to another database? See the best practice here. I had such a use case. I needed to copy a table (all rows) from a source database to a destination database with SQL Management Studio. The table did not have much data, but extensive data with varchar(MAX) fields containing HTML and Base64 encoded images. So, a copy in the edit mode via clipboard did not work. ...

September 18, 2019 · 2 min · Toni Pohl
atwork sucht engagierte Software DeveloperInnen!

atwork sucht engagierte Software DeveloperInnen!

atwork ist Anbieter von modernen Business-to-Business IT-Lösungen auf der Basis von Webtechnologien. Wir sind ein agiles Team und entwickeln Lösungen in unserem Büro in Wien Döbling. Wir suchen Dich zur Unterstützung unserer Lösungs- und Produktentwicklung und bieten flexible Arbeitszeiten und ein spannendes Umfeld! Dein Job ist die Entwicklung von Apps und Services mit Microsoft .NET und aktuellen Webtechnologien. Abhängig von Deiner Projekterfahrung und nach Einarbeitung in unsere Lösungen trägst du Verantwortung für Projekte und übernimmst Aufgaben in der Spezifikation, Design und Implementierung. Du arbeitest gemeinsam mit unseren Kollegen und Kunden aktiv an der Weiterentwicklung der Lösungen. ...

September 9, 2019 · 2 min · Toni Pohl

Project Kalenderausnahmen exportieren Export Calendar Exceptions

Deutsch Häufig wird in Foren die Frage gestellt, wie Ausnahmen (Abwesenheiten oder abweichende Arbeitszeiten) exportiert werden können. Hier ist ein Makro bereitgestellt, das alle Kalenderausnahemn in eine Datei exportiert. Dabei werden alle Ausnahmen aller Projektkalender und aller Ressourcenkalender während der Projektlaufzeit berücksichtigt. Mit dem Setzen einer Konstanten zu beginn, können Sie definieren, ob nur arbeitsfreie Tage oder alle Ausnahmen exportiert werden sollen. In Makros implementieren / Implement Macros wird beschrieben, wie ein Makro in Project übernommen werden kann. Mehr Beispielmakros sind unter VBA zu finden. ...

August 22, 2019 · 6 min · Barbara Henhapl
Speed up your website with PurgeCSS

Speed up your website with PurgeCSS

Modern websites and website templates use Cascading Style Sheets (CSS) intensively. To load websites faster, it makes sense to reduce these files to the essential content. You can do that with many tools. PurgeCSS is one of them. See the How To here. I wanted to optimize a small, static one-pager website. I used a HTML5 template with Bootstrap 4. Nothing very fancy, but simple and modern. All my tests ran against my localhost. ...

August 21, 2019 · 4 min · Toni Pohl