Show related field for editable grid selection

(1) Share

Report

Posted on by ctedesco3307

938

I understand an editable grid is on a form but is there any way to show an additional value based on the record selected in the editable grid? So in this example I'd want the Invoice Amount and Ledger total field to update based on the record I select in the grid

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ctedesco3307,

Out of the box, no form fields like Invoice Amount / Ledger Total are bound to the main form record, so they won’t automatically change when you click a row in an editable subgrid.

To achieve what you want, you need a small customization using the grid’s OnRecordSelect event (available for editable grids/Power Apps grid): when a row is selected, run JavaScript to read the selected record ID, retrieve the values (e.g., via Xrm.WebApi.retrieveRecord), and then display them (ideally in a web resource/PCF/side pane). Avoid writing them into normal bound fields unless you really intend to update the main record.

Grid OnRecordSelect event: https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/reference/events/grid-onrecordselect

Xrm.WebApi.retrieveRecord: https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/reference/xrm-webapi/retrieverecord

let me know if that answers your question.

Best regards,
Valantis

Was this reply helpful? Yes No
Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ctedesco3307,

Just wanted to check in and see if everything is working now. If you still need any help, feel free to let me know.

Also, if the issue is resolved, it would be great if you could mark the answer as solved so others with the same question can find it easily.

Thanks and have a great day!

Was this reply helpful? Yes No
Suggested answer

DP_Prabh 381 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ctedesco3307,

Yes. Using JS with the Editable Grid OnRecordSelect event and Xrm.WebApi.retrieveRecord is a supported.

Relevant Microsoft docs:

Editable Grid Events (OnRecordSelect) (https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/reference/events/grid-onrecordselect)

Xrm.WebApi.retrieveRecord (Client API) (https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/reference/xrm-webapi/retrieverecord)

formContext.getAttribute().setValue() (https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/reference/attributes/setvalue)

I hope this works for you!

Was this reply helpful? Yes No