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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

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.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (1,384)