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
This is the current history.
PBI settings:
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.
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
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.
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
WarrenBelz
146,587
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,928
Most Valuable Professional