Forum Discussion
Connect two SharePoint lists
Hi Everyone,
Please I need help I created A nonconformity Report SharePoint list and Corrective Action List and the flow I created is as:
1- When any new item created in the nonconformity Report SharePoint list, create anew Item with the same title in the Corrective Action List and add link to its related item in the nonconformity Report SharePoint list (this flow works fine)
2- when item is created in Corrective Action List I need to update its related Item in the nonconformity Report by adding the link to item to Corrective Action List. but when I added update Item action here in the flow it is get the link to Corrective Action List but it creates a new item.
Hi Ghada Mehrez
Thanks for the additional explanation. If I am understanding you correctly, this should be fairly simple to do. I understand you to say that when an item is created in List A, then a task should be created in Task List B with a link back to the new item in List A, and also the RelatedTo field in that new item should be updated to contain a link to the new task in List B. Is that correct? If so, please see the following flow, which does that using basic actions.
Overview (trigger + 2 actions):
Detail of creating an item in the Task List, including a link to the new item which triggered the flow. You probably already figured out that the name of your task list must be entered manually as it's not listed by default under List Name.
Detail of updating the original item in List A to add a link to the task just created in the Task List. ID and Title are from the trigger item (When item is created), and RelatedTo is the Link to Item from the step just above (Create new item).
Does this do what you want...?
Sandy
- Hi,
What is the value of the 'Id' param you are sending to the 'Nonconformity Report' list, it should be 'Id' of the related item. Can you please check?Sudharsan K here it is
- Hi,
Can you try updating the item using the REST API. Use 'Send Http request to SharePoint' action.
