Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Setting up a SharePoint to update items in a separate list using Power Automate



I have recently been trying to setup an automated system for our computer asset database. So far i have created an online Form which stores results in a SharePoint list automatically when a response is submitted. The next step is getting these results to update a parent list on the same SharePoint where we keep records of who owns what device.


All of our devices have a 5 letter/number combination unique identifier, this means we can easily track who has what and have a regular naming convention. Because of this i would like to automate the process of keeping our records up to date and automatically updating our main database when responses are submitted on the Form.


I have managed to get the Flow to run smoothly but cannot link the unique identifier to the Id section of 'Update Item', selecting ID is not applicable as it only updates what number the entry is in the list. I was wondering if there was an easy way to do this. Any help would be greatly appreciated.




Super User
Super User

Hi, the Update Items connector must have the SharePoint record Id to allow the update to take place. Are you able to add the ID to the When an item is created list? if so you can then use it to update your second list. 

Assuming you have built a custom PowerApps form its probably easier to do what you are doing all in PowerApps when you submit the first item. 



The ID works fine for updating but it does not update the specified item within the main database, instead it updates the record that matches the submission number of the form.


My master list has over 1000 entries and when done using this method the update item will only update based on the latest ID for the Form submission list, what i would like to do is setup a system where it can use one of the responses from the form to lookup the Asset Tag in the master list and update the information associated with this item.


Hope that makes sense.

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,747)