Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Updating two different lists after creating an item at one of them

Posted on by 2

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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard