Emad's Blog

Let’s Say you have 2 SharePoint Lists

ParentList

-ID
-Name
-Details

ChildList

-ID
-ParentID
-Comment

Assume you want to display a list of comments with the name of the associated Name from the Parent List in a gallery

Set the Gallery Items to

AddColumns(
    'ChildList',
    "ParentInfo",
    Lookup(
        ParentList,
        ID='ChildList'[@ParentID]
     )
)

This way, in the Gallery, for each row you will find a new field of type record named “ParentInfo”. so you can add columns as ‘ParentInfo’.Name