Edit

Share via


Microsoft Logic Apps and Azure Data Explorer

By using the Microsoft Logic Apps connector, you can run queries and commands automatically as part of a scheduled or triggered task.

Logic Apps and Power Automate are built on the same connector. Therefore, the limitations, actions, authentication, and usage examples that apply to Power Automate also apply to Logic Apps, as mentioned on the Power Automate documentation page.

Note

To enable a logic app to access a network protected cluster, 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 Microsoft 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 +Create.

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

  4. In the Create Logic App pane, enter 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, select Open resource.

  7. In the left navigation pane, select Workflows, and then select + Create.

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

  8. In the New workflow pane, enter 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. In the left menu, select Designer.

  11. Add a recurrence trigger. Under Choose an operation, search for Azure Data Explorer. Select the Azure results tab.

  12. Select Azure Data Explorer. Under Actions, choose the action you want to use. To learn more about each action, see flow actions.

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