Display text values from a linked SharePoint lookup column (source) in the gallery

(1) Share

Report

Posted on by I_need_help

Hello,

i have 2 SharePoint Lists.

SharePointList1 has a lookup column (Multiple Choies) to SharePoint List2.

In SharePointList1, for example, the ID "4;7;43 .." is linked to SharePointList2 in the lookup column.

In a Edit Form this is not a problem and works good:

Edit Form

Items

Choices([@Syst_List].PartNumber_with_DESC_(LookUpField))

Edit Form

DefaultSelectedItems

Gallery_Systlist.Selected.PartNumber_with_DESC_(LookUpField)

Issue: I want to display these in the gallery in PowerApps, with

..Gallery_Systlist in Template,

Textlabel.Text= ThisItem.PartNumber_with_DESC_(LookUpField)

also tried..

Textlabel.Text= ThisItem.'PartNumber with DESC (LookUpField)'.Value

Textlabel.Text= ThisItem.'PartNumber with DESC (LookUpField): Title'.Text

its not possible!?

Questions: Do you have any idea how the saved value could be displayed in the Gallery?

Categories:

Building Power Apps

Screenshot 2023-1...

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

M_Ali_SZ365 1,110 on at

Like (2)

Report
Hi @I_need_help ,
To display text values from a SharePoint lookup column in a PowerApps gallery, use the Concat function to turn the table of selected items into a single text string:
Concat(ThisItem.PartNumber_with_DESC_LookUpField, Title & "; ")
Replace Title with the specific field name you want to display from the lookup column.
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali

Was this reply helpful? Yes No
Verified answer

Hassan_SZ_365 542 on at

Like (3)

Report
Hi @I_need_help ,
PartNumber_with_DESC_(LookUpField) is your lookup column, you can use the Concatenate function with LookUp to fetch the correct display values from SharePointList2:

Textlabel.Text = Concat(ThisItem.PartNumber_with_DESC_(LookUpField), Value & "; ")

This formula will concatenate the values from the lookup field into a single string separated by semicolons.
If you want to display a specific property like Title from the lookup, you'd use:

Textlabel.Text = Concat(ThisItem.PartNumber_with_DESC_(LookUpField), Title & "; ")

Make sure you replace Title with the actual field name you want to display from the lookup values.

Best Regards,
Hassan Raza

Was this reply helpful? Yes No
I_need_help 16 on at

Like (0)

Report

Thanks M_Ali_SZ365,
thanks Hassan_SZ_365,

the first formula works straight away:
Textlabel.Text = Concat(ThisItem.PartNumber_with_DESC_(LookUpField), Value & "; ")

@Hassan:
I would also be very interested in the second formula, However, it doesn't work that way.

I think it's because the SharePointList2 cannot be addressed directly.

It might help if I could address the foreign_ID via the lookup column.
I was also able to find these in PowerQuery. But unfortunately it seems to be hidden in PowerApps.

Best Regards,
Helmut

Was this reply helpful? Yes No