How to use labels to show data in gallery from multiple SharePoint list?

(0) Share

Report

Posted on by praeclarus

Hi, I've build a few SharePoint lists I'm having a problem, I don't know how to fix it.

In a gallery I need to display data from different SharePoint lists, the two lists in the picture.

I'd like to show salecode from tbl_insurance in LB1 and show salename in LB2 in the same Gallery.

Any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (2)

Report
Hi @praeclarus ,

The second label would have the Text

LookUp( YourSecondListName, salecode=ThisItem.salecode ).salename

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
praeclarus 34 on at

Like (0)

Report

I connect the gallery with table : tbl_mas_salegents and type the coding in label Text follow this picture below but the data is not show. I’m not sure what’s my mistake. 🥺

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report

Hi @praeclarus ,

According to the list structure you posted, if the salecode in the second list matches the one in the current record, that code will the field specified from the second list. I see you have card_number rather than salename. Put another label in the gallery with ThisItem.salecode and then look at the value there, go to your second list, look for the same value and see if there is a card_number on the record.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
praeclarus 34 on at

Like (0)

Report

It's work! Thank you for share your knowledge and kindness.😄

Was this reply helpful? Yes No