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);    }}

All responses (2)

Answers (0)

Pradeep Rai 5,490 Super User 2024 Season 2 on at

Like (0)

Report

How to select multiple rows programmatically in Grid

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.
Leah Ju Microsoft Employee on at

Like (0)

Report

How to select multiple rows programmatically in Grid

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