[BUG]: Fluent Details List Fails to Load More Than 500 Records from SQL Server Despite App's 2000-Row Limit

[FabianAckeret]

Component: Fluent Details List
Version: 1.1.41
Data Source: SQL Server Connector

Bug Description

The Fluent Details List component gets stuck in an infinite loading state when its Items property is set to a SQL Server table or view containing more than 500 records.

• The Power App's data row limit for non-delegable queries is set to 2000.
• The component works perfectly when the data source has 500 or fewer records or when using ShowColumns() --> (it will become non-delegable).
• The failure occurs consistently as soon as the record count is 501 or greater.

This behavior strongly suggests the component is using a non-delegable query and is either hardcoded with a 500-record page size or has a bug that prevents it from paginating beyond the first 500 records, ignoring the app's configured 2000-row limit.

Crucially, a standard Power Apps gallery control connected to the exact same SQL data source works perfectly and is fully delegable, displaying all records without issue. This isolates the problem to the Fluent Details List component's specific data-handling mechanism.

Steps to Reproduce

1. Environment Setup:

• In a Power App, go to Settings > General and set the Data row limit to 2000.
• Ensure the Creator Kit is installed with Fluent Details List version 1.1.41.

2. SQL Server Setup:

• Create a simple test table in a SQL Server database.

CREATE TABLE dbo.DetailsListReproTest (
    ID INT PRIMARY KEY IDENTITY,
    Name NVARCHAR(50)
);

• Populate the table with 501 rows.

DECLARE @i INT = 1;
WHILE @i <= 501
BEGIN
    INSERT INTO dbo.DetailsListReproTest (Name) VALUES ('Test Row ' + CAST(@i AS NVARCHAR(10)));
    SET @i = @i + 1;
END;

3. Power App Configuration:

• Add a connection to the SQL Server database and the dbo.DetailsListReproTest table.
• Add a Fluent Details List control to a screen.
• Set its Items property to the test table: dbo.DetailsListReproTest
• Configure the Fields property in the properties pane to display the ID and Name columns.

4. Run the App:

• Play the app and observe the screen with the Fluent Details List.

Expected Behavior

The Fluent Details List should respect the app's 2000-row data limit for non-delegable queries. It should load and display the first set of records from the SQL table without getting stuck in an infinite loading state.

Actual Behavior

The Fluent Details List displays an infinite loading indicator and never renders the data. If the number of rows in dbo.DetailsListReproTest is changed from 501 to 500, the component loads and displays the data instantly.

Troubleshooting Summary (Ruled-out Causes)

This issue has been extensively troubleshooted. The following potential causes have been confirmed NOT to be the issue:

• SQL Schema or Data Types: The issue is reproducible with any table schema, including very simple ones. Brand new tables created from scripts work fine up to 500 records.
• Data Corruption ("Poison Pill" Row): The failure is consistently tied to the record count (501), not the content of any specific row.
• SQL Metadata (ANSI_NULLS, DEFAULT constraints): These were investigated and ruled out through methodical testing.
• The key finding is that a standard Power Apps gallery is fully delegable and works flawlessly with the exact same data sources, which isolates the issue to the component itself.

[FabianAckeret]

Is this repo even still being maintained?