I have a SharePoint List that has columns "Project" & "Due", and an excel spreadsheet with the same columns. Currently, the List has two rows, and the spreadsheet has 8 rows. The projects in the List are contained in the spreadsheet, but not in the same order. Ultimately, I will have a lot more columns in the Excel spreadsheet and the SharePoint list, and they won't be the same (but will have project and due in both files). I will also eventually have more rows (projects).
I'm trying to come up with a Flow that will update the due (dates) for each project. I have a flow, it runs, but updates the "due" column in the List with the "due" date of the last row of the Excel file instead of the row that corresponds to the project.
The flow is manually triggered.
"List rows present in a table" - nothing specified beyond the file/table information
"Get items" from SharePoint list - nothing specified beyond the List name/location
Apply to each
Output from previous steps: Value (Excel)
Nested Apply to Each
Output from previous steps: Value (SharePoint)
Filter array (under nested Apply to Each)
From: Value (SharePoint)
Project (Excel) is equal to Project (SharePoint)
Update Item (also under nested Apply to Each)
ID: ID (SharePoint)
Title: Title (SharePoint)
Project: Project (SharePoint)
Due: Due (Excel)
