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)

v-yamao-msft on at

Like (0)

Report

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
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 on at

Like (0)

Report

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

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

This is the current history.

PBI settings:

Was this reply helpful? Yes No