blog.atwork.at

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

Handle failed actions in Azure Logic Apps

Today´s a quick tip for users working with Azure Logic Apps. This article shows how you can continue to work in a flow if an action has failed. This sample accesses an Excel file from a Microsoft teams SharePoint site and searches for a key. If the key was not found, the flow shall continue and deliver a useful error code with a message. See how this works here.

Project: Massenänderung für Ressourcenkostensätze mit VBA / Bulk Update for Resource Rates with VBA

In vielen Unternehmen gibt es jedes Jahr zum Jahresende die Anforderung, die Kostensätze für Ressourcen für das Folgejahr einzutragen. Hier finden Sie ein Makro, dass die Arbeit erleichtert.

In many companies, at the end of each year, there is a requirement to enter the cost rates for resources for the following year. Here you will find a macro that makes your work easier.

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.

Project: VBA Module exportieren und importieren / Export and Import VBA Modules

Nachdem ich jahrelang Zeit verbraucht habe, mit rechten Mausklicks Module für BackUp-Zwecke zu exportieren und neue oder geänderte Module zu importieren, habe ich vor einiger Zeit Code geschrieben, womit ich das automatisiere. Ich stelle ihn hier gerne zur Verwendung bereit.

After spending years of exporting modules for back-up purposes and importing new or modified modules with right mouse clicks, I wrote code some time ago that automates this. I am happy to provide it here for use.

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.

How user profile picture synchronization works in Microsoft 365

From an historical point of view, various single services such as Exchange and SharePoint Online have been integrated into Office 365, or as it´s named now, Microsoft 365. The platform shows user profile pictures, and syncs that between the services, depending on the service (licenses). Since this can be a little bit confusing, we now have a good article explaining the user profile sync.