Microsoft Dynamics 365 | Integration, Dataverse...

Triggered a Power Automate Flow when a subgrid is added to or deleted from

(0) Share

Report

Posted on by Lee-Martin

513

I've a subgrid on a form for a model driven up.

I need to be able to trigger that flow whenever that subgrid is added to or deleted from

The relationship is N:N

Does anyone have any tips?

Thanks
Lee

All responses (3)

Answers (0)

SivaR 34 on at

Like (0)

Report

Triggered a Power Automate Flow when a subgrid is added to or deleted from

You can use flow and webhook to achieve this.

https://www.youtube.com/watch?v=dU8XDqSVPqQ
SashM 10 on at

Like (0)

Report

RE: Triggered a Power Automate Flow when a subgrid is added to or deleted from

You can do something like this.

Create a new field that tracks the number of records added to the sub grid.

For example: no_of_records

Create and add below function onload of the form with function name "Sdk.formOnLoad"

Run the workflow or power automate when "no_of_record" field is updated.

var Sdk = window.Sdk || {};

(function () {

this.formOnLoad = function ()

{

debugger;

var gridContext = Xrm.Page.getControl("your_subgrid_name_here"); // sub grid name

gridContext.addOnLoad(Sdk.gridOnLoad);

}

this.gridOnLoad = function()

{

debugger;

var gridContext = Xrm.Page.getControl("your_subgrid_name_here");

var grid = gridContext.getGrid();

var totalNumberOfRecord = grid.getTotalRecordCount();//no of record

var rows = grid.getRows();

if(totalNumberOfRecord == 0)

{

setTimeout(Sdk.gridOnLoad, 3000);

}

if ( totalNumberOfRecord != null){

Xrm.Page.getAttribute("no_of_records").setValue(totalNumberOfRecord);

}else{

Xrm.Page.getAttribute("no_of_records").setValue(0);

}

}

}).call(Sdk);
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

RE: Triggered a Power Automate Flow when a subgrid is added to or deleted from

Hello,

Check this post - crmtipoftheday.com/.../