Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Easiest way to update a SharePoint list when an item is created in a different SharePoint list

(0) ShareShare
ReportReport
Posted on by 364

Hi all, 

 

I have a flow that runs when employees request time off. All the requests are added to a SharePoint list which is then connected to Power BI to provide a live calendar view of who is currently off. I am wondering what the easiest way is to update a different list with the total amount of available time off each employee has. The "Time Off" list has one row for each employee, and the "Vacation Request" list has over a thousand. I have seen people suggest using a variable in a Power Automate flow to update the proper row when an item is created, but I'm struggling a little bit figure out where to start. 

 

Aurora_1-1641499079549.pngAurora_2-1641499103924.png

My flow works fine for getting your time off approved or rejected, so I just need to update a Column in the "TIme Off" sharepoint list. Would it make sense to add a column to both lists that collect the users IDs every time they submit a request? My thought being the number of requested hours off would be copied to the other list based on the ID, I'm not sure if there is a better solution or if that will work how I am imagining. 

 

I appreciate any feedback!

  • alaabitar Profile Picture
    alaabitar 1,503 on at
    Re: Easiest way to update a SharePoint list when an item is created in a different SharePoint list

    Hello,

     

    What I would do is just after the request has been approved, I will lookup the record in the Time Off sharepoint list that correspond to the request initiator and then update that list item with CURRENT_TIME_OFF_VALUE - NUMBER_OF_HOURS_TAKEN

     

    Best regards,

    Alaa

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard