cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lmauriceparker
Level: Powered On

Filter Data in Data table

What is the best approach to filter data within a DataTable (not datacard)?

I have a SharePoint List with over 3000 rows, but I just need to filter the data using one field.

5 REPLIES 5
Community Support Team
Community Support Team

Re: Filter Data in Data table

Hi lmauriceparker,

 

We can use filter function finds records in a table that satisfy a formula. About Filter function, please check this documentation.
https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/

 

On a Gallery control, we can set the Items property of the Gallery as Filter( Table, Formula1 [, Formula2, ... ] ).

 

Say I have an app based on SharePoint list Assets, on the Gallery control, I set the Items property of the Gallery as Filter(Assets,TextSearchBox1.Text in Title).Title.


Then when I enter an value in the Text input, the related Title will be filtered.

3.PNG


Please feel free post back with more details of your scenario if you need more help.

 

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dcurran12
Level: Powered On

Re: Filter Data in Data table

Is there a way to filter a second data table based on the selected row in the first data table?

 

As example, I have

 

Table1:  ProjectTable

with columns Project Name, Project Manager

 

Table 2:  ProjectBudget

with columns Project Name, Project Budget Name, Total Budget

 

In Table 2, there can be several different budgets for each project.  I want to display a filtered list of Table 2 based on what was selected in Table 1.

 

Thanks,

Dave

 

The Tables are all in Sharepoint Online if that matters...

 

 

 

 

 

Dawidvh
Level 10

Re: Filter Data in Data table

Hi Dcurran12,

 

I am not sure if you came right with this, but if not, yes you can absolutely filter a second gallery based on the selection of the first.

 

The second gallery will have Filter(table2, gallery1.selected.project name=Project Name)

 

Let me know if you don't come right.

 

Have a great day.

nmarri
Level: Powered On

Re: Filter Data in Data table

is there a way to do with data table instead of gallery.I have a data table.

Super User
Super User

Re: Filter Data in Data table

@nmarri  Yes, just set your Items with the filter as suggested.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,916)