cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smoupre
MVP

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
sarafankit
Power Apps
Power Apps

@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
sarafankit
Power Apps
Power Apps

@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

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

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

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

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

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 (61,595)