Customer experience | Sales, Customer Insights,...

How to increment sequence number on other entity "B" when record is saved on entity "A".How can i achieve this

(0) Share

Report

Posted on by Sandy Hello

342

I have number field say "seqno"of type whole number consists of sequence number starts from "500000"on entity "B" ,when entity "A" record is loaded the "seqno" value is loaded to entity A from B and on save of entity A record the sequence number on B should be increment by 1. Here entity A and B does not have any lookup. How can i achieve this.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sandy,

The flow can achieve it, here are steps:

In my example, custom(A) entity and test(B) entity have no relationship

1.Go Power Automate(https://us.flow.microsoft.com/en-us/ ) to create an Automated flow.

2.Create the Trigger event – in this case I have set the trigger to fire when a custom record is created.

2.Add ‘List records’ step, Retrieve one test record with a most recent Created On date value.

3.Add ‘compose’ step to get seqno value from ‘List records’ step.

Once you do this and fill in the fields, Flow takes care of the Apply to each loop. So don’t get confused by this and look for a Apply to each. You don’t need to do this.

4.In ‘Apply to each’ step, add ‘condition’ step to check seqno value is null or not.

(1) In ‘Yes’ branch,

Add ‘Compose’ step to convert seqno value to int and add 1.

Add ‘create a new record’ and fill seqno field with the value of ‘compose2’ step.

(2) In ‘No’ branch, add ‘create a new record’, fill seqno field with the 500000 value.

5.Save and test the flow.

The following is the overview of the flow:

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
Sandy Hello 342 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your response, i am new to flows is there any possible way to achieve this with Javascript

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!
Hi Sandy,

You can refer following js code:

function number () { Xrm.WebApi.online.retrieveMultipleRecords("new_test", "?$select=new_seqno&$orderby=createdon desc&$top=1").then( function success(results) { for (var i = 0; i < results.entities.length; i ) { var new_seqno = results.entities[i]["new_seqno"]; var new_seqno_formatted = results.entities[i]["new_seqno@OData.Community.Display.V1.FormattedValue"]; if(new_seqno ==null)//the lastest test(B) record seqno field is null, create a new record with 50000 { var entity = {}; entity.new_name = "test500000"; entity.new_seqno = 50000; Xrm.WebApi.online.createRecord("new_test", entity).then( function success(result) { var newEntityId = result.id; }, function(error) { Xrm.Utility.alertDialog(error.message); } ); } else // create a new record with seqno 1 { var seqno = new_seqno 1; var entity = {}; entity.new_name = "test" seqno; entity.new_seqno = seqno; Xrm.WebApi.online.createRecord("new_test", entity).then( function success(result) { var newEntityId = result.id; }, function(error) { Xrm.Utility.alertDialog(error.message); } ); } } }, function(error) { Xrm.Utility.alertDialog(error.message); } ); }

And Crm Rest Builder is a good tool to build request.

This is the download page for it: https://github.com/jlattimer/CRMRESTBuilder

1.retrieve one most recent test record.

2.Create test record(B) with specific seqno value.

3.Add the js code to OnSave event of the custom (A) entity.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No