Power Platform Community Forum Thread Details

Cannot convert a value from Kusto Query to integer

Hi all, I have run into this strange issue where I cannot convert Kusto query results into integers with combo of expression and Data Operation in Power Automate.

First, I wrote this Kusto Query:

Cluster URL: https://hwinventory.kusto.windows.net/

Database: hwinventory

Query:

Dbd

| where ExpectedBinId startswith "ZQZ24"

| where State == "WaitingDestruction"

| summarize Age = now() - min(CreatedTime)

| project Age = toint(format_timespan(Age,"d"))

| project Age = iif(isempty(Age), 0, toint(Age))

And then I added another step: Data Operation → Compose, using formula "int" in the Expression to compose the result of the query above. To clarify it, I could not use the query results in the flow directly, which is why I had to compose them.

When I run the flow, I would always get this error message saying that:

Action 'Convert_Bin_Age_of_ZQZ22_to_Integer' failed.

Unable to process template language expressions in action 'Convert_Bin_Age_of_ZQZ22_to_Integer' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

I also tried changing the last line of my Kusto query to:

| project Age = iif(isempty(Age), "0", tostring(Age))

but I got the same error message. I am pretty sure my query is fine because it runs okay in Azure Data Explorer.

I could not for the life of me figure out what went wrong. I believe I composed my steps correctly and start to wonder there's something wrong with Power Automate. Would highly appreciate it if somebody can help me out here.

Quick Links

Leaderboard > Power Automate