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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / 【Seek Help】 How to cre...
Power Automate
Unanswered

【Seek Help】 How to create a condition basing on the number of rows found in the "List rows present in a table"?

(0) ShareShare
ReportReport
Posted on by 25

Dear Experts, 

 

I am trying to create a condition control that is based on the number of rows found in the "List rows present in a table".

The expected condition is :IF the number of rows is greater than 5, then Yes. IF less or equal to 5, then No.

 

I tried using the "Length" expression but failed. Is there any way that we can achieve that condition action?

 

2019-11-13 10_11_15-Edit your flow _ Power Automate.png

 

Many thanks for your help in advance!

 

Best regards,

Tom

Categories:
I have the same question (0)
  • Verified answer
    Ed Gonzales Profile Picture
    4,531 Most Valuable Professional on at
    Re: 【Seek Help】 How to create a condition basing on the number of rows found in the "List rows present in a table"?

    @TomLu1231 

    Hi there.  Try changing the values of the list rows to an array, and then doing your Length:

     

    20191112a.PNG

     

    The expression is 

    length(array(body('List_rows_present_in_a_table')?['value'])) and you would replace the bold part with the output "Value" from your List rows step.  From there, you can run your condition on the Compose, right?
     
    Keep us posted.
    -Ed-
     

    If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

     

     

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
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard