cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DustinB
Advocate I
Advocate I

Working with SharePoint LookUp Columns

Hi everyone,

 

Szenario:

I have two SharePoint Lists for my inventory. The "main" list displays my complete inventory. One column of this list, is a lookup column, to the second list, where I listed every single Item.

As an example I want to capture a new object. In the main list I now enter subjective properties, like condition or evaluation. With the help of the lookup column I tell which object it is and meta data like weight, category and image are "loaded" into the other list. (see graphic)
Technically, the lookup columns are only displayed, so PowerApps has its problems...

 

Question:
How can I display and work with the fields created by the lookup column in PowerApps?

As an example, I want to display the images of the element that is "connected" to the entry "connected" via LookUp in a gallery
Picture.Image = ThisItem. 'ItemID:Thumbnail

I always get the following error message:
This formula uses a range. This is currently not supported for evaluation.

 

I tried workaround with LookUp and Filterfunctions, but without success.

 

P.S.: It's not the image or something similar, simple text output like the category of the element will give the same error.

DustinB_0-1606117947764.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @DustinB ,

 

Could you tell me:

  1. Do you want to display the values of fields in Item list through the lookup field in Main list?

 

If so, the key is to add columns to show additional fields when modifying the lookup field.

I've made a test for your reference:

1\ This is my Item list

v-xiaochen-msft_0-1606211062986.png

 

2\ Modify lookup field ItemIDin ‘Main’ list()

v-xiaochen-msft_1-1606211063001.png

 

v-xiaochen-msft_2-1606211063002.png

 

//   Click the fields you want

 

3\ This is my Main list

v-xiaochen-msft_3-1606211063034.jpeg

 

 

4\ Add a blank gallery control to screen and set its Items property to:

Main

 

5\ Insert a label control into the gallery and set its Text property to:

ThisItem.ItemID.Value

 

6\ Insert a label control into the gallery and set its Text property to:

ThisItem.'ItemID:Weight'.Value

 

7\ Insert a label control into the gallery and set its Text property to:

ThisItem.'ItemID:Category'.Value

 

8\ The result is as follows:

v-xiaochen-msft_4-1606211063036.png

 

If my guess is wrong, please tell me your needs in more detail, and I will be happy to solve the problem for you.

 

Best Regards,

Wearsky

View solution in original post

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

Hi @DustinB ,

 

Could you tell me:

  1. Do you want to display the values of fields in Item list through the lookup field in Main list?

 

If so, the key is to add columns to show additional fields when modifying the lookup field.

I've made a test for your reference:

1\ This is my Item list

v-xiaochen-msft_0-1606211062986.png

 

2\ Modify lookup field ItemIDin ‘Main’ list()

v-xiaochen-msft_1-1606211063001.png

 

v-xiaochen-msft_2-1606211063002.png

 

//   Click the fields you want

 

3\ This is my Main list

v-xiaochen-msft_3-1606211063034.jpeg

 

 

4\ Add a blank gallery control to screen and set its Items property to:

Main

 

5\ Insert a label control into the gallery and set its Text property to:

ThisItem.ItemID.Value

 

6\ Insert a label control into the gallery and set its Text property to:

ThisItem.'ItemID:Weight'.Value

 

7\ Insert a label control into the gallery and set its Text property to:

ThisItem.'ItemID:Category'.Value

 

8\ The result is as follows:

v-xiaochen-msft_4-1606211063036.png

 

If my guess is wrong, please tell me your needs in more detail, and I will be happy to solve the problem for you.

 

Best Regards,

Wearsky

View solution in original post

Hi @v-xiaochen-msft ,

 

thank you so much for helping me 🙂 Now it works, thanks

It took me so long and I tried "everything" and all I was missing was the .value after my function.

Anyway, thank you for your detailed answer, it will certainly help someone else who sees the post.

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

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (26,919)