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:

General Questions

All responses (2)

Answers (1)

torsten156 28 on at

Like (0)

Report

Re: Line count of filtered DataTable

Super, it works.
Thanks
Verified answer

timl 34,939 Super User 2025 Season 1 on at

Like (1)

Report
Re: Line count of filtered DataTable

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))