Forum Discussion
Two connected lists
Hi
I have a issue I need to solve. I will try to describe is as good as I can but it feels pretty delicate.
I have 2 list lets call them just "List 1" and "List 2" to make it easy.
In "List 2" i have a collumn with a lookup to add items from "List 1".
So far no problems.
But the thing is that when I add one ore multiple items from "List 1" in the "List 2" item i would like that a Automation updates the selected List items from "List 1" with the linked name from "List 2".
This needs to work wich create a new Item in "List 2" and when modifing the item.
I tried to have my CoPilot to do this for me but it failed big time.
Hope that someone have an greate solution for me!
Thanks in advance.
1 Reply
- michalkornetIron Contributor
Hi DalRot , you can create a flow that starts with the "When an item is created or modified" trigger.
From the trigger output, you can retrieve the IDs of the selected lookup items.
Then, using an 'Apply to each' loop, you can update each item by its ID.