Azure Logic Apps

Overview – Azure Logic Apps
Create cross-environment parameters in Azure Logic Apps workflow
Create a Http trigger-based workflow
Creating a Logic App that showcases the use of all variable types
Logic app workflow involves a string or JSON object created from multiple inputs of different data types
Logic App – Insert data into On-Prem SQL Server
Logic App workflow to retrieve data from SQL using a stored procedure
Workflow triggered by recurrence that connects to on-premises file systems in Azure Logic Apps
Logic App workflow for creating a file in SFTP with exception handling
Create or join parallel branches using workflow actions in Azure Logic Apps
Logic App workflow with a “For Each” loop that processes items sequentially
Logic App workflow that retrieves JSON data from an HTTP request and converts it into a CSV format
Create HTML table in Logic App workflow
A Logic App workflow that uses Filter array, Select and Join actions
JavaScript code inline in Azure Logic Apps workflow
Batching (aggregating) messages using batch receive and batch sender in a Logic App
Manage large messages in workflows by using chunking in Azure Logic Apps
Azure Logic Apps workflow- Handle throttling problems (429 – “Too many requests” errors)
Identify and resolve workflow failures in Azure Logic Apps
Monitoring the health and performance of Azure Logic Apps workflows
An overview of automating the deployment of Azure Logic Apps using Azure Resource Manager templates
Ensuring secure access and data protection for workflows in Azure Logic Apps
Effective Planning and Management of Costs for Azure Logic Apps
Encoding and decoding flat files in Azure Logic Apps workflows using Text and XML formats
Testing workflows with mock outputs in Azure Logic Apps
Delay and Delay until action in Azure Logic Apps
Invoke REST API endpoints within workflows using Azure Logic Apps
Use Liquid templates as maps in workflows to transform JSON to JSON/TEXT and XML to JSON/TEXT in Azure Logic Apps
Manage Azure resources and monitor expenses by creating automated tasks
Previous Lesson
Next Lesson

Workflow triggered by recurrence that connects to on-premises file systems in Azure Logic Apps

Azure Logic Apps Workflow triggered by recurrence that connects to on-premises file systems in Azure Logic Apps
To get a file from a local (on-premises) folder using a Logic App, you need to set up an On-Premises Data Gateway and then configure your Logic App to use it.

Step-by-Step Guide

  1. Set Up On-Premises Data Gateway:
    • The first step is to set up an On-Premises Data Gateway. This gateway allows Azure Logic Apps to securely communicate with on-premises data sources.
    • Download and install the On-Premises Data Gateway from the Microsoft Download Center.
    • Configure the gateway following the setup instructions, and make sure it’s running and connected to your Azure subscription.
  2. Create a Logic App:
    • In the Azure portal, create a new Logic App.
  3. Add a Trigger:
    • Add a trigger based on how you want to start the Logic App. For example, you could use a Recurrence trigger to run the app on a schedule.
  4. Set Up File System Connector:
    • Add a new action and search for “File System“.
    • Choose the action for your requirement – Get File Content.
  5. Configure Connection to On-Premises Folder:
    • Set up a connection to the on-premises folder by selecting the previously configured On-Premises Data Gateway.
    • Provide the necessary details such as file path, authentication method, etc.
  6. Process the File:
    • Depending on what you want to do with the file, add actions to process the file content. For example, you could save the file to Azure Blob Storage, send it via email, or process the content further to local folder using action- Create file.
  7. Save and Test: 
    • Save your Logic App and test it to ensure it retrieves the file from the on-premises folder and saves it to the on-premises Out folder correctly
Here's how your Logic App should look:
estudy247-la-test-file-04

You can download the logic app template from the estudy247 GitHub repository – la-test-file-04

Previous Lesson
Back to Course
Next Lesson
Post a comment

Leave a Comment

Scroll to Top