Answered

Joining 2 data source but different structures

(0) Share

Report

Posted on by WydaPBI

Hi expert,

I have question. Is it possible to join 2 SharePoint Lists in 1 gallery where they share same ID but different structures. Say for example:

List A: ID, Name, Start Date, End Date, Remarks, Status

List B: ID, Name, Description, Type

If possible, may I know how?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 154,924 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @WydaPBI ,

Items of the Gallery

AddColumns, ListA, "Description", LookUp( ListB As _B, _B.ID = ID ).Description, "Type", LookUp( ListB As _B, _B.ID = ID ).Type )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WydaPBI 51 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz

I managed to get it work however I there is some warning even though the data does shows in the gallery. The warning as below:
How to solve it ya?

Was this reply helpful? Yes No
WarrenBelz 154,924 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@WydaPBI ,

That is correct - it is not Delegable and you cannot make it so.

Was this reply helpful? Yes No