Answered

Kusto Query Language for Azure Data Explorer

(0) Share

Report

Posted on by felixcheah

I'm trying to do a query from an Azure Data Explorer, see the query below.

The problem i'm having is with the top operator. '"&Samples&"' is the text input from my power app (see below). This doesn't seem the work the query comes back with KustoResultsPost failed: _scrubbedSensitiveData... However when i replace the '"&Samples&"' with a number like 10, the query works perfectly fine. I've set the format for the text input to number.

Any idea why this is happening?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@felixcheah

Samples is a text input control, to get its text value you will need to use the following formula.
Samples.text

This will get the text data from the Samples text input control.

Hope this helps.

Cheers!
felixcheah on at

Like
a
(0)

Report
Copy link

Link copied!

i get the same error 😞
Verified answer

narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@felixcheah

I suggest you create a text variable to store the query.
It might be that your query is not getting sent properly. Can your query when you put the samples value manually?

Cheers!