cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smoupre
Level: Powered On

Getting SharePoint Lookup Column to display values

Newly discovering PowerApp. I have 2 SharePoint lists:

 

Skills

Skills Lookup

 

Skills Lookup has a single column, "Title"

 

Skills has 4 columns:

  • Title
  • Skill (a Lookup to "Skills Lookup" list)
  • YearsExperience
  • LastYearUsed

Created a PowerApp by going to Skills list and clicking "PowerApp" from the menu. This takes me to the web-based PowerApp editor. The PowerApp created works beautifully except for two things.

 

First, the BrowseGallery control does not provide the option to display "Skill" lookup column.

 

Second, the EditForm control displays the "Skill" lookup column, and it displays the right number of items in the drop down but the values I can choose all say:

  • #Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference

Any advice on how to get the BrowseGallery to display the Skill information or a work-a-round would be great but even better if someone can tell me how to get the "Title" field information from the Skill Lookup list to display instead of the #Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference text.

 

1 ACCEPTED SOLUTION

Accepted Solutions
PowerApps Staff sarafankit
PowerApps Staff

Re: Getting SharePoint Lookup Column to display values

@smoupre  - glad to hear that you liked what you have experienced till now. The two issues you ran into are things which we are aware of and have not been able to simplify just yet.

 

For the BrowseGallery issue:

  1. Add a text box to gallery by following step 1 & 2 here: https://powerapps.microsoft.com/en-us/tutorials/add-gallery/#add-a-control-to-the-gallery
  2. Now, using the formula bar, set the Text property of the text box to ThisItem.Skill.Value

You should have the value available in the BrowseGallery now.

 

For the Edit Form & the Display Form:

  1. Select the Form on the screen
  2. Select the Skill column/field on the right side panel
  3. Click the ... icon for the Skill column/field
  4. Change the Value dropdown from @odata.type to Value

 

image.png 

 You should have the forms displaying the skills properly now.

View solution in original post

4 REPLIES 4
PowerApps Staff sarafankit
PowerApps Staff

Re: Getting SharePoint Lookup Column to display values

@smoupre  - glad to hear that you liked what you have experienced till now. The two issues you ran into are things which we are aware of and have not been able to simplify just yet.

 

For the BrowseGallery issue:

  1. Add a text box to gallery by following step 1 & 2 here: https://powerapps.microsoft.com/en-us/tutorials/add-gallery/#add-a-control-to-the-gallery
  2. Now, using the formula bar, set the Text property of the text box to ThisItem.Skill.Value

You should have the value available in the BrowseGallery now.

 

For the Edit Form & the Display Form:

  1. Select the Form on the screen
  2. Select the Skill column/field on the right side panel
  3. Click the ... icon for the Skill column/field
  4. Change the Value dropdown from @odata.type to Value

 

image.png 

 You should have the forms displaying the skills properly now.

View solution in original post

smoupre
Level: Powered On

Re: Getting SharePoint Lookup Column to display values

Easy peasy, thanks for the assist!

 

One item of feedback, I had found the @data.type setting but it looked greyed out so I didn't think I could change it. Duh, I should have learned by now to just click on stuff just to see. But, a visual cue of having that drop down box be white would be a good thing I think.

 

Thanks again, this stuff is awesome!!

PowerApps Staff sarafankit
PowerApps Staff

Re: Getting SharePoint Lookup Column to display values

Thanks for the feedback on the grey color, we will look at it again.

Highlighted
Hateauthenticat
Level: Powered On

Re: Getting SharePoint Lookup Column to display values

I followed these instructions to show the 'value' of the lookup on the screen and it was working wonderfullly or me in my app through several iterations, then suddenly it started showing # signs between the values. What happened?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,520)