You’re offline. This is a read only version of the page.
Announcements
82
Hey,
I want to count rows of a SQL-Table, but SQL is marked with a delegation warning.
I increased the data row limit for non-delegable queries to 2000 (max).
Unfortunately my table has more than 2000 records.
If I display the table as a gallery and count the rows of the gallery, I have to scroll to the bottom of the gallery.
Thanks for your help.
Hi @JonasH
Unfortunately, it's not possible to retrieve an accurate record count from within PowerApps due to the 2000 row limit.
If you want a straight count of the records in your table, one way to work around this is to use a SQL Server View.
You can create a view in SQL Server that looks like this:
CREATE VIEW vwTableCount AS SELECT COUNT(*) AS [RowCount] FROM dbo.MyTable
In your app, you can add this View as a datasource. In the label where you want to display the count, you can use the following formula:
First(vwTableCount).RowCount
Share
Report
All responses (
Answers (
