Filter items in gallery based on data in another collection

(0) Share

Report

Posted on by Lukas1

190

Hi,

I would like to filter the items in a gallery by a value which is stored in another collection ("Service_Results") than the collection which is shown in the gallery ("Equipments").

I tried this filter, but it does not work:

Filter(
 Equipments; 
 LookUp(Service_Results;ID=Gallery2_3.Selected.ID;Damages)=true 
)

Thanks,

Lukas

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @Lukas1 ,
Assuming the ID of Service_Results is in the Gallery2_3 selected item
Filter( Equipments; LookUp( Service_Results; ID=Gallery2_3.Selected.ID ) )
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.

Was this reply helpful? Yes No
Lukas1 190 on at

Like (0)

Report

Thanks for you reply.

In the collection "Service_Results" I have a column called "Damages" (Boolean). Based on this value (true or false) I want to show the items in the gallery.

It seems to me as if your suggested LookUp-formula is not complete?

Lukas

Was this reply helpful? Yes No
v-siky-msft on at

Like (1)

Report
Hi @Lukas1

What is the relationship between Equipments and Service_Results?
Could you please share more logic about your requirements? In another word, If Damages value is true, what data about Equipments do you want to display?

From the codes, we cannot find any relationship between Equipments and Service_Results. This code is equivalent to

Filter( Equipments; true )

or

Filter( Equipments; flase )

In general, it should have a related column to implement such kind Filter.
Please share more information about your logic implement, so that we can provide further assistance.
Sik

Was this reply helpful? Yes No
Lukas1 190 on at

Like (0)

Report

@v-siky-msft Thanks and yes, the relation is probably missing.

I thought I can do that by having the ID of the Equipments-list as foreign key in the "Service_Results" list:

Equipments:
ID | Name | .....

Service_Results:
Equipment_ID | Damages

My workaround is to have a column "Damages" directly within the Equipments-list.

But I would still be interested how to get a relation to another collection for filtering.

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report
Hi @Lukas1 ,

OK.
What is the kind of data source? SharePoint list, right?
So I assume 'Equipment_ID' column is a lookup column from 'ID' column of Equipments list, right?
Please try this:

Filter( Equipments; LookUp(Service_Results; Equipment_ID.Id = Equipments[@ID] && ID=Gallery2_3.Selected.ID;Damages)=true )

or

Filter( Equipments; LookUp(Service_Results; Equipment_ID.Id = Equipments[@ID];Damages)=true )

Note: the formula is not delegable, so it can only handle a maximum of 2000 records.
Sik

Was this reply helpful? Yes No