I have a list of document updates in SharePoint. This list has the following columns: description, status, document number and created by. The 'document number' is a lookup column where the user selects an item from another SharePoint list when creating the item. When a user creates an item in this first list through a SharePoint flow, approvals are sent to the document owner so they can accept the request and accept, the status automatically changes to "updating" through this PowerAutomate flow. The status must also be updated in this other list, where the user selects through the search column. Could anyone help me with how to run this flow? I want to know how I can relate the 2 lists, through a flow, to get the item from the second list and update it.
For the lookup field in your SharePoint list, ensure that you check the ID value, so it is returned with the selected item:
You can then use a Get item action in your flow and use the ID value returned (the lookup field name in my list is named "Related Item"):
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
7
Share
Report
All responses (
Answers (
