Power Apps Model Driven App - Records from Virtual Table Issue

[MohanKann21]

Hi All,

I created a Virtual Table in Dataverse Environment, The database is External Azure SQL.

I registered the C# plugins and records  displayed in Virtual Table's View and Data tab.

However, only one record (last record) is displayed in Model Driven App Form.

Please suggest/help how to fix this issue.

Regards

Mohan

[MohanKann21]

Hi All,

I am attaching Screen Capture for reference.

Thanks for your help.

Regards

Mohan

[Prakash4691]

@MohanKann21 

It looks like there are more than 5000 records. At once, we can only retrieve 5000 records from dataverse table. if there are more than 5k records, in your retrieve multiple plugin include code w.r.t paging cookie. Attached link for your reference.

https://docs.microsoft.com/en-us/powerapps/developer/data-platform/org-service/page-large-result-set...

Mark it as solution, if it answers your question.

Regards,

Prakash

[MohanKann21]

Hi Prakash4691,

Thanks for your reply.

I changed Retrieve Multiple Plugin to fetch 50 records only.

 And updated plugin is registered in Dataverse Environment.

But still the power apps list form shows only one (last) record.

Regards,

Mohan

[Prakash4691]

@MohanKann21 ,

To validate, in plugin include itracing service to trace count of the records. If possible any field value from all the records.

You can check it in plugin trace log inside the system after the operation completed.

If it is async plugin you can check in system jobs for any exceptions.

You can find those options in settings sitemap.

Regards,

Prakash

[bs-dev001]

@MohanKann21 @Prakash4691 

Has this issue been resolved? If so, please share the solution with us.

We are experiencing exactly the same symptom.  I've just created a post which explains our case (https://powerusers.microsoft.com/t5/Microsoft-Dataverse/View-in-Model-Driven-app-not-showing-all-rec...)

Note that we don't use C# plugins.