Filter Gallery By Ticket Status

(0) Share

Report

Posted on by HubbardInc

122

I have a Ticket Stats Page that has 5 Categories.

All
New
In-Progress
Delayed
Resolved

I want to use a variable or some means of filtering a gallery on another page so that when I click on one of these count items, it will take me to the page and show me the gallery filtered by the type that I clicked on. The picture attached shows how I have my "Items" set for the gallery and also how I have my variable setup. PowerApps FilterGallery.jpg PowerApps FilterGallery2.jpg

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
You can pass a 'context' argument to the Navigate() function in the button's OnClick action. See below:

Navigate(SupportTicketPage,ScreenTransition.None,{ITSupportFilter:"Resolved"})

Then you can reference it on your Support Tickets page like this

Sort(Filter('IT Support Tickets', StatusColumn = ITSupportFilter),Created,Descending)

---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.
HubbardInc 122 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you please help with what I should do if I want the "All" items button to show all items in the list? I can't seem to get my All Button to return all gallery items once I filter by one of the other buttons. I am not sure what to enter for the OnSelect for the all button.
mcastine 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Maybe the ALL Button can just Reset(Gallery) which will take all the filters off
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Use this in the gallery's Items property
If(ITSupportFilter = "All", Sort('IT Support Tickets', Created, Descending), Sort(Filter('IT Support Tickets', StatusColumn = ITSupportFilter),Created,Descending) )
Then pass "All" as the filter the same way you do the other filter values.
HubbardInc 122 on at

Like
a
(0)

Report
Copy link

Link copied!

I haven't been able to get the option working to pass context in the navigate function. Please help.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

That formula looks correct. What does the gallery formula look like?
HubbardInc 122 on at

Like
a
(0)

Report
Copy link

Link copied!

If(ITSupportFilter = "All", Sort('IT Support Tickets', Created, Descending), Sort(Filter('IT Support Tickets', StatusColumn = ITSupportFilter),Created,Descending))
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

What exactly is the problem you're having? Is it detecting the ITSupportFilter variable, but not updating?