Microsoft Logic Apps and Azure Data Explorer

The Microsoft Logic Apps connector allows you to run queries and commands automatically as part of a scheduled or triggered task.

Note

In order for a logic app to access to a network protected cluster, you must add the outbound IP addresses associated with the region of your logic app to the firewall allowlist. For more information, see Manage public access to your Azure Data Explorer cluster.

Create a logic app with Azure Data Explorer

  1. Open the Azure portal.

  2. Search for "Logic apps" and select the Logic apps service.

    Screenshot of the Azure portal, showing the search for Logic apps.

  3. Select +Add.

    Screenshot of the Logic apps page, showing the add logic app button.

  4. In the Create Logic App pane, fill out your app details, and then select Review + create.

  5. Verify that the details are correct, and then select Create.

    Screenshot of the Create Logic App page, showing the Basics tab filled out.

  6. When the logic app is created, go to the resource Overview page.

  7. On the left menu, select Workflows, and then select + Add.

    Screenshot of the Workflows page, showing the add workflow button.

  8. In the New workflow pane, fill out the workflow details, and then select Create.

    Screenshot of the New workflow page, showing the details filled out and the create button.

  9. In the list of workflows, select your workflow.

  10. On the left menu, select Designer.

  11. Add a recurrence trigger, and under Choose an operation, search for Azure Data Explorer, and select then the Azure results tab.

  12. Select Azure Data Explorer, and then under Actions choose the action you want to use.

    Screenshot of the designer page, showing the Azure Data Explorer actions.