web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL Get Rows - row count
Power Automate
Unanswered

SQL Get Rows - row count

(0) ShareShare
ReportReport
Posted on by 115

I have been using the following expression with an om premises SQL Get Rows action, to check if any rows were returned:

 

length(body('Get_rows_(V2)')?['value'])
 
Recently this seems to have stopped working and I get the error:
 
Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'.
 
Has anyone else experience this? I have been using the above for years and it has been fine.
Categories:
I have the same question (0)
  • DuncanIVH Profile Picture
    115 on at

    I have also tried

    length(outputs('Get_rows_(V2)')?['body/value'])
  • DuncanIVH Profile Picture
    115 on at

    ems to be related to the SQL view that I'm selecting from. Some views return an empty Body, others return no body at all

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard