How to select multiple rows programmatically in Grid

(0) Share

Report

Posted on by Community member

I want to select a number of rows in a grid programmatically applying some conditions. The rows supposed to be pre-selected. However, I can't find any method to perform this operation. Here is my function as follows.

function formatZIPCodeDecimalFromSubgridField1(executionContext) {    var formContext = executionContext.getFormContext();    debugger;    var tabName = /tab_Settings/;    var tabControl = formContext.ui.tabs.get(tabName);    if (tabControl.getVisible()) {              var subgridControl = tabControl.sections.get(/tab_4_section_3/).controls.get(/Subgrid_new_2/);        subgridControl.refresh();        setTimeout(function () {                      var selectedRecords = subgridControl.getGrid().getRows();            selectedRecords.forEach(function (record) {                var fieldName = /code/;                var fieldValue = record.getData().getEntity().attributes.get(fieldName).getValue();                if (fieldValue !== null) {var rowId = record.getData().getEntity().getId();//subgridControl.SelectRow(1);                    //subgridControl.getGrid().setSelection(rowId, true);                                   }            });        }, 1000);    }}

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Partner,

Do you mean that such a tick action is implemented via js code?

Based on current documentation, there is currently no method to achieve this.

https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/reference/grids

Was this reply helpful? Yes No
Pradeep Rai 5,489 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Why you want to pre-select the rows because if you are writing the javascript then you can get those records using retrieve multiple API call.

Also, we do not have any method currently to select.

if you want the functionality then you can try the PCF control. but this will be time consuming.

Was this reply helpful? Yes No