blog.atwork.at

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

Use multiple Node.js versions on your computer (and develop a SPFx webpart)

Saturday, January 23, 2021 9:00 PM Toni Pohl
As developer, it often makes sense to have multiple versions of a framework installed on a single computer. For example, when developing SPFx applications with Node,js v10.x and developing web applications using Angular and Node.js v14.x you need both versions. Thankfully, with Node Version Manager, we can.
Developer | English | Microsoft | Open Source | SharePoint | Tools
mehr

Use Azure Logic Apps with custom JSON payloads

Thursday, January 14, 2021 8:51 PM Christoph Wilfing
Did you ever have the problem of pushing different JSON payloads to a logic app and hitting errors due to JSON schema mismatches? The usual HTTP Request forces you to define the JSON Schema at the beginning. For every tiny difference in the later used properties you need to create your own Logic App even if the process is the same. I will show you an example of a single Logic App deciding at runtime which JSON schema to use for decoding the post body payload. Stay tuned!We will start with an empty Logic App and the typical HTTP Request. This will trigger the logic app and start our journey.The HTTP post body schema is a simple one with a single value called "Request" of type string and a another one called "RequestValue" of type object. We are not going into more detail of the RequestValue object because we don't want the initial request to break if the rest of the JSON is different. So, we plan to call the endpoint with a HTTP POST request with a body similar as here:{"Request": "test1","RequestValue": "{ ...something... }"}As next action, we add a switch operation to react depending on the Request.This basic schema allows us to use the automatic created request property of the HTTP Request as input to our switch statement in the next step. Sample requests to this Logic App could be payloads as here:Version 1:{"Request": "test1","RequestValue": { "Testvalue" = "test" }}Version 2:{"Request": "test2","RequestValue": { "Testvalue1" = 1, "Testvalue" = "1234" }}etc...Each case in the switch statement corresponds to one version of JSON payload we can drop into the logic app.Based on the first "Request" Property value and the switch decision we can now build our second stage of JSON payload parsing. The Parse JSON step takes the object of the response value of the HTTP trigger and can be filled with different schemas for each execution tree in the switch statement.Above you see the schema for one of the payloads. A very simple one, but you can get as creative as you like or need to. You can test the logic app with different payloads with a few lines of powershell code (yes, you can use Postman or other tools, too). Just create a few more case statements in the switch and post different bodies to the Logic App as shown below.Invoke-RestMethod -Method Post -Uri $Uri -Headers $Header -Body $(Body1 | ConvertTo.Json)If we look at the output of the commands, we can see the response of the Logic App from the different Switch Paths.With these steps you can have a single Logic App to distinct between different JSON Payloads and react based on the initial HTTP requests without hitting an error on the first request. Dynamic requests can be handled with a single Azure Logic App.Have Fun!
Azure | Flow | Logic apps | Microsoft | PowerShell | Cloud | Developer | English
mehr

Working with Azure AD schema extensions and Microsoft Graph

Tuesday, December 29, 2020 10:30 PM Toni Pohl
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.
Azure | Cloud | Developer | English | Graph | Microsoft | Microsoft365 | Office365 | PowerShell
mehr

Working with SharePoint dropdown fields in Azure Logic Apps

Friday, December 18, 2020 3:00 PM Toni Pohl
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 | Developer | English | Microsoft | Microsoft365 | Office365 | SharePoint | Logic apps
mehr

Get data from SharePoint as HTML table with Azure Logic Apps

Thursday, December 17, 2020 6:00 PM Toni Pohl
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).
Azure | Cloud | English | Developer | Microsoft | Microsoft365 | Office365 | SharePoint | Logic apps
mehr

Handle failed actions in Azure Logic Apps

Tuesday, October 6, 2020 4:00 PM Toni Pohl
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.
Azure | App | Cloud | Developer | English | Flow | Microsoft
mehr

PowerShell package 'Az.Accounts' failed to download

Sunday, September 20, 2020 9:00 PM Martina Grom
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.
Azure | Cloud | Developer | English | Microsoft | Microsoft365 | Office365 | PowerShell | Tools
mehr

SPFx App webpart is blocked in various browsers

Sunday, September 13, 2020 9:30 PM Toni Pohl
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.
App | Cloud | Developer | English | Microsoft | Microsoft365 | Office365 | SharePoint | Security | Windows
mehr

Join us at the Global Microsoft 365 Developer Bootcamp - Austria

Tuesday, August 18, 2020 2:00 PM Toni Pohl
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!
Azure | Cloud | Developer | English | Microsoft | MVP | Microsoft Teams | Microsoft365 | Office365 | PowerApps | PowerShell | Event | Visual Studio | SharePoint
mehr

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

Thursday, July 16, 2020 5:00 AM Toni Pohl
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.
Azure | Cloud | Developer | English | Governance | Microsoft | Microsoft365 | Office365 | PowerShell | Security | Tools
mehr

How user profile picture synchronization works in Microsoft 365

Wednesday, July 1, 2020 9:00 AM Toni Pohl
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.
Cloud | Developer | English | Microsoft | Microsoft365 | Office365 | SharePoint | Exchange
mehr