cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ngct
Helper III
Helper III

Count row in Excel

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?

ngct_0-1663938511462.png

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Sundeep_Malik
Community Champion
Community Champion

Hey @ngct 

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-u....

View solution in original post

2 REPLIES 2
Sundeep_Malik
Community Champion
Community Champion

Hey @ngct 

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-u....

@Sundeep_Malik 

It works. Thanks a lot

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,842)