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 III
Super User III

@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

View solution in original post

5 REPLIES 5
RandyHayes
Super User III
Super User III

@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

@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 III
Super User III

@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

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 III
Super User III

@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

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (33,811)