web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 1pSc3rWkpQr2yC6aj9RX7i
Power Automate - Building Flows
Answered

How to update an item in a SharePoint list base on the changes from another SharePoint List?

Like (0) ShareShare
ReportReport
Posted on 23 Mar 2018 06:21:31 by 9

HR department is having a list to reocrd the information of every employees (now we call this list as "Employee Profile").

 

On the other hand, HR also requires team leaders to upload the resigination letters to another list as well (we call this list as "Resignation Log").

 

Once HR see that there is a new resignation letter received, she would find out the Employee ID from "Resignation Log", then change the status at "Employee Profile" base on the Employee ID she found.

 

And I would like to know that could we create a flow to modify an item in a list once an item created in another list?

  • skghosh Profile Picture
    2 on 17 Jun 2023 at 12:58:57
    Re: How to update an item in a SharePoint list base on the changes from another SharePoint List?

    Hi,

    I am creating a Leave Request Form in PowerApps, added Power Automate flow. Everything working fine.

     

    Now, I need to update my LeaveBalance List (AppliedLeave Column) with the data from Leave List(TotalDays column) once the Leave is approved.

     

    Presentation1.jpg

    Need your urgent help and advice on this please.

  • Community Power Platform Member Profile Picture
    on 09 Feb 2022 at 17:57:12
    Re: How to update an item in a SharePoint list base on the changes from another SharePoint List?

    Hi there - I just had this happen. Did you ever figure out how to fix this issue?

  • Powerplatform01 Profile Picture
    386 on 27 Jul 2021 at 09:37:28
    Re: How to update an item in a SharePoint list base on the changes from another SharePoint List?

    Hi,

    Please watch

    https://youtu.be/639qnKw85n8

     

    Please like and subscribe this video.I hope it's work for yoh

  • chaule Profile Picture
    on 05 Nov 2020 at 15:48:47
    Re: How to update an item in a SharePoint list base on the changes from another SharePoint List?

    Why do your need the Filter Array step?  Can't you just filter the list right in the Get Items?

  • NicoleOuyang Profile Picture
    14 on 08 Jun 2020 at 03:41:07
    Re: How to update an item in a SharePoint list base on the changes from another SharePoint List?

    Hi Kris,

    Your answer is very helpful. However, I have two more required fileds in the sharepoint "Employee Profile"

    1. User ID: type of this filed is "Single line of text"

    2.Join Date:  type of this field is "Date and Time"

    Could you please share me more how to write the fomular for this two columns in the step "Update Item" (Under the step "Apply to each"). Becauese this two fileds are required to fill in the setting of "Employee Profile".

    Thanks!

  • Community Power Platform Member Profile Picture
    on 01 May 2020 at 10:39:27
    Re: Urgent Query:- When we will changed the lookup column value from PowerApps, is it possible to save the changed data into another SharePoint list using PowerApps ? . Your immediate help would be highly appreciated.
    Hello If the Employee ID is of type 'String' on both the sharepoint, will it work ?
  • Community Power Platform Member Profile Picture
    on 06 Mar 2020 at 18:30:44
    Urgent Query:- When we will changed the lookup column value from PowerApps, is it possible to save the changed data into another SharePoint list using PowerApps ? . Your immediate help would be highly appreciated.
  • Community Power Platform Member Profile Picture
    on 23 Aug 2019 at 15:42:03
    Re: How to update an item in a SharePoint list base on the changes from another SharePoint List?

    HI, 

     

    i am trying to recreate an exact table of yours with very similar situations and objectives, the only difference is my employee ID is not a 4 digit number but instead a code (AA123,AB165) and hence the filter array is unable to locate my employee ID. and suggestions of how to solve this so i can lookup the unique employee ID from the parent list

     

    Thanks!

  • JessBerry Profile Picture
    2 on 18 Mar 2019 at 17:43:26
    Re: How to update an item in a SharePoint list base on the changes from another SharePoint List?

    Hello, 

     

    I have found this information quite helpful however I am havingone issue. The connecttion seems to be set up and working however it is changing the status of all entries in my second list. 

     

    I am creating an acceptance form for students in a program. When a student accepts their seat it should look them up by their Student ID and change their status in my student contact list from perspective to current. However when I test this, it is changing ALL my students on my list to current. 

     

    Any thought on what I might be doing wrong or where to look? 

  • JKat Profile Picture
    25 on 18 Mar 2019 at 02:34:32
    Re: How to update an item in a SharePoint list base on the changes from another SharePoint List?

    x0020 is a space. e.g. the Sharepoint field name would have been "Employee ID", so it becomes 

    Employee_x0020_ID

    If you look at the Sharepoint list via Site Libraries and lists (i.e. open the settings page for tha list), the click on the field as it to edit it, you can see the correct format of the name at the end of the page address.

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete