cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brett304
New Member

Power Apps SharePoint LookUp

Hello, 

 

Fairly new to Power Apps and struggling with something that I think should be fairly easy and common.  

 

I have two SharePoint lists. 

Review and Eligibility

 

Review has a lookup column that looks up P-Number from the Eligibility list. 

I created a Canvass app and connected both lists to the app. 

 

On the Canvass app New/Edit form I'm using the P-Number Lookup field from my Review list.  I'd like to have a label, text input, or a custom data card that displays Name based on value selected in the P-Number drop down. 

 

When I brought the lookup column into SharePoint I also brought name but adding it to the New Form doesn't help.  It remains blank. 

 

This forum and Shane are my main sources.  I've read several posts and watched PowerApps SharePoint LookUp Column - YouTube but still unable to get it working.  

 

Premise:  Pick a P-Number value from a SharePoint lookup dropdown menu and display its associated name while the user is editing/entering data into the form.

 

Any thoughts, or recommendations on what I should be looking at? 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@Brett304 

So, the Choices function will strip out all of the relevant record information except the Id and Value of the Lookup results.

So, for your Label Text property:

   LookUp(Eligibility, ID = yourP-NumberDropdown.Selected.Id, nameColumn)

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

5 REPLIES 5
RandyHayes
Super User
Super User

@Brett304 

What is the Items property of your dropdown?  Depending on that formula, you can derive the value from that.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

@RandyHayes , Thanks Randy, the items property on P-Number is Choices([@'CWBG Review Form'].P_x002d_Number)  CWBG Review Form is the SharePoint list.  PNumber (yuck spaces) is a lookup column in the review list. 

RandyHayes
Super User
Super User

@Brett304 

So, the Choices function will strip out all of the relevant record information except the Id and Value of the Lookup results.

So, for your Label Text property:

   LookUp(Eligibility, ID = yourP-NumberDropdown.Selected.Id, nameColumn)

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

@RandyHayes I owe you a tasty beverage of your choice!  You are a gentleman and a scholar.  

 

I had to tweak it a little but I got it to work:  

LookUp(CWBGEligibleLkup,ID=DataCardValue40.Selected.Id, Name)

RandyHayes
Super User
Super User

@Brett304 

Yes, I intended for you to substitute in the proper names as used in your app...so, you did the right thing!

I will always gladly enjoy a tasty beverage!!  And otherwise, just glad to help!

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

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 (3,209)