web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter gallery with bu...

Power Apps

Unanswered

Filter gallery with button

(0) Share

Report

Report

Posted on by DirkKoch

118

I have a button in Screen1 and by pressing the button I want to filter a gallery in Screen2 by the value "Overdue" in column Status.

OnSelect: Navigate('Gallery') ;; UpdateContext({var:{Status:"Overdue"}})

The gallery items property is as follows:

Items: With({_items: Filter('SPL name'; ComboBox1.Selected.Value="Choose all" || Progress in ComboBox1.SelectedItems)};
Sort(Search(AddColumns(_items; "Column1"; Status); Searchfunction.Text; "Title"; "Number"; "Column1"); Descending))

How can I make the filter work and how to integrate the variable var in the Items property?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DirkKoch
This how you pass the variable on to other screen as it is a local variable

Navigate(Gallery,Fade,{var:{Status:"Overdue"}})

Was this reply helpful? Yes No
DirkKoch 118 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ramole Thanks for the reply.
What I still need to make it work is how to filter the gallery with this value/variable.
I guess I have to adapt the Items property of the gallery as well. But how?

Items: With({_items: Filter('SPL name'; ComboBox1.Selected.Value="Choose all" || Progress in ComboBox1.SelectedItems)};
Sort(Search(AddColumns(_items; "Column1"; Status); Searchfunction.Text; "Title"; "Number"; "Column1"); Descending))

Was this reply helpful? Yes No

Join the conversation