I have two SharePoint lists: "Departures" and "Contracts." After creating an item in the "Departures" list, which includes a "Person" type field, I want the flow to verify whether the person added to the "Departures" list is present in the "Contracts" list. If so, it should:
- Update their departure date (from the "Departures" list) in the "Contracts" list.
- Change their status to "To settle."
- In the "Departures" list, mark the "Contract" column as 'Yes.'
- Send an email notification.
Currently, when adding an item to the "Departures" list, the flow incorrectly identifies the employee and updates almost all items in the "Contracts" list. Where might the issue lie?


Report
All responses (
Answers (