cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Navigate to a Filtered List?

How can I easily have a button on a page that uses Navigate in OnSelect to show a filtered view of a list?  

 

Navigate(BrowseAll,ScreenTransition.None 

      but with a filtered view on the resulting BrowseAll screen

Filter(DataSource,Status="Completed")

 

I can create specific filtered pages to point to, of course, but thinking there must be a better way?

 

Thanks!

Carole

 

14 REPLIES 14
Highlighted
Super User III
Super User III

Hi @CaroleKV ,

Set a Variable on the Navigate depending on what you want to display

Set(vStatus,"Completed");
Navigate(BrowseAll,ScreenTransition.None) 

Your Filter

Filter(DataSource,Status=vStatus)

You can then set vStatus to whatever you need when navigating.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Highlighted
Super User III
Super User III

Please follow these steps:

OnSelect of the Navigation button set a Variable:

Set(MyFilter,"Completed")
 
Then filter as follows:
Filter(Datasource,Status=MyFilter)
 
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
 
Highlighted

Thank you both.  So here is what I've got below.  It doesn't error, but it also doesn't work:

 

OnSelect for my button:

Set(vStatus,"Completed");Navigate(BrowseAll,ScreenTransition.None,Filter(DataSource,Status=vStatus))

 

Thoughts?  

Highlighted

You have put the formulas together.

The first part variable should be on the Navigation button.

The second formula, filter should be on the Gallery Items

Also you have not changed the Datasource to your actual tableName

 

Please follow these steps:

OnSelect of the Navigation button set a Variable:
Set(MyFilter,"Completed")

Then filter as follows:
Filter(Datasource,Status=MyFilter)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Highlighted

Okay so maybe that is my issue - I want the gallery to filter differently depending upon which button is navigating to it - I have 4-5 buttons with different filters for the same data.  I don't want 4-5 galleries to do that.  But is there no way around that?   

Highlighted

Can you show those buttons and the formula on them.
Highlighted

That is what this is, except I did change the names to make it generic...

 

OnSelect for my button:

Set(vStatus,"Completed");Navigate(BrowseAll,ScreenTransition.None,Filter(DataSource,Status=vStatus))

 

I want the user to hit the button, one of several, and it Navigates to a page with a list of records that have been filtered specifically by that button.  By that one click.  That's why I combined them.   I want another button to go to the same page, but filter it differently.  Again with the filter living on the button, activated by OnSelect.  Can I do that?  Maybe not, but it seems pretty logical that I should be able to do so, but just don't know how.  

 

Thanks!! 

Highlighted

Is possible. Just make sure the first one works. Then change variable names. Note the formula from myself and@warrenbelz . Is different from what you have done.
Highlighted

@CaroleKV ,

I will leave you with @eka24 here. We both posted almost the same solution and I have been offline due to time zone.

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (16,405)