Error when running a query against a dataset

(0) Share

Report

Posted on by mp-iconn

I am running a query against a power bi dataset and get the following error.

InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'greater' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'Array'.'.

My flow consists of the following:

This is the value that is returned when it errored out:

We are just trying to check at the end of the day if we still have employees clocked into the system and if they are we get alerted to this. So my querying the dataset just returns a value of how many employee's clocked in still via a measure in power bi.

Any advice or help is greatly appreciated.

All responses (2)

Answers (1)

mp-iconn 23 on at

Like (0)

Report

Re: Error when running a query against a dataset

That worked! Thank you very much!
Verified answer

v-xiaochen-msft on at

Like (0)

Report
Re: Error when running a query against a dataset

Hi @mp-iconn ,

Please try this expression.

items('Apply_to_each')?['[Value]']

Best Regards,

Wearsky