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

4 REPLIES 4
MohanKann21
Frequent Visitor

Hi All,

 

I am attaching Screen Capture for reference.

 

Thanks for your help.

 

Regards

 

Mohan

Prakash4691
Solution Supplier
Solution Supplier

@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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,429)