Found invalid parameter types: 'Null'

(0) Share

Report

Posted on by ArnoldSky

Hi All,

Kindly assist to figure this error out please:

"The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@greater(item()?['field_1'], item()?['RecoveredPieces'])' failed: 'The template language function 'greater' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'Null'.'."

The flow compares and filters the field_1 > RecoveredPieces and creates an array

I have had the flow running for a time now and suddenly failed yesterday.

I have checked all the parameters, all are integers.

Thank you

Categories:

General topics

All responses (3)

Answers (0)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ArnoldSky ，

Please check that all filed_1 and RecoveredPieces fields of the Where array in your Filter Array have null values.

Best Regards,

Sunshine Gu
ArnoldSky 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sunshine,

I have checked all the field_1 and RecoveredPieces values, all have integer values, no Null.

I was wondering why the filter array did not produce an array, hence the Select had also error out because Null was passed on.
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ArnoldSky ，

Could you please upload all the screenshots of the 'Where' in your Filter Array to me, and the privacy information can be coded.

Best Regards,

Sunshine Gu