How to filter and show two sharepoint lists on one screen?

[Greta1]

Hello all,

since I received such good help here earlier, I would like to ask you another question.

I have two Sharepoint lists that I want to show combined on one screen (after using a filter first).

My filter is a date picker: 

I am filtering the first Gallery as follows and it works perfectly: 

Filter(Table_1,
(Created>= dteStartDate.SelectedDate
Or IsBlank(dteStartDate.SelectedDate)
)
And
(Created< DateAdd(dteEndDate.SelectedDate, 1, Days)
Or IsBlank(dteEndDate.SelectedDate)
)
)

Now I would like to have my second sharepoint list filtered in the same way and it is only supposed to show the "status of requests" in the orange button field (Under Items I have put here: ThisItem.Status.Value). I am filtering the second gallery in the same way like gallery one, just with the difference that I am using Table_2 as the data source).

The problem is, that it shows me ALL the status for each table row, instead of one status per row that is supposed to fit the items in Sharepoint List 1. So this is how the big gallery (Sharepoint List 1) and the small one (only the orange buttons, Sharepoint List 2) look like:

With the orange Buttons (Status field from Sharepoint List 2) showing multiple times:

How can I fit these two lists together, so that the right status for each row is shown?

I hope it is somehow clear what my issue is. 

Thank you so much in advance!

Greetings 

[BCBuizer]

Hi @Greta1 ,

In any scenario when using a nested gallery, the Items property should include a filter that relates to ThisItem (of the parent gallery):

NestedGallery.Items = Filter(YourChildList, ParentID = ThisItem.ID)

In the above example the items in YourChildList (in your scenario Table_2) are filtered by their reference to the parent list (in your case Table_1): ParentID

Can you please share which column in Table_2 holds the reference to Table_1 and which column in Table_1 it refers to?

[Greta1]

Hey BCBuizer,

thank you so much for your reply! Thats my problem, I don't have a ParentID that is the same for Table 1 and 2. Basically the entries from Table 1 are written into Table 2 automatically (through Power Automate), but they have different ID's. Do you know if there is any other way to link the lists? 

[BCBuizer]

Hi @Greta1 ,

Yes, by adding a column ParentID to Table_2 and have power automate populate that automatically as well.

[Greta1]

Thank you so much! I did that now. So I have my column "ID" in Table_1 that is automatically copied to the corresponding column in Table_2 called "ID_unique". 

I tried the code: 

NestedGallery.Items = Filter(Table_2, ID = ThisItem.ID_unique)

But it's not working, it doesn't recognise "ID_unique" and it is not showing me the orange Buttons with the Status value anymore. What am I doing wrong?  

[BCBuizer · Accepted solution]

Hi @Greta1,

Try swapping the attributes:

NestedGallery.Items = Filter(Table_2, ID_unique = ThisItem.ID)

ThisItem.XYZ will refer to Table_1 as it is the data source for the parent gallery, hence it will not recognise ID_Unique.

Also make sure you have refreshed your connector for Table_2 in the PowerApps studio to have any changes, like a newly added column, reflected.

[Greta1]

@BCBuizer it worked now, thank you very much!