web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate The template language ...

Power Automate

Answered

The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'.

(0) Share

Report

Report

Posted on by pmwhelan

375

Sorry I have googled and seen a solution that is not working for me.

I am trying to find the number of matches in an SPO list.

I use the expression ...

length(body('GetFilesPO')?['body/value'])

but I get the error

The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'.

Thanks

P

Categories:

flow error 1.png

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @pmwhelan

There may be many moments when you will get null values. For this I would suggest you to use the following expression:
if(equals(length(body('GetFilesPO')?['body/value']),null),0,length(body('GetFilesPO')?['body/value']))

Or the below expression:

if(equals(body('GetFilesPO')?['body/value'],null),0,length(body('GetFilesPO')?['body/value']))

So, I am checking if the above expression is equal to null or nor, if it equals null, then give length 0, otherwise the normal value.

Hopefully this will work.

If this works for you, you can marks this as a solution. You can give a thumbs up as well. 🙂

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Hi @pmwhelan ,
Do you want to get the number of files under the folder?
Please try changing the formula to:

length(outputs('GetFilesPO')?['body/value'])

Best regards,
Dezhi

Was this reply helpful? Yes No

Join the conversation