Skip to content

Latest commit

 

History

History
53 lines (34 loc) · 3.65 KB

logicapps.md

File metadata and controls

53 lines (34 loc) · 3.65 KB
Raw
title description ms.reviewer ms.topic ms.date
Microsoft Logic Apps and Azure Data Explorer
Learn how to use Logic Apps to run Kusto queries and commands automatically and schedule them.
docohe
how-to
08/09/2023

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.

Logic Apps and :::no-loc text="Power Automate"::: are built on the same connector. Therefore, the limitations, actions, authentication and usage examples that apply to :::no-loc text="Power Automate":::, also apply to Logic Apps, as mentioned on the :::no-loc text="Power Automate"::: documentation page.

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 Microsoft Azure portal.

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

    :::image type="content" source="media/logic-apps/logic-app-search.png" alt-text="Screenshot of the Azure portal, showing the search for Logic apps." lightbox="media/logic-apps/logic-app-search.png#lightbox":::

  3. Select +Add.

    :::image type="content" source="media/logic-apps/logic-app-add.png" alt-text="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.

    :::image type="content" source="media/logic-apps/logic-app-create-new.png" alt-text="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.

    :::image type="content" source="media/logic-apps/logic-app-workflow.png" alt-text="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.

    :::image type="content" source="media/logic-apps/logic-app-new-workflow.png" alt-text="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. To learn more about each action, see flow actions.

    :::image type="content" source="media/logic-apps/logic-app-kusto-connector-inline.png" alt-text="Screenshot of the designer page, showing the Azure Data Explorer actions." lightbox="media/logic-apps/logic-app-kusto-connector.png":::

Related content