cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Earl20
Helper III
Helper III

Pull info from columns in one SharePoint list to another based on common key

I have 1 list (titled employee and budget) that has employee names and their dept budget code. I have a separate list (titled budget and dept) that was an excel spreadsheet imported as a list that contains each budget code, the department name, and sub department names. I want to be able to add the department and sub department info  from the budget and dept list into the employee and budget list based on a match of the employee budget code

 

to illustrate :

 

employee and budget list 

Name:James Smith

Code 1234

 

Budget and dept list

Code: 1234

Dept. HR

Sub dept. Harassement

 

I want  the end result on   the employee and budget list  to be

Name:James smith

Code:1234

Dept. HR

Sub dept. Harassement

 

please let me know if i need to explain it better

 

thank you in advance

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @Earl20 

According to your description,you want to update the items in employee and budget list according to Budget and dept list.

I set up a simple flow,you can take a try with the following screenshots to see if it helps.

Here are my two lists

vLilyWmsft_1-1631610335782.pngvLilyWmsft_2-1631610343523.png

Flow in details:

vLilyWmsft_0-1631610261883.png

vLilyWmsft_5-1631610504562.png
vLilyWmsft_4-1631610474650.png

After flow runs,the employee and budget list will be updated as below:

vLilyWmsft_8-1631610720658.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-LilyW-msft
Community Support
Community Support

Hi @Earl20 

According to your description,you want to update the items in employee and budget list according to Budget and dept list.

I set up a simple flow,you can take a try with the following screenshots to see if it helps.

Here are my two lists

vLilyWmsft_1-1631610335782.pngvLilyWmsft_2-1631610343523.png

Flow in details:

vLilyWmsft_0-1631610261883.png

vLilyWmsft_5-1631610504562.png
vLilyWmsft_4-1631610474650.png

After flow runs,the employee and budget list will be updated as below:

vLilyWmsft_8-1631610720658.png

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,438)