web

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

News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Getting the row count ...

Power Automate - Building Flows

Unanswered

Getting the row count of 'Get rows' action suddenly started failing

Like (0) Share

Report

Report

Posted on 13 Nov 2022 00:19:27 by David59740

49

Hi, I am using a 'Get rows' action in my flow. All I am trying to do is get the count of the rows returned.

I have a 'Compose' action directly after that has the expression

length(body('Get_rows')?['value'])

This expression has been working for months and is all of a sudden failing. I am getting the error message:

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

I then tried changing the expression to be:

length(outputs('Get_rows')?['body/value']) but I am encountering the same issue.

Any ideas?

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

David59740 49 on 24 Nov 2022 at 04:43:08

Like (1)

Report

Re: Getting the row count of 'Get rows' action suddenly started failing

I deleted action and remade it with the exact same logic and it works now. Thank you for the response, that is a valid answer if the flow wasn't corrupt or whatever happened.

Was this reply helpful? Yes No
grantjenkins 11,059 Moderator on 13 Nov 2022 at 01:47:01

Like (1)

Report
Re: Getting the row count of 'Get rows' action suddenly started failing

Your expression looks completely fine:
length(outputs('Get_rows')?['body/value'])

Can you have a look at the output from your Get rows action, or if you can't see it there, add a Compose with the following expression to see what output you get.
outputs('Get_rows')?['body/value']

If it doesn't have a value object (it should but seems like it's not including it if no rows) then you can try the following:
if(empty(outputs('Get_rows')?['body/value']), 0, length(outputs('Get_rows')?['body/value']))

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Responsible AI policies for the Community

Quick Links

Leaderboard > Power Automate

#1

Tomac 986 Moderator

#2

stampcoin 699 Super User 2025 Season 2

#3

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans