cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShangKer
Helper I
Helper I

Select value from two list which is the same

Hi, i have would like to pull value from another list. My main list has a column name DIV/DEPT which is corresponding to the second list "Department". The DIV/DEPT and "Department" got the same value. In the department contains the details for the department. Is it possible to pull the department details when the value in DIV/DEPT is the same as "Department"? As attached are my sharepoint list.

Sharepoint1.PNG
List 1: Contains the value input by the user. Data type are single lines of text.
Sharepoint2.PNG
List 2 which is same as the one in list 1.

Sharepoint3.PNG
I would like to put the admin name to the list 1. I have tried to use lookup column but nothing shown. 
10 REPLIES 10

Ouh I see where my errors are now thanks.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,012)