English

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

A particularly challenging year is coming to an end. We would like to wish happy holidays and a happy new year to all of you. Once more, we say thank you for the good cooperation in 2020 and are looking forward to a hopefully healthy and successful 2021! This year for Christmas, we support the project UNICEF Österreich: für jedes Kind. atwork will be closed from December 24th, 2020 to January 6th, 2021. Our on-call duty and our support will be able to be contacted during the holidays. Our entire team will be back for you from January 7, 2021. ...

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

Microsoft enabled a new feature for Microsoft Teams: Dataverse (former Common Data Services –CDS) for Teams. It empowers Teams Owner to create PowerApps directly in Teams without any additional storage space for its data (e.g. a SharePoint List) To achieve that every “Power App enabled Team” gets its own Power App Environment. But there are some things to consider: Power Platform Admins can NOT control the creation of Teams (Dataverse) Environments – the only way is to disable the Teams App “Power Apps” via Teams App Policies ...

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

This quote from Immanuel Kant made my day: “Many things have a price, some have a dignity.”

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: Check out the free Microsoft eBook “Roadmap to Digital Infinity” - How to become an Intelligence Driven Organization! Roadmap to Digital Infinity This is a short eBook with 19 pages that “will show you how to take the next steps on your digital journey.” It covers topics from Intelligence Driven Organization to the Digital Feedback Loop and the the core solution. It’s a beautifully designed eBook. I like the statements like “Change is the new normal” and a statement from Ralph Haupter, President, Microsoft EMEA: “One thing we can count on: combining human ingenuity with innovation will be essential, not optional”. In addition, the data analysis helps to put an organization in a test and learning culture. New ideas can be developed, started and improved with much more confidence. ...

Sometimes it is useful to convert data in documents to another format. There are various tools for this. My favorite conversion tool is Pandoc. Pandoc supports a few dozen file formats, from Word to Markdown and many more. See how to convert a document with Pandoc here. Download the Pandoc tool Pandoc is a cost free and universal document converter, available for all platforms. You can download the command line tool from https://pandoc.org/installing.html. ...