Working with SharePoint LookUp Columns

(0) Share

Report

Posted on by DustinB

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.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @DustinB ,

Could you tell me:
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

2\ Modify lookup field ‘ItemID’ in ‘Main’ list()

// Click the fields you want

3\ This is my ‘Main’ list

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:

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
DustinB 71 on at

Like
a
(0)

Report
Copy link

Link copied!

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.