Unanswered

Filter Gallery based on ThisItem. Created by from another gallery

(0) Share

Report

Posted on by Community Power Pla...

Hello,

i want to filter a gallery based on a selected 2nd gallery. The filtered gallery should only show the current selected.'Created by' items from the first gallery.

A example:

Gallery 1 selected 'Created by' = Sam Samuel

Gallery 2 only show filtered items "Sam Samuel"

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Kosenurm 802 on at

Like (0)

Report

Hi,

I would approach this by creating collections of the data you want to filter, and then using the collections as the Items for the galleries, and apply your filters to the collections.

Let me know if you'd like to see an example as I am doing similar in a canvas app at the moment.

K.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello, yes ofc i highly appreciate any ideas how to solve this!

Thank You,
T.

Was this reply helpful? Yes No
Kosenurm 802 on at

Like (0)

Report

So, in my case, I am creating a collection from previously input values by the user into the app on load of the below screen.

The first gallery is filtering this collection as below

The second gallery which, in my case, is hidden from the user, is filtering the same collection to other parameters.

What you could do is get all your data into a collection OnVisible of the page where your galleries are, and then apply your filters to the collections in the galleries as above.

Thanks

K.

Was this reply helpful? Yes No
Verified answer

Sanshubh 512 on at

Like (0)

Report
@Anonymous
write this on gallary2's Item Property

Filter(Datasource,Gallery1.Selected."Created by".Email="Created by".Email)

Write Table/List name at datasource.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

i used this formula before but it shows all entries to me...thats the reason why im asking here...

Sort(Filter(colTableRequests, Requ_Gallery.Selected.'Created By' = 'Created By'), ID, Descending)

Was this reply helpful? Yes No
Verified answer

Sanshubh 512 on at

Like (0)

Report

Now check this.
This is working Bro.
Did you select any item from gallery1??

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Got it!

i used this formula.

Filter(colTableRequests, Requ_Gallery.Selected.'Erstellt von'.'Vollständiger Name' ='Erstellt von'.'Vollständiger Name')

Was this reply helpful? Yes No
Sanshubh 512 on at

Like (0)

Report

Yes bro 🤙

Was this reply helpful? Yes No