Forum Discussion
Flow to update a SharePoint list item when a new item is created in a different SharePoint list
I have two lists that are related to projects - 'Dashboard' & 'Status Reports'. Both of these lists contain the columns 'RAG Status'.
I want to create a flow that updates the 'Dashboard' 'RAG Status' column with the 'RAG Status' information from the most recent item submitted on the 'Status Reports' list for that specific project.
The project name information on the 'Dashboard' list is called 'Full Project Name' and the same information is stored under 'Project Name' on the 'Status Reports' list.
Hi rosscoy , I'd recommend you avoid using spaces in list field names, it makes referring to them in expressions and elsewhere a great deal easier.
You need a Flow which is triggered by new items added to your 'Status Reports' list. That Flow would then get items from the 'Dashboard' list where the project name matches, then have it update the status.
Hi Jon,
Thanks for the response. My issue is, that I don't know how to get the flow to look up the project name on the Dashboard that matches the new item created on the Status Reports list. For reference, the project name on the Status Reports list is a lookup column that references the Dashboard list, I'm not sure if this would change anything.
See my current flow set up below - I don't know how to reference the RAG column as the item to take the update from, or how to essentially use a lookup for the Project Name (lookup) column in Status Reports and Full Project Name (calculated column) column in the Dashboard.
