Join the M365 virtual community events

Join the M365 virtual community events

Ready to learn more about Microsoft 365 technology such as Microsoft Graph, SharePoint, Office-AddIns and more? Check out the Microsoft 365 virtual community events! Have fun and get involved!

January 5, 2021 · 1 min · Martina Grom
Working with Azure AD schema extensions and Microsoft Graph

Working with Azure AD schema extensions and Microsoft Graph

Azure Active Directory is Microsoft´s Cloud Identity system that stores user, license, group, apps, device data and more data in a secure way. As developers, we can extend many of these resources with custom extension. This can be useful to store additional metadata, such as a cost center or personal data for a user, for a group or other resource types. Unfortunately, there isn’t much documentation on that. Here’s how to do this step-by-step for the user resource with Azure AD schema extensions in real life. ...

December 29, 2020 · 13 min · Toni Pohl
Azure Logic Apps Toolbox 4-Working with SharePoint dropdown fields

Azure Logic Apps Toolbox 4-Working with SharePoint dropdown fields

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

December 18, 2020 · 2 min · Toni Pohl
Azure Logic Apps Toolbox 3-Get data from SharePoint as HTML table

Azure Logic Apps Toolbox 3-Get data from SharePoint as HTML table

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

December 17, 2020 · 4 min · Toni Pohl
Tune in to the Governance Live Discussion with Dux Raymond Sy and Martina Grom - Good Governance Precedes Great Adoption

Tune in to the Governance Live Discussion with Dux Raymond Sy and Martina Grom - Good Governance Precedes Great Adoption

Today, there was a free live event on the Collab Global CON4 platform about IT Governance in Microsoft Teams. Tune in to the Governance Live Discussion with Dux Raymond Sy and Martina Grom - Good Governance Precedes Great Adoption. Live Discussion: How to Make It Easy For People to Do the Right Thing in Microsoft Teams. (Good Governance Precedes Great Adoption) Hear the two talk about why Teams governance is important and see examples of how processes can be improved. ...

December 3, 2020 · 1 min · Toni Pohl
Ö1 Podcast über Cloud Computing mit Martina Grom

Ö1 Podcast über Cloud Computing mit Martina Grom

Letzten Freitag wurde ein Beitrag im ORF Ö1 Radio im Technologie-Magazin “Matrix” zum Thema “Wo unsere Daten wohnen - Vom (Computer-) Leben in der Rechnerwolke” mit unserer Cloud-Expertin Martina Grom gesendet. Hier geht es zur Aufzeichung. Die Journalistin Sarah Kriesche wirft in dem Beitrag einen Blick hinter die Kulissen des Cloud-Geschäfts und lud dazu unsere Geschäftsführerin und Microsoft Cloud-Expertin Martina Grom von atwork ein. Weitere Gäste waren Werner Illsinger, Präsident der Digital Society und Thomas Dullien, Geschäftsführer von optimyze. ...

November 29, 2020 · 1 min · Toni Pohl
Delegate365 changelog 9.2-improvements

Delegate365 changelog 9.2-improvements

The next version of Delegate365 is here. Delegate365 v9.2 follows the last update v9.1. This update includes a bunch of helpful features and improvements such as SharePoint sites management, Group OU improvements, report improvements, a new message trace job and more. See a description of the new features here. License bars on the dashboard, for users and quotas: The license information is now visually improved for Portal Administrators. A license bar per license (SKU) shows how many licenses are in use and how many are available in total. The same applies to a user’s licenses… …and license quotas. The new display enables a quick view of the licenses. ...

October 22, 2020 · 6 min · Toni Pohl
Delegate365-Goodbye, Basic Authentication

Delegate365-Goodbye, Basic Authentication

Delegate365 provides a toolbox for easy management of a Microsoft 365 tenant. Management ranges from Exchange Online to Azure AD, SharePoint Online, Reporting and Intune. Delegate365 communicates with the Microsoft 365 services via apps and Modern Authentication, wherever possible. However, a service account had to be used for some Exchange features and the multi-factor authentication management. This will change with the next versions. Some M365 background information So far, some Microsoft services such as Exchange Online (EXO) could only be reached with Basic Authentication, while other (new) services such as Microsoft Graph can be used with an app. Basic Authentication relies on sending usernames and passwords with every request increasing risk of attackers capturing users´ credentials. Therefore, Microsoft recommends that you stop using Basic Authentication. Basic Authentication is superseded by *Modern Authentication *based on OAuth 2.0 that is supported for the new Microsoft 365 services. ...

October 21, 2020 · 6 min · Toni Pohl
Austria is getting its own Microsoft data centers

Austria is getting its own Microsoft data centers

Today, Microsoft announced “the Microsoft cloud in Austria, for Austria”. The Austrian data center region will join Microsoft’s global cloud and provide Microsoft 365, Microsoft Azure and Dynamics 365 services. Microsoft’s Austrian data center region supports companies in complying with the General Data Protection Regulation (GDPR) of the European Union and will offer companies on-site access to the entire range of Microsoft cloud services. Microsoft also announced a new Center of Digital Excellence to modernize the IT infrastructure of public services and to promote industrial innovations in Austria. ...

October 20, 2020 · 1 min · Toni Pohl
PowerShell package Az.Accounts failed to download

PowerShell package Az.Accounts failed to download

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

September 20, 2020 · 2 min · Martina Grom