Error: '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

Posted on by TesDA

611

Hello!

I'm trying to check if an item exists, and then if it doesn't add a row to a sharepoint list based on - https://powerusers.microsoft.com/t5/Building-Flows/How-to-check-if-item-already-exist-in-SharePoint-list/td-p/780008

however I keep running into an error in the condition:

Unable to process template language expressions for action 'Condition_2' at line '1' and column '23513': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#length for usage details.'.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (3)

Report

You'll want to do the length on just outputs('Get_items_2')?['body/value'] rather than the specific field. If Get Items doesn't find items the field won't exist, but the output array will.

Was this reply helpful? Yes No
TesDA 611 on at

Like (0)

Report

I knew it would be something simple! Thanks for the speedy reply @Pstork1 !

Was this reply helpful? Yes No
subsguts 1,259 Moderator on at

Like (0)

Report

@Pstork1 I'm getting the same error message and this is my length statement. What am I doing wrong? Thanks!

length(outputs('Get_rows_(V2)')?['body'])

Sorry for this post, I looked @Pstork1 reply again and saw I didn't have the /value

so it worked after I added that.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report
Check the output of your Get rows V2 action. It looks like its returning a null value. One way to deal with that is to use a Compose inside the length to substitute an empty string if the get rows retuns a null. That will give you a lenght of 0

I would also check the value instead of the body. So it should be this

length(outputs('Get_rows_(V2)')?['body/value'])

Was this reply helpful? Yes No
Graham79 20 on at

Like (0)

Report

I am getting a similar error message regarding "The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'"
Below is my current flow which looks for new Sharepoint list entries, searches for the created by field and gets the person's email address, to then send them a Team chat and email to alert them of new entry. Appreciate any assistance to correct this issue.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Please post this as a new question. You'll get more responses and others will be able to find the answer more easily later.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Okay I'm try to do it the way you are suggested fellows which is
length(outputs('Get_rows_(V2)')?['body/value']), the flow runs whiout errors but insteady of adding anly the newly added records it's actually creating all items againg meaning I'm having duplicates

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Okay I'm trying to do it the way you have suggested fellows which is
length(outputs('Get_rows_(V2)')?['body/value']), the flow runs without errors but instead of adding only the newly added records it's actually creating all items again meaning I'm having duplicates

Was this reply helpful? Yes No
steve_hendy 385 on at

Like (0)

Report

number column this worked for me

Was this reply helpful? Yes No