Power Platform Community Forum Thread Details

Hello everybody. Is there a way to filter a gallery in its lookuped values?

Gallery.Items = tabVertrag

Vertrag has a Projekt Id, Projekt as a Kunde ID.

In order to get the projekt name, i would use this formula

Text = LookUp(tabProjekt; ThisItem.ProjektID=Projekt_ID; Projektname)

In order to get the Kunde name this one:

Text = LookUp(tabKunde; LookUp(tabProjekt; ThisItem.ProjektID=Projekt_ID; KundeID)=Kunde_ID; Kundename)

I also tryed this formula but unfortunately "ThisItem" is not being recognized there and as it seems ever "." is not allowed.

Gallery.Items = Filter(
tabVertrag,
LookUp(tabProjekt, ThisItem.ProjektID = Projekt_ID).Projektname = TextInputProjekt.Text &&
LookUp(tabKunde, LookUp(tabProjekt, ThisItem.ProjektID = Projekt_ID).KundeID = Kunde_ID).Kundename = TextInputKunde.Text
)

Thank yout in advance.

Categories:

Building Power Apps

Hi @RPowerAutomated, the problem here is that ThisItem is only valid inside the gallery so you can't use it on your Items property. We first need to add the extra columns and then search on them.

Try this, I hope I have understood your code properly:

// Gallery.Items

// Filter where your search matches either the projekt or kunde names
Filter(

 // Add columns with projekt and kunde names fron the project record
 AddColumns(

 // Add a column to tabVertrag and look up the project record
 AddColumns( 
 tabVertrag,
 "projekt_record", LookUp( tabProjekt, ProjektID = Projekt_ID)
 ),

 "projekt_name", projekt_record.Projektname
 "Kunde_name", LookUp( tabKunde, KundeID = projekt_record.Kunde_ID).Kundename
 ),

 projekt_name = TextInputProjekt.Text || Kunde_name = TextInputProjekt.Text
)