Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

update the column of a sharepoint list based on another column

Hello Team,


I have to create a flow which will enable me to update the column of the A SharePoint List based on the column of the B SharePoint List.


We have a SharePoint List where we save the details of the complainants. This list has about 1000 records.



and we have a second SharePoint List where we save the details of the complaint which also has about 1000 records.



What I have to do is to create two new columns in the second SharePoint List with the Forename and Surename and based on the ID of the first sharepoint list the flow to populate the right values under the Forename and Surname columns. In the second list I have the complainant_id column.


Would you be able to help me with this one?


Many Thanks


Community Champion
Community Champion

Can you not just add a Lookup column from List B to List A, and include the ID, Forname and Surname as part of the Lookup column? This way you can select the ID and the Forname and Surname will appear automatically without the need for a flow.


If you want an example let me know - just off to sleep now as past midnight where I am 🙂


If I've answered your question, please mark the post as Solved.

If you like my response, please consider giving it a Thumbs Up.

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

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

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,524)