Using Power Apps to Read and Write Records into Azure Data Explorer

If you landed here, you likely have a canvas Power App to act as a friendly user interface (UI) for data stored in Azure Data Explorer. You can read from Azure Data Explorer, but you can’t write to it from a Power App. Until now!

Exploring Power Apps’ ADX Connector

Power Apps supports querying the ADX cluster via one of five methods exposed by Power Apps’ Azure Data Explorer Connector.

1. Run an async control command:
   Runs a control command in async mode and returns its ID, state and status on completion. Command can run for maximum 1 hour. The async keyword is mandatory. e.g. .set-or-append async TargetTable <| SourceTable
2. Run a control command and render a chart:
   Runs the control command and returns the result as a chart of your choice e.g. .clear table TableName data
3. Run a KQL query
   Runs the KQL query and returns the result as a set of rows which can be iterated over e.g. TableName | take 10
4. Run a KQL query and render a chart
   Runs the KQL query and returns result as a chart of your choice e.g. TableName | where Timestamp > ago(1h) | project timestamp, value
5. Run a show control command
   Runs the show control command and returns the result as a set of rows…