Skip to content

Instantly share code, notes, and snippets.

@olafwrieden
Last active September 14, 2022 05:21
Show Gist options
  • Save olafwrieden/689cd079b7223bec9ded83839c2d09fc to your computer and use it in GitHub Desktop.
Save olafwrieden/689cd079b7223bec9ded83839c2d09fc to your computer and use it in GitHub Desktop.
Azure Data Explorer Power Apps Connector
// Create the Table
.create table MyTable (Title: string, Description: string, Importance: string, User: string)
// Append a sample entry
.append MyTable <|
print "Some Title", "This is a long description.", "Low", "Olaf Wrieden"
ClearCollect(
CuratedTelemetry,
AzureDataExplorer.listKustoResultsPost(
"https://[cluster].[region].kusto.windows.net/", // Cluster
"TelemetryDB", // Database
"CuratedTelemetry | take 100" // Query
).value
);
AzureDataExplorer.runAsyncControlCommandAndWait(
"https://adx4utils.australiaeast.kusto.windows.net/",
"MyDatabase",
".set-or-append async MyTable <| print '" & Title.Text & "','" & Description.Text & "','" & Importance.Selected.Value & "','" & User().FullName & "'"
).operationId
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment