Azure Logic Apps Toolbox 10-Dynamic access to keys and values in a JSON object Saturday, June 1, 2024 8:00 AM Toni Pohl In Azure Logic Apps, looping through objects is a common requirement. When we have prior knowledge of an object’s properties, the process is straightforward. However, things get more challenging when attempting to access properties dynamically. See a method to access data in a JSON object dynamically here. Azure | App | Logic apps | Tools | English | Flow Mediumlink | Permalink | Comments (0) | Post RSS mehr
Azure Logic Apps Toolbox 9-More useful Tips Thursday, October 5, 2023 4:00 PM Toni Pohl By working with Azure Logic Apps, data can be processed very quickly and conveniently. Sometimes small details are a challenge, like function names or correct syntax. This is especially true if you don't work with logic apps all the time. In addition to our existing tips here in the blog, we have some other useful functions from various scenarios that will make your work with Logic Apps easier. App | Azure | Developer | English | Logic apps | Microsoft365 | Office365 | Tools | Entra Mediumlink | Permalink | Comments (0) | Post RSS mehr
Why we need the Power Platform Sunday, July 24, 2022 10:00 AM Toni Pohl Today, a quick tip on an article about one of Microsoft's fastest growing companies: Helping power users to build business apps with low-code and no-code apps. App | Cloud | English | Logic apps | Microsoft | Microsoft365 | Power Platform | PowerApps | Serverless Mediumlink | Permalink | Comments (0) | Post RSS mehr
Azure Logic Apps Toolbox 8-Secure your secretswith Azure Key Vault and Managed Identity Sunday, April 24, 2022 4:00 PM Toni Pohl 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. Azure | Developer | DevOps | English | Logic apps | Graph | Security | Serverless Mediumlink | Permalink | Comments (0) | Post RSS mehr
Azure Logic Apps Toolbox 7-Resolve issues with the SharePoint Connector Thursday, March 11, 2021 10:45 PM Toni Pohl Using SharePoint Online (SPO) and Azure Logic Apps helps to automate processes. For a project, we have created some workflows with Azure Logic Apps that monitor changes to an SPO list or document library for approvals and other document workflows. We have found that the SPO connector does not always send all data in a reproducible manner: sometimes some fields were sent and sometimes not. We struggled with this behavior and found an unexpected workaround. Azure | Developer | English | Logic apps | Microsoft | Microsoft365 | Office365 | Serverless | SharePoint Mediumlink | Permalink | Comments (0) | Post RSS mehr
Azure Logic Apps Toolbox 6-Work with items in Apply to each Saturday, March 6, 2021 8:00 AM Toni Pohl Automation of small tasks is helpful for many recurring processes. Unless you regularly use Power Automate (Flow) or Azure Logic Apps, it is often not that easy to remember the correct syntax for accessing items in a loop. Here is the quick help. Azure | Business Intelligence | Cloud | Developer | English | Logic apps | Microsoft | Microsoft365 | Office365 | Serverless Mediumlink | Permalink | Comments (0) | Post RSS mehr
Azure Logic Apps Toolbox 5-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! Azure | Cloud | Developer | English | Flow | Logic apps | Microsoft | PowerShell Mediumlink | Permalink | Comments (0) | Post RSS mehr
Azure Logic Apps Toolbox 4-Working with SharePoint dropdown fields 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 | Logic apps | Microsoft | Microsoft365 | Office365 | SharePoint Mediumlink | Permalink | Comments (1) | Post RSS mehr
Azure Logic Apps Toolbox 3-Get data from SharePoint as HTML table 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 | Developer | English | Logic apps | Microsoft | Microsoft365 | Office365 | SharePoint Mediumlink | Permalink | Comments (1) | Post RSS mehr
Azure Logic Apps Toolbox 2-Send text and files (multipart/form-data) to SharePoint Online Monday, February 17, 2020 6:00 AM Toni Pohl Using an Azure Logic app is often a quick fix for small computing tasks. So my scenario is as follows: I want to use a form on a website to offer text fields and file upload. The submit button is intended to send the data to a Logic App. The Logic App receives the data and writes it to a SharePoint Online list and sends a notification if necessary. See the implementation here. App | Azure | Business Intelligence | Cloud | Developer | English | Flow | Logic apps | Microsoft | Microsoft365 | Office365 | Serverless | SharePoint Mediumlink | Permalink | Comments (2) | Post RSS mehr
Azure Logic Apps Toolbox 1-Use the OData Filter for Azure SQL Databases Thursday, September 19, 2019 9:45 PM Toni Pohl A very quick tip today: When using an Azure Logic App in combination with an Azure SQL Database, filtering rows can be done like here. App | Azure | Cloud | Developer | English | Logic apps | Microsoft | Tools Mediumlink | Permalink | Comments (1) | Post RSS mehr
Working with Microsoft (Group) Forms and Flow Saturday, July 13, 2019 2:00 PM Martina Grom Microsoft Forms is very popular because it is a very easy way to create web forms quickly. You can create surveys, quizzes and simple forms, and easily see results as they come in. This quick tutorial shows how you can use Microsoft Forms, convert it to a group form, how you can access the result file and how to add additional tasks with Microsoft Flow or Azure Logic Apps. Microsoft | Office365 | Microsoft365 | Office | English | Cloud | Business Intelligence | Flow | Logic apps Mediumlink | Permalink | Comments (3) | Post RSS mehr