Unanswered

How to use Azure Data Explorer results in a Power Apps Canvas App Drop-Down Items list?

(1) Share

Report

Posted on by aconkle Microsoft Employee

I have table data available from Azure Data Explorer that I need to show as the Items for a canvas app drop-down control.

I am testing by having a single column in my Data Explorer table and my query returns 2 rows.

I am using OnStart of the app to make the Data Explorer call within Collect(myCollection, myCallToKusto). In the Collections preview, I see little icons that look like tables, but I do not see strings there.

In my drop-down I am using Items = myCollection.value. None of the strings from Kusto are showing in the drop-down. However, I have a OnChange event calling Collect(myCollection2, myDropDown.SelectedText).

When I view the Collections sample data, I see the same little table icons. This leads me to believe data is coming back from Kusto and being passed into my collections as I expect, but the tabular format must not be correct.

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

PowerBuilder 30 on at

Like (0)

Report
Copy link

Link copied!

Hi @aconkle,

You need to state you need the values from ADX in your schema,

Try this on a event (e.g. Button Click):

ClearCollect(col_CollectionName,AzureDataExplorer.listKustoResultsPost("ClusterName","DB","Kusto Query").value)

All the items in bold are the items you need to change, also you will notice the important part of the [.value] part at the end to structure your Collection.

Please remember to capture your schema for the collection to be structured with the dynamic function in the background.

If this worked for you please mark this post accordingly.

Regards,
PB

Was this reply helpful? Yes No
NECC Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I'm seeing this same issue. I can recreate the problem following the instructions on using the connector here Create Power Apps application to query data in Azure Data Explorer | Microsoft Learn.
When I look at the collections sample, for the Results collection, all I see is this:
But if I run the Monitor while running the connection, I can see it returns a table from ADX with the expected data.
This is the OnSelect value for the button in my app:
ClearCollect(
Results,
AzureDataExplorer.listKustoResultsPost(
"https://help.kusto.windows.net",
"Samples",
"StormEvents | take 15"
).value
)

Was this reply helpful? Yes No
PowerBuilder 30 on at

Like (1)

Report
Copy link

Link copied!

Hi ,

Please make sure you enable the capture schema feature in settings, restart your application. Go to the button, you will notice the capture schema button on the bottom of your formula configuration.

Also make sure you have permission to access the ADX cluster and the KQL query. Looking at the cluster you have [help sample] specified, I'm not sure if you can set up the ADX connector to connect to that cluster. You would need to set up the connector to point to your own Azure cluster.

Was this reply helpful? Yes No
NECC Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I missed the step where you have to enable the dynamic schema experimental feature in the tutorial. That solved my initial problem. Though, now it seems to be limited to a single action (one instance of the dynamic schema). I ended up just building a Power Automate flow to handle the query and response.

Was this reply helpful? Yes No