Microsoft

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

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

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

Deutsche Version Formeln mit einem Datumsfeld lassen sich in Project leicht erstellen. Wenn dabei ein Datumsfeld geprüft werden soll, das potentiell keinen Wert enthält, lässt sich das in der deutschen Version mit einer Prüfung auf „NV" (Nicht verfügbar) abprüfen. Das kann zum Beispiel bei einem Vergleich mit einem Basisplandatum wie Geplantes Ende der Fall sein. Folgende Formel zeigt im Feld Text1 „Kein Basisplan" an, wenn für den Vorgang noch kein Basisplan festgelegt wurde. Dabei wird „NV" mit „ProjDateValue(“NV”)=[Geplantes Ende]" in ein Project-Datumfeld konvertiert, um mit dem Wert in Geplantes Ende vergleichen zu können. ...

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

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

Delegate365 version 8.4 came up with a lot of improvements and updates. This version recently got another update to speed up the license assignment synchronization operation. See the details here. Delegate365 allows to add sync rules to the sync operation to automate specific operations. In large tenants, the sync can run for a long time since all objects must be queried for changes. To accelerate the sync operation when using license assignment sync rules, we optimized this process as follows: ...

See the amazing musical made by interns spending the summer of 2019 at Microsoft: Microsoft the Musical. 150 interns and employees came to the Microsoft Redmond Campus outside of their day jobs to produce this 10 minutes video as a musical during the summer of 2019. The video was published to YouTube yesterday, on September 6th, and result is amazing. The full credits are at IMDb.com. Microsoft the Musical is a cool and professionally made video, with some self-mockery to Windows Vista, and Windows Phone and referrals to current technology. “All around the world our products are well known. Except for when we tried to make a phone…” ...

In addition to all the great features in Office 365, governance plays an important role, especially for large organizations. Richard Campbell, runasradio.com, interviewed Martina Grom recently about governance and tools in Office 365. The interview is available as podcast here. In this podcast, Richard chats with Martina about the various aspects of Office 365 that affect the way users collaborate with each other and get work done. There are bunch of great tools inside and outside of Office 365 to enable Governance. Check out the latest Office 365 Governance podcast with Martina Grom at runasradio.com. ...

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