Show linked data from one gallery to another gallery

(0) Share

Report

Posted on by abutler1986

Hi All,

Searched a few posts but can't seem to tie everything together in my brain / app!

I have one gallery which shows data from one of my sharepoint tables and on the OnSelect for each line I want to be able to show data in another gallery based on the line but it needs to look at another sharepoint table and bring that data in.. hope that makes sense?

Gallery 1 = Sharepoint Table A --> Click on Line 1 --> Show Data in Gallery 2 (Table 1 ID = Table 2 ID)

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @abutler1986 ,

You can use the following similar code for your Gallery 2:
Filter( datasource, ID = Gallery1.Selected.ID )

Note: ID is the columnName of your unique ID or any matching columnName

Hope this helps
abutler1986 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the fast response, this is what I currently have on my OnSelect from the Gallery 1.. is this correct or is it missing something?

UpdateContext({ SelectedRecord: ThisItem })
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @abutler1986,

Have you solved your problem?

If you want to display Table 2 in Gallery2 based on Gallery1 Selected ID, please set the Gallery2 Items property as below:

Filter(Table2,ID=SelectedRecord.ID)
abutler1986 19 on at

Like
a
(0)

Report
Copy link

Link copied!

So can you confirm what I should have on my OnSelect on on the line for gallery 1?

Also, for gallery 2 I may need to do a join to another sharepoint table can this be done?
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @abutler1986,

The formula I provided is based on the varibale you set for the Gallery1.

If both gallery 1 and gallery2 share the same ID, I think you just need to filter the Table2 based on the ID selected from the Gallery2.

There is no need to do anything join.

Hope you could try the solution and tell me the error if it does not work.