[BUG]: Detail List not rendering Data

[lorenzobiagio]

Describe the bug I have a solution with a Custom Page connected to the SQL server I'm using some Fluent detail lists and I know how this works I'm using several of them in the app. The problem is that instead of displaying the items it displays only some grey rows without information. When refreshing the data source, all rows display by a moment and then they disappear again. This is not a network or data issue since a gallery placed on the same page and with the same data source displays the data correctly.

To Reproduce No known steps.

Expected behavior Detail list should display the data

Screenshots

AB#1923

[SPWareing]

I have had similar issue with Dataverse tables in Canvas Apps, where the only way to get the data to show is either:

• Use AddColumns (to create a local collection)
• Create a Collection

[lorenzobiagio]

Thanks for the advice. The issue is the collections have a limitation of 500 records and it's not enough for me.

[SPWareing]

Thanks for the advice. The issue is the collections have a limitation of 500 records and it's not enough for me.

Sorry I wasn't suggesting a workaround.

I was saying the problem is widespread and needs addressing. At the moment I use these workarounds.

[denise-msft]

Thank you for reporting this. We will investigate and provide an update as soon as possible.

[knyklu]

Just clear the browser cache and reboot the app.

[denise-msft]

@lorenzobiagio We're having trouble reproducing the issue. Can you please submit this form to contact us directly about this issue? https://forms.microsoft.com/r/XErgLKUZrY

[lorenzobiagio]

@lorenzobiagio We're having trouble reproducing the issue. Can you please submit this form to contact us directly about this issue? https://forms.microsoft.com/r/XErgLKUZrY

Hi @denise-msft, I will answer to the form.

Regarding the problem after other tests I have made here is what I have found out: the detail list is impacted by how many records there are on the table/view that you have set as a data source. it seems if the number of records is higher than the page size value it doesn't work. If you set the page size value to a high value (for example 2000) it will render the data. So changing the page size value seems to solve the issue at least in the editor of the canvas app/custom page.

Still changing the page size value to a high value (so all the records should be displayed) didn't solve completely the problem for my case. I use the detail list on a Custom page that is embedded in a model-driven app. When I play the model-driven app and I go to my custom page it has a different behavior compared to the editor. The pagination will trigger and generate a second page even if it shouldn't be a second page to solve it I have added a refresh button, the button refreshes the data source connected to the detail list. ( I think I will remove the pagination because it doesn't make sense now to still have it)

Another strange behavior is when you use the pagination feature, you can change the page but only the last page will render the data(for this case I didn't have to change the page size value).

[lorenzobiagio]

Hi @denise-msft , I completed the form you provided but unfortunately haven't received any response yet. Could you please check if my submission was received successfully? and do you have any updates?

[denise-msft]

Hi @lorenzobiagio, thank you for your patience. Are you still running into this issue? We will assign help as soon as resources are available.

[jh-sigmadx]

I can confirm that this behaviour is still happening in September 2024.

I have a Details List looking directly at a SharePoint List of just over 4000 Items. The details list will NOT display ANY data if the Page size is less than the number of Items in the Data Source.

This behaviour does not change at all whether the "Large Dataset Paging" is true or false.

It simply seems that the Details list cannot handle large data sets - this would severely limit its usefullness!

James.