Answered

How do i display only elements with the same name?

(1) Share

Report

Posted on by eatalay

I have two galleries. The first one prints rows of the same names once. Like the first attachment. And this is my first galleries code line:

AddColumns(GroupBy(SortByColumns(Search([@Inventory]; TextSearchBox1.Text; "Malzeme_x0020_Ne_x003f_"; "Tesisteki_x0020_Yeri"); "Malzeme_x0020_Ne_x003f_"; SortOrder.Ascending);"Malzeme_x0020_Ne_x003f_"; "groupedByTitle"); "RecordCount"; CountRows(groupedByTitle))

In the second gallery, when i click on aluminum i just want all aluminum to be sorted, when i click on ceramic i only want all ceramics to be sorted. How can i do it?

The second attachment is my second gallery. I only use some sorting code in my second gallery like this:

SortByColumns(Search([@Inventory]; TextSearchBox1.Text; "Malzeme_x0020_Ne_x003f_"; "Tesisteki_x0020_Yeri"); "Malzeme_x0020_Ne_x003f_"; SortOrder.Ascending)

When i click on the first gallery i make the second one visible.

Thank you.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@eatalay

To achieve what you're trying to do, you may want to set the Items property of the second gallery based on the selected item in the first gallery.

This way, when an item (like 'Aluminum' or 'Ceramic') is selected in the first gallery, then the second gallery can update to show only items that match the selection.

Here is a formula you can use for the Items property of your second gallery:

Filter( [@Inventory], Malzeme_x0020_Ne_x003f_ = Gallery1.Selected.Malzeme_x0020_Ne_x003f_ )

In this formula, [@Inventory] is your data source, Malzeme_x0020_Ne_x003f_ is the column you want to filter by, Gallery1 is the name of your first gallery (replace it with the actual name if different), and Selected.Malzeme_x0020_Ne_x003f_ is the value selected in the first gallery.

This formula filters the [@Inventory] data source by the Malzeme_x0020_Ne_x003f_ column, and only shows the rows in the second gallery where Malzeme_x0020_Ne_x003f_ matches the Malzeme_x0020_Ne_x003f_ of the selected item in the first gallery.

Remember to replace Gallery1 and Malzeme_x0020_Ne_x003f_ with your actual gallery name and column name if they are different.

See if it helps @eatalay
eatalay 21 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you very much 🙂