Unanswered

Filter Gallery

(0) Share

Report

Posted on by PriscillaB

I am relatively new to PowerApps. I am building and Asset Management App. I have managed to build the most of it; I have Parent/Child Galleries setup to select Assets based on Quadrants> Locations. I am able to select the Asset which takes me to a Detail Form about the asset, I have buttons that Navigate to Reporting Issues and an Issue Log. The Report Button is working fine - I can report issues no problem, which populate my Issue Log (SPlist). When I select issue log the entire list of issues is displayed in a gallery. What I am trying to achieve is filtering this gallery based on the Asset chosen. I'd further like to filter this list by new, assigned, and when fixed not displayed.

What is the correct control coding to achieve this.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Anchov 1,986 on at

Like (0)

Report

You have lots of options to apply filters on galleries. I would recommend watching Reza's video on applying multiple filters on a gallery (it is excellent):
https://www.youtube.com/watch?v=1QflzfPyPe0

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt

Was this reply helpful? Yes No
PriscillaB 52 on at

Like (0)

Report

Unfortunately this was not what I'm looking for. This showcases filtering by user input. What I want is auto filter based on previous screen information.

For example: Maker GW 0179 is displayed in the Asset Detail Form, I want to navigate to the Issue log, but only show issues related to Maker GW 0179, not the entire list of issues

Was this reply helpful? Yes No
Anchov 1,986 on at

Like (0)

Report
If you want to filter based on the selection made in a gallery, follow these steps:

1. Screen One:

In the OnSelect property of the Gallery, set a variable like this:

Navigate(SecondScreen, Transition.None, {varSelectedAsset: gallery1.Selected})

2. Screen Two:

In the Items property of the second Gallery, filter based on the selection:

Filter(IssueList, AssetName = varSelectedAsset.Name)

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt

Was this reply helpful? Yes No
mbarbosa 146 on at

Like (0)

Report
You could use a collection as your Issue Log gallery items.
For that you should use ClearCollect formula on the OnSelect property of your button.
So you can filter your SharePoint list according to the asset selected and only retrieve (in your collection) those lines that match your filter criteria.
It would be something like this:

ClearCollect('A name you want for your collection',Filter('Your SP list name','The column with the asset name'='The variable or control where you have the selected asset name'))

Was this reply helpful? Yes No
PriscillaB 52 on at

Like (0)

Report

I am not navigating from the Asset Gallery. I am navigating from the Detail Form to Issue Gallery

Was this reply helpful? Yes No
PriscillaB 52 on at

Like (0)

Report

I don't believe a Collection is the solution here. I already have the gallery created base on a SP list

Was this reply helpful? Yes No
Anchov 1,986 on at

Like (0)

Report

Same concept applies.

1. Save Asset number as a variable while in your Detail Form

2. Use variable to filter your issue gallery

Was this reply helpful? Yes No
PriscillaB 52 on at

Like (0)

Report

Are you able to help me achieve this? What is the code I required? Is there a simpler option, again I very new too this.

Was this reply helpful? Yes No
Anchov 1,986 on at

Like (0)

Report
Here's a simple example:

On your "Details" page, you have a textbox named 'txtAssetName' for the Asset Name (e.g., "Maker GW 0179").

Also on the "Details" page, you've added a button labeled "Show Issues for this Asset."

In the OnSelect property of the "Show Issues for this Asset" button, you have the following code:

Navigate(AssetIssueScreen, Transition.None, { varAssetName: txtAssetName.Text })

This code allows you to navigate to the "AssetIssueScreen" while passing the value of the 'txtAssetName' textbox as a local variable called named "varAssetName."

On your "AssetIssueScreen," you've set up a gallery to display issues.

In the Items property of the gallery, you can apply a filter based on the variable received from the "Details" page. For example:

Filter(IssuesList, 'Asset Name' = varAssetName);

Here, "IssuesList" represents the data source containing the issues, and "varAssetName" is the variable received from the "Details" page.

Was this reply helpful? Yes No