I was wondering if there's a way to create a workflow that when an item gets added to a list, copies specific columns from that item onto another list. Any help is appreciated.
So what i'm trying to accomplish is, when a user adds an item to List_1, only certain items will be copied to List_2. And if the user updates a current item on List_1, only certain items are updated on List_2. These will be the same items that get copied over when the new item is created on List_1. I hope this makes sense.
Thanks for any help.
To create an item in List 2 after item was created in List 1
So when you create your workflow in List 1 use 'Create Item' action to create the item in List 2. You will see that the columns from List 2 are available from the Field dropdown in the action. Here you can select which fields in list 2 you want to update. Make sure to store the Item ID of the new item in List 2, in a column in List 1 so that you know which list items are connected.
To update the item in list 2 when the item was updated in List 1:
Create another workflow and set the start condition to only run when the item was modified. Then in the workflow use the 'Update Item' action to update your item in List 2. Use the Item ID that you stored in your list to find the connected item in List 2 to update