Answered

How to make a gallery obtaining data from two Sharepoint lists

(0) Share

Report

Posted on by Rob_G

How to make a gallery obtaining data from two Sharepoint lists in the same gallery. All this with its view and edit forms.

For example:

List01

List02

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Rob_G ,

That depends on what relationship the tables have. You need a "common key" (which needs to be 1:1) to lookup the related value in List02 and display it beside the value in List 01 in the gallery. Does this apply to your lists?
Rob_G 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
Yes, this name colums as:
List01: ID1
List02: IDped1
Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Thank2 @Rob_G ,

The syntax is below - note you do not have to call the added column the same name as it is in List2

AddColumns( List01, "YourAddedName1", Lookup( List02, IDPed1=ID1, ).YourList2Name1, "YourAddedName2", Lookup( List02, IDPed1=ID1, ).YourList2Name2 )

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.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Rob_G ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.