blog.atwork.at

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

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.

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

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.

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.

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.

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.

SPFx App webpart is blocked in various browsers

Recently, I stumbled across a strange behavior when running self-developed SPFx webparts in various browsers. When the SPO app was deployed, it worked well with Single-Sign-On, but in some browsers, the webpart was blocked. Instead, a grey box saying "login.microsoftonline.com refused to connect." was displayed. I experienced that behavior in Chrome, and Edge, while FireFox, Safarai and Opera showed the webpart. Also, there was a different experience when working in the normal mode, or in the In-Private mode. If that happens to you, check out the solution here.

Join us at the Global Microsoft 365 Developer Bootcamp - Austria

Global Microsoft 365 Developer Bootcamp is back! This year the event will take place virtually from more than 100 cities worldwide. Join us at our Microsoft 365 Developer Bootcamp - Austria on November, 13th, 2020!

Get Administrator roles and Privileged Identity Management roles of an Azure AD tenant

To ensure the security of your Microsoft 365 client, we recommend implementing an appropriate governance and security strategy. An effective measure is to determine the current administrators and their permissions. In this article, we want to identify administrators with permanent roles and administrators who can use roles with Privileged Identity Management (PIM). PIM provides just-in-time privileged access to Azure AD and Azure resources. See how to find all Administrators, including PIM, here.

Honored to be renewed as Microsoft MVPs 2020-2021

This July, the Microsoft MVP Award Program renewed the MVP award to our four MVP-colleagues at atwork. We are honored to receive this award for our community work! Martina Grom received heir 10th MVP award for Microsoft Azure and Microsoft 365, Toni Pohl his 8th MVP award for Microsoft Azure and Office Development, Sigi Jagott his 8th MVP award for Microsoft 365, and Dominik Höfling his 3rd MVP award for Microsoft 365.