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

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (55,271)