Answered

Unable to process template language expressions for action 'Condition' at line '0' and column '0':

(0) Share

Report

Posted on by jessikalobo Microsoft Employee

Hi, I am creating a power automated flow that sends an email on a recurring basis if Azure Kusto query returns results, but I need this e-mail only when the table has row. If the table does not return any results, the condition is false, and the e-mail won't be sent.

How do I fill my compose field with this condition? I am getting this error. Thanks in adv

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

jessikalobo Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks @Expiscornovus sm for helping, but I was still having issues, so I resolved my problem with another way. I did the table render after the condition. This way, my compose went fine 🙂

Was this reply helpful? Yes No
Expiscornovus 33,406 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @jessikalobo,

I would try and replace the variables by the outputs() function and the body field. You can amend this in the expression tab.

length(outputs('Run_KQL_query_and_render_a_chart')?['body'])

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

Like (0)

Report
Copy link

Link copied!

Thanks for replying @Expiscornovus

Actually, I am not sure how to fill this field. I was following GTP's instructions but got stuck in this error for days. Already tried without the 'variables' but still getting problem 😞

Was this reply helpful? Yes No
Expiscornovus 33,406 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @jessikalobo,

It looks like you are checking the length of data returned via the KQL query in a Compose action, correct?

However, I see in the screenshot you used a variables function. I would have expected a outputs function instead over there.

Btw, if a length function does not work you can also try a empty function instead.

Was this reply helpful? Yes No