web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Count row in Excel

Power Automate

Answered

Count row in Excel

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All, I am trying to get the Countrow of Excel table using these 2 steps

It works well and accurate when the Excel file is <256 rows. However, It will only show 256 even when there are >256 rows.

May I know is there any work-around?

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

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Sundeep_Malik 6,501 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @Anonymous
The number of items is 256 by default. By going into settings of the action you can increase it to 5000.
Free licence has only 5000 limit.
With different licensed, it can be increased.

Check this link out:

https://www.c-sharpcorner.com/article/retrieve-more-than-default-number-of-rows-of-data-from-excel-using-power-automat/#:~:text=Introduction,next%20batch%20in%20Power%20Automate.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@Sundeep_Malik
It works. Thanks a lot

Join the conversation