Not able to filter Gallery using Collection

(0) Share

Report

Posted on by StormCrafter

Hello!

I have a problem filtering my Gallery.

I use this Table to demonstrate the idea of what i am trying to achieve ( i don't have this Table build, but i am considering building it if i can't solve this problem otherwise). I have 100 sections, so building this kind of table takes a lot of effort.

Basically what i want to do is to filter Section -column by using Group -column values and show filtered values in gallery.

SectionNameBegins -column is only there for helping in mapping Section and Group -columns together.

Section	SectionNameBegins	Group
F1	F	S
F2	F	S
F3	F	S
G1	G	S
G2	G	S
G3	G	S
...	...	S
K1	K	K
K2	K	K
B1	B	B
B2	B	B
...	...	...

Section -column data comes from SQL-table and i have added SectionNameBegins -column to that table using AddColumn and Left functions in Gallery - Items properties.

Then i have a Collection with two columns:

I have a drop down that uses values from Collection - Group column.

For example when i choose "S" from drop down, i want the gallery show all records that has Section values "F1","F2","F3","G1",G2",G3".. and so on.

I have googled this around and tried multiple ways to solve this, but i can't put this together..

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

RJM07 801 on at

Like
a
(0)

Report
Copy link

Link copied!
You shouldn't even need the collections.
In the Items section of the Gallery do
Filter(TableName,Group=Dropdown1.SelectedText)

Was this reply helpful? Yes No
StormCrafter 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@RJM07I'm sorry if i my post was unclear, but i don't have the Group information anywhere else than in my collection. I'm trying to avoid adding new Group -column to that table since i have over 100 records in it. If i had that column, in that i case your solution would work.

Was this reply helpful? Yes No
RJM07 801 on at

Like
a
(0)

Report
Copy link

Link copied!

Oh I see! So you're trying to get the dropdown to identify which collection to use... correct?

Was this reply helpful? Yes No
RJM07 801 on at

Like
a
(0)

Report
Copy link

Link copied!
Or if it's just the one collection that you're using then surely that would still work, just adjust it for the collection

Filter(CollectionName,Group=Dropdown1.SelectedText)

Was this reply helpful? Yes No
StormCrafter 4 on at

Like
a
(0)

Report
Copy link

Link copied!
I have Table with Section Column that can have values F1,F2,G1,G2..
I use that Table to show records in Gallery.

Wanted Feature
Selecting "S" from drop down the Gallery shows records with Section F1,F2,G1,G2,H1,H2...
Or if i choose "K" from drop down the Gallery shows records with Section K1,K2,K3...

Problem
My Table has only Section column associated to this problem, so how can i achieve such a filter?
I want to filter my Table but there are no information about groups.
For that purpose i made Collection shown in original post. I want to leverage that collection to achieve this kind of filtering.

The last row of this code don't work, but hopefully it clarifies the idea.
In the Items section of the Gallery i have this:

Filter( AddColumns( Filter( TABLE1, AREACODE = 12345, WORKERCOUNT <> 0 ), "SectionNameBegins", Left(SECTION,1) ), SectionNameBegins = Collection1.SectionNameBegins.Value && Dropdown1.SelectedText.Value = Collection1.Group )

Don't mind the AREACODE and WORKCOUNT filter they are not related to this problem.

Was this reply helpful? Yes No