Hi,
I have a cloud flow that gets triggered on schedule and the I run a query against a Power BI dataset to get some data. I use those data to create an html table.
I am using a select action to create an array out of the Power BI dataset retrieved. On the select value I have an expression before the Power BI item that adds a string as a prefix on the value in case a condition is met.
In order to make my life easier I have created a column in the BI dataset that checks the condition and returns true or false. So, in the select I write this expression if(item()?['BIdataset[Flag]'], 'AddString', '') and then the item from power bi. This was working for over a year until 3 weeks ago when I started getting a specific error.
On the select action I get the following error "'The template language function 'if' expects its first parameter to be of type boolean. The provided value is of type 'Null'". Sometimes re running the flow ad hoc solves the problem but other times I have to rewrite the expressions. I know for a fact that the column Flag has always one out of the two values True or False.
Also, when I open the failed flow run on the inputs there is not a single instance that the Flag field gets a null value.
Does anyone have any idea why is this happening?
Am I missing something in my flow?
19
Share
Report
All responses (
Answers (
