cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

How to automatically get item from another list?

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.

Capturegeg.PNG

 

 

 

2 REPLIES 2
Super User III
Super User III

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.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials
Impactful Individual
Impactful Individual

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.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (31,718)