Filter for Label in Gallery

(0) Share

Report

Posted on by mglemser

Hi everyone,

Is there a way to filter a gallery based of labels in the gallery rows?

I have a more complicated label (not just ThisItem.XXX) and I would like to add a filter field to filter the gallery for that label.

Thanks,

Makena

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

WarrenBelz 153,032 Most Valuable Professional on at

Like (0)

Report

Hi @mglemser ,

You would need to use the same formula as the label in the Filter - you cannot filter a gallery on itself (it creates a circular reference)

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
mglemser 82 on at

Like (0)

Report

Hi WarrenBelz,
My gallery uses a GroupBy function. The items code for the gallery is:
GroupBy(Table13,"CO Number","CO State","Change Owner Name","DATA")

In the gallery rows, I have a label with the text:
Concat( Distinct( ThisItem.DATA, 'Affected Item Name' ), Result & "; " )

How would I filter the gallery for 'Affected Item Name"? I tried the following but it did not work:
Filter(GroupBy(Table13,"CO Number","CO State","Change Owner Name","DATA"),Or(IsBlank(txtImpactedDoc),txtImpactedDoc.Text in DATA.'Affected Item Name'))

Was this reply helpful? Yes No
PaulD1 2,914 on at

Like (0)

Report

What is the datasource? If you are using SQL I would perform the data transformation in Views which will make the filtering much simpler.
Note that GroupBy and Distinct are not delegable (unless these have been updated in Dataverse) so processing this client-side (in the Power App) will be slow and may not give the correct results if your data set is ever likely to exceed the delegable limit (500 to 2000 rows).

Was this reply helpful? Yes No
mglemser 82 on at

Like (0)

Report

My datasource is an Excel file (also not delegable).

Was this reply helpful? Yes No