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.
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.
Mark it as solution, if it answers your question.
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.
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.
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.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!