InvalidTemplate: tileValue doesn't exist

(0) Share

Report

Posted on by ECE

Hi,

I have created a flow that is based on a Power BI alert trigger.

The flow contains a Variable (step) which formats the tileValue to millions. The flow randomly stops at the variable step, with the error: "Invalid Template: ...tileValue doesn't exist...".

I don't understand why this happens.. The tileValue is above the Treshold.

Please help

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ECE ,

Could you share a screenshot of the flow?

Are you able to get the Tile Value in a Compose action when the flow is triggered?

I have made a simple test likes below, it is possible to get the Tile value when the alert is triggered.

Best regards,

Mabel

Was this reply helpful? Yes No
ECE 8 on at

Like (0)

Report
Copy link

Link copied!
This is how the flow looks like:

And this is the error:

The flow is working perfectly most of the times, but the error happens once in a while.
I have just added a "Contains" check to the Variable, to try catch the error.
if(contains(triggerBody(),'tileValue'),div(triggerBody()['tileValue'],1000000),'20')
However the "Contains" didn't work..

I haven't changed the flow between the runs - i.e. exact same flow that first succeeds and later fails.

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ECE ,

Do you mean that the error just happens sometimes?

The issue could not be reproduced by me.

I have made the following test with the similar functions with you, both of them are working fine.

Best regards,

Mabel

Was this reply helpful? Yes No
ECE 8 on at

Like (0)

Report
Copy link

Link copied!

Hi Mabel,

First of all thank you for you response.

Yes, the error only happens sometimes..
This morning after the Power BI report was updated, I noticed that the flow had failed once again. So I went to the PBI Dashboard and one minute after I opened the Dashboard, I received an email alert.. It almost felt like actually opening the Dashboard triggered the flow..

In Power BI under Manage Alerts, there is a checkbox "Send me email, too". This one is NOT checked. I am unsure if this could make a difference.

Was this reply helpful? Yes No
ECE 8 on at

Like (0)

Report
Copy link

Link copied!

This is the current history.

PBI settings:

Was this reply helpful? Yes No