Error when running a query against a dataset

Like (0) Share

Report

Posted on 27 Jul 2022 20:15:05 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 29 Jul 2022 at 11:44:25

Like (0)

Report

Re: Error when running a query against a dataset

That worked! Thank you very much!
Verified answer

v-xiaochen-msft on 29 Jul 2022 at 08:42:58

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