Forum Discussion
Flow to update a SharePoint list item when a new item is created in a different SharePoint 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.
