cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MohanKann21
Frequent Visitor

Power Apps Model Driven App - Records from Virtual Table Issue

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

5 REPLIES 5
MohanKann21
Frequent Visitor

Hi All,

 

I am attaching Screen Capture for reference.

 

Thanks for your help.

 

Regards

 

Mohan

Prakash4691
Super User
Super User

@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

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

@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
Advocate I
Advocate I

@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. 

 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (1,302)