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

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

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

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 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

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 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

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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,233)