Associate/Dissociate Record using Power Automate

-

Note: For latest dynamic CRM interview question please click Here.

Scenario: I have entity A and entity B. entity A and B is having 1: N relationship and entity B is the sub grid of entity A . Once you open Entity B record then unique id field of Entity A as the lookup of entity B is present in Entity A (Means if 1:N relationship between A and B then lookup will be in entity B). Now there is another entity called entity C. There is relationship between C and B is N:N means one of the record of B entity may be related to the multiple record of C entity. Once you open the C record in C from you will find the subgrid of B entity and once you open B entity record you will find subgrid of C entity.

Screenshot For you reference: 

Once i open any B record see the screenshot :

Now each record of  B Entity  might contain multiple record of C entity if you remove one B record if it is associate with multiple of C record it will also remove from multiple of C record.

Now we have question on which we are going to create power automate :

If we remove B record from A entity then it will also be deleted from associate c record so for this we have written one power automate.

Observation : While remove the B record from Entity A then lookup is present in B get null.

Step 1:  So on change of filed "refrenceofA".


Step 2: Now we will check the condition on field "refreceofA" is null or not if it is null we do operation.we pass null as a function expression.

Step 3: Fetch the list of entity A and we pass table name as a relationship name and add the suffix as "set" and select the require column with filter with Entity B id which is passed as a dynamic.



  Now each record of entity B may contain multiple record of entity C. so now we will perform for each operation on each record of inspection entity. We are performing foreach loop on inspection value. and table name given as B and Row ID pass as entity C id.


Now if  record of B is related to the record of C the we will perform unrelated operation see the below image. Table name as entity B and row id is entity B id and relationship name is in between Entity B and Entity C and unrelated with is taken from the get a row by ID.


Now record is dissociate after that whatever you want you can do based on your requirement. 



Please feel free to ask and like or subscribe my YouTube channel..😊😊😊😊

Note: For latest dynamic CRM interview question please click Here.

                                     





Comments

Post a Comment

Popular posts from this blog

latest dynamics 365 interview questions

-
Image
Q. How to pass extra value in custom page in power apps? Ans: Generally in pageInput we can define four parameter like  pageType, name, entityName, recordId. But in real senarion if we want to share extra value then we can use in pageInput parameter itself. Example : var pageInput =  { pageType: "custom", name: customPageName, entityName: executionContext.data.entity.getEntityName(), recordId: currentRecordId + "$" + recordName ; }; Above value you can retrieve in custom page onStart function like below : Set(splitParam,Split(Param("recordId"),"$")); Set(recordName,Last(FirstN(splitParam,2)).Value); Set(RecordID, Substitute(Substitute(Last(FirstN(splitParam,1)).Value, "{", ""), "}","")); Q. If I create one record that created record date is older than 3 days then I want to perform some operation with the help of business rule. example: Let's assume I have case entity form and have
Read more

difference between enable rule vs display rule in ribbon workbench

-
 Enable Rule: It is the client side process.  Let's start with example:  I have an account entity under that I have more than two form. I just want to show the specific button based on the particular form you can use enable rule here. Display Rule: It is server side process. Let's start with example: I want to show and hide the button based on the security role then we will go for display rule. Note: For latest dynamic CRM interview question please click  Here .
Read more

If i create one record that created record date is older than 3 days, then I want to perform some operation with the help of business rule.

-
Image
Note: For latest dynamic CRM interview question please click  Here . Scenario: Let's assume I have case entity form and have created one custom field XYZ if the case is older than 3 days then I need to make XYZ field as mandatory otherwise it would be optional? Step 1: Create a new filed called "todaydate" with data type "Date and Time" and field type "Calculate". Now click on the edit and make the field as a current date and time by selecting the Now () function under Action that is it no need to give anything under condition. For better understanding i took one more field on form "createdon".  Note: "createdon" field is Out of the Box entity. Step2: Now I am going to write Business Rule to make field mandatory if case is older than 3 days otherwise it will be optional.  Step3: Once you activate the business process flow just open any old record which is older than 3 days. I have updated some of the field and try to save but it is
Read more