Line count of filtered DataTable

(0) Share

Report

Posted on by torsten156

Hi all,

i use a DataTable with connection to a SQLDB. This DataTable can filtered about a Textinput. After a filtering i see 7 Lines. How can i counting this lines?
A CountRows() provides me a count of ALL lines, not the 7 lines!

Thanks...

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

timl 36,393 Super User 2025 Season 2 on at

Like (1)

Report
Hi @torsten156

To retrieve a count of the filtered results, you would need to call CountRows and pass the result of the Filter function.

CountRows(Filter('[dbo].[YourTable]', Column=txtInput.Text))

Was this reply helpful? Yes No
torsten156 28 on at

Like (0)

Report

Super, it works.
Thanks

Was this reply helpful? Yes No