web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to count the numbe...

Power Apps

Answered

How to count the number of rows in powerapps?

(0) Share

Report

Report

Posted on by Philbert9879

80

Let's say the number of rows show 4 above, my current formula is:

CountRows(DataTable1.Selected.NSN) does not work. The forumla to display the number of rows.

Regards,

Philbert

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

v-mengmli-msft on at

Like (0)

Report
Hi @Philbert9879 ,

Do you want to count rows in DataTable?

Please try this.

CountRows(formula on the Items of DataTable)

Best regards,

Rimmon

Was this reply helpful? Yes No
VishalJhaveri 1,167 Moderator on at

Like (0)

Report

CountRows(TableName or GalleryName)

Was this reply helpful? Yes No
JamesYumnam on at

Like (0)

Report

There are two ways of achieving this:
i. Use the modern control "Table". It shows the count of rows in the table by default.
ii. Your case where you are using the classic Datatable control. for this, in the Items property of your datatable, you must have written a Filter or Search PFx like the one shown below in my case.
to get the row count, i have added a label and in the Text property, I have used this PFx.
CountRows(the formula in the above Items property of the Datatable)

Note: CountRows(DataTable1.Selected.NSN) will not work as it deals only with the selected record(s) in the data table.
Hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog James Yumnam

Was this reply helpful? Yes No

Join the conversation