Microsoft Dynamics 365 | Integration, Dataverse...

How to get the row grid count not working in Unified Interface

(1) Share

Report

Posted on by Ics_rthompsoneu

I am using the Unified Interface. I can't seem to get the grid count to work anymore.

function getGridRowCount(formContext, gridControl) {
   var subGrid = formContext.getControl(gridControl).getGrid();
   var subGridRows = subGrid.getRows().getLength();
   return subGridRows;
}

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Try using getTotalRecordCount method instead of length.

https://docs.microsoft.com/en-us/powerapps/developer/model-driven-apps/clientapi/reference/grids/grid/gettotalrecordcount

Hope this helps.

Was this reply helpful? Yes No
Ics_rthompsoneu 74 on at

Like (0)

Report
Copy link

Link copied!
I changed my code still not working.

I am wondering if the problem has to do with the sections appearing as "Tabs" in UI.

export function getGridRowCount(formContext, gridControl) { var gridContext = formContext.getControl(gridControl); var totalSubGridRows = (gridContext).getGrid().getTotalRecordCount(); return totalSubGridRows; }

Was this reply helpful? Yes No
Jane88 80 on at

Like (0)

Report
Copy link

Link copied!

we have the same issue. the length always return 0 in UCI.

We try to get the attribute from each row. But the forEach never executed.

var rows = formContext.getControl(xxx_SUBGRID).getGrid().getRows();

rows.forEach(function (row, i) {

var text = row.data.entity.getPrimaryAttributeValue();

});

Please help to fix the issue!

Thanks!

Was this reply helpful? Yes No
Suggested answer

Henry J. 5,237 on at

Like (1)

Report
Copy link

Link copied!
There are multiple things here,

As Ravi Kashyap explained, the proper method is the getTotalRecordCount.

So this should work:

var formContext = executionContext.getFormContext(); // get the form Context var gridContext = formContext.getControl("contacts"); // get the contacts subgrid context var filteredRecordCount = gridContext.getGrid().getTotalRecordCount();

Now as Ics_rthompsoneu suggested, subgrids and web resources within tabs are not loaded until the tab is displayed.

This is by design to optimize performances. Have you referred to that article?

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/optimize-form-performance#form-scripts

Use collapsed tabs to defer loading web resources
When web resources or IFRAMES are included in sections inside a collapsed tab they will not be loaded if the tab is collapsed. They will be loaded when the tab is expanded. When the tab state changes the TabStateChange event occurs. Any code that is required to support web resources or IFRAMEs within collapsed tabs can use event handlers for the TabStateChange event and reduce code that might otherwise have to occur in the OnLoad event.

Henry

Was this reply helpful? Yes No
Suggested answer

CU06121650-0 6 on at

Like (0)

Report
Copy link

Link copied!

I was trying to SHOW the section the subgrid was in if it contained at least one record, but getTotalRecordCount always returned zero. I fixed this by showing the section with the subgrid by default and HIDING it if there were no rows. Seems like if the grid isn't displayed then the rows in the grid aren't recognized. Thought I'd mention this since I'd only seen mention of the Tab being displayed by default and not the section.

Was this reply helpful? Yes No