blog.atwork.at

news and know-how about microsoft, technology, cloud and more.

Azure Logic Apps Toolbox 8-Secure your secretswith Azure Key Vault and Managed Identity

Credentials and secrets should be stored in a secure environment and not directly in an Azure Logic App or script. Azure provides the Key Vault service, which allows to store such secrets in a secure and controllable way. See how this works here.

Copy a SharePoint list with PnP PowerShell

In the Microsoft 365 world, sometimes you want to copy a custom list in SharePoint Online to another SharePoint site in the same or in a different M365 tenant. While there are third-party tools for this, there is an easy-to-use method for such a scenario using PnP PowerShell. This article shows how it works with a step-by-step example.

Force a content refresh of an Azure static website using Azure CDN

Static website hosting in Azure Storage is really cool and quick method for simple deployment scenarios. Azure CDN edge nodes provide the cache and distribution layer with custom domains, rules, and further configuration options for such a static website. But what to do if you update the static website and it doesn't deliver the new content? How can you force an update? See the solution here.

How to filter entries with Null value in Azure Table Storage Explorer

Azure storage accounts are a great and inexpensive way to store lots of data. I am using Azure Table storage to store large amounts of structured data for various tools. I needed to filter all rows that have a specific field that shows Null. While this sounds simple, it is a bit tricky. Here's how.

Identify guest users and their status with Graph

Working with Microsoft Azure and Microsoft 365, Azure Active Directory as an identity and management system becomes more and more important. Like Active Directory, Azure AD grows throughout time with guest accounts, cloud accounts and synchronized accounts. From a governance and lifecycle point of view - and also for security reasons - it is therefore important to clean up Azure AD from time to time. The cleanup process supports a healthy lifecycle management. In this article we describe how to quickly identify guest users in your own Azure AD with on-board resources.

Export email messages from Exchange Online to a CSV file with Graph PowerShell

I had to export email messages to a CSV file from a specific folder in my Outlook mailbox. Nothing special, just a quick export. I noticed that Outlook allows messages to be exported, but the date of the message is missing in the export file! Really? So here is a workaround to quickly export email messages using Graph PowerShell.

Optimize SQL queries using subqueries for lookups in Azure SQL Databases

I like to work with Azure SQL Databases and use data from the cloud without any administrative effort. When working with apps, App Insights helps to detect anomalies, and to analyze bottle necks. Although SQL Azure can scale very well, we discovered performance issues in some legacy apps. Read here how we solved that by optimizing TSQL data queries.

Tips for PowerApps-Add required user permissions for PowerApps using Dataverse

When users shall have access to a PowerApp that is using Dataverse (formerly Common Data Service - CDS), they also need to have the permissions to access the data entity (nowadays called table). So, if your users get an ugly "unknown error occurred" when accessing the PowerApp, hereĀ“s the solution to assign the required security role and permissions.