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.
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. Read More
