0

I have 2 lists that need to run in parallel. When list 1 gets submitted, it automatically needs to fill in certain fields in list 2.

List 1 can be completed on its own as well, however list 2 cannot.

I have set up the 'Create list item' workflow which is all working fine.

However, when items in list 1 get amended, I need it to automatically update in list 2.

I have tried the 'Update List Item' workflow, however there will be no way to determine what item needs to be updated, because list 1 can also be completed on it's own (without the need for list 2) so the ID's will not match.

Does anyone have any ideas how I can achieve this?

Improve this question

1 Answer 1

Reset to default
0

Create a hidden field in list 1 and list 2 that has a unique id. So when a item is created in list 1 the hidden id will be put in the item in list 2 by the Create List Item Workflow. Then when you need to update you can search list 2 for that unique hidden id.

Improve this answer
3
  • Thanks Belmer. Would this hidden field need to be a calculated column? If so what would the formula need to be? Commented Aug 8, 2017 at 14:50
  • It would not need to be calculated you just need it to be a unique id for that item between the two lists. This could be done with a calculated column or you could include the column in the create form and have the user just input one. Commented Aug 8, 2017 at 15:01
  • I wouldn't use a calculated column - I would have the workflow populate your hidden field with the ID of the list item in the other list which needs updating. Commented Aug 8, 2017 at 15:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.