How to automatically get item from another list?

[picnicfunL]

My Purpose:

User entry item in List A,  if "product type "="A", automatically add the same item info into list B. 

When user update info in list A, update the same item list B at the same time.

When user update info in list B, update the same item in list A at the same time.

so far, this is my flow but it failed.

[abm]

Hi @picnicfunL 

To analyse this further could you please report what error is? I can see there are 89 records trying to update here. In your scenario make sure you don't want to end up in an infinite loop. Believe you have two flows running for List A and List B.

[cwebb365]

Yeah, remove the getitems step, you don't need that. You are basically going to have to have two hidden columns at a minimum on each list that holds the releationship/ID of each other so you know that they exist / you can edit the correct items as they get modified from one list to the other. After that, you would have a trigger like you do for create / edit, with a column filter to only run when that column equals the value you want. Then you'll have to do the checks to see if it's a new value or not and create the item in the other list if not, and vise versa, then handle modifications. It's a pretty in depth flow to make this work.