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 Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (1,852)