Linking parent and child records automatically

(0) Share

Report

Posted on by varshinims08

104

Hi all,

I want to build a flow to link parent and child records of same entity. Here is the scenario, I have entity A. When a new record is created in entity A it will check for duplicate record using "List rows" connector, if record already exist then i want to add newly created record(child) to already existing record(parent). How can I do this?

I tried to use "relate rows" connector, but i am getting error as Action 'Relate_rows' failed.

Thanks....

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@varshinims08

What is the relation between Parent and child is it 1:N?

Was this reply helpful? Yes No
varshinims08 104 on at

Like (0)

Report
Copy link

Link copied!

@Mira_Ghaly

Yes.. It is 1:N relationship. When I am creating records in entity it is linking correctly, But when testing in flow it is throwing error as

Sometimes its working fine, sometimes showing error. I dont know what is wrong.
Thank you...

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@varshinims08

Can you please add a screenshot to the step where u create the child record and how you are setting the lookup?

Was this reply helpful? Yes No
varshinims08 104 on at

Like (0)

Report
Copy link

Link copied!

@Mira_Ghaly

Here i am creating a child record,
and this is my flow

Thank you

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@varshinims08

To set a lookup ok the child entity you do not need to use relate rows , Relate rows for N:N Relationships

so while creating your child set the lookup to the parent as below:

/parentshemanameinplural/ParentGUID

To get your parent Schema Name, go to make.powerapps.com and go to tables -> Select your Table and Click Settings

Note: SchemName while passing lookup should be in Plural+ Lower Case

Was this reply helpful? Yes No
varshinims08 104 on at

Like (0)

Report
Copy link

Link copied!

@Mira_Ghaly Thank you

I was able do it. But I want all the child records to have single parent.
But in my case i set Top Count as 2, so 1st child will have 1st existing record as parent and all other childs will have child 1 as parent...
If i set Top Count as 1, then no parent record will be atteched to the child..

How to achieve this?

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@varshinims08

Can you share screenshots of your flow so that I can understand the issue?

Was this reply helpful? Yes No
varshinims08 104 on at

Like (0)

Report
Copy link

Link copied!

@Mira_Ghaly

Here is my flow

The problem is if i choose Top count as 1 in List rows, the results of conditions in 'Apply to each' will be 'true'.....Even if all the values are correct to get the false result.

And I am trying to update the record from the 'when a row is created' trigger
I have created a look up field called parent claim with N:1 relationship and trying to update that field with record from List row action.
BUT i am getting NotFound error in Update action.

If I use the delete action with Same GUID, it is working. But only Update action is not working.

And if I try to delete the record which i got from list rows, it is deleting the record successfully,
But if i try to delete the record from 'when a row is created' trigger, it is deleting but in showing error in Apply to each condition as ActionFailed. No dependent action succeeded.

Sorry for posting more than one thread here.
I am new to Dynamics and I am not getting what is wrong with my flow.

Thank you...

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@varshinims08

Here you need to pass only the Id , which is the id from List Rows so Just pass GUID because this is the ID of the record and not a lookup

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@varshinims08

Have you managed to fix the above issue?

Was this reply helpful? Yes No