cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DevadathanK
Advocate I
Advocate I

Displaying a value from one list in another lists browse gallery

Hi Community!

 

I am stuck trying to implement this feature in PowerApps. Let me explain the issue,

I have two SharePoint Lists that are added as sources in PowerApps, the lists are as follows -

 

List 1

List 1.PNG

 

List 2 - Academic Details (The Student ID column is a LookUp column taken from List 1 )

List 2 b.jpg

 

This is the Browse Gallery of List 2

App 2.jpg

 

Now what i am trying to display the name of the Student instead of the Student ID, like so

1.PNG

 I tried to do it by using the following code in Subtitle1's item input, but it does not work.

 

Distinct(Filter('Student Details','Student ID'=ThisItem.'Student ID'.Value),Text('Student Name'.DisplayName))
LookUp('Student Details','Student ID'=ThisItem.'Student ID'.Value)

 

 

Can you please help me solve this issue? I'm totally stuck!

 

Thanks for any help!

 

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

The second formula is close;

LookUp('Student Details','Student ID'=ThisItem.'Student ID', 'Student Name')

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

2 REPLIES 2
eka24
Super User
Super User

The second formula is close;

LookUp('Student Details','Student ID'=ThisItem.'Student ID', 'Student Name')

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

amitchandak
Helper III
Helper III

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
Top Kudoed Authors
Users online (1,920)