cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

All items from Datatable

Hi,

 

Does Datatables have the possiblility to do the same as a gallary and get all the items? 

 

A Gallary has the gallary.AllItems method.. How do I do that for a Datatable?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Apps
Power Apps

Re: All items from Datatable

Unfortunately you cannot get the items from a data table at this time; that control is going through some changes and will be updated over the next couple of months, but until then, copying the expression is the only way to go.

View solution in original post

4 REPLIES 4
Highlighted
Power Apps
Power Apps

Re: All items from Datatable

Not at this time (feel free to create a new feature request in the PowerApps Ideas board for that). A workaround that you can use today would be to use the same expression that is used in the Items property of the data table where you would use the 'DataTable1.AllItems' property.

 

For example, if your data table Items property is set to this:

Filter(MyDataSource, Condition)

Then you can have a label with the following text property:

"Total rows: " & CountRows(Filter(MyDataSource, Condition))
Highlighted
Anonymous
Not applicable

Re: All items from Datatable

Thanks, @CarlosFigueira .. I was trying to avoid that because of mye filter function is getting pretty long right now. I am using several dropdown menues to filter the values in the table.. Should it not be possible to create some kind of loop over the datatable, and just collect all the data and return it as a Table ? 

Highlighted
Power Apps
Power Apps

Re: All items from Datatable

Unfortunately you cannot get the items from a data table at this time; that control is going through some changes and will be updated over the next couple of months, but until then, copying the expression is the only way to go.

View solution in original post

Highlighted
Advocate II
Advocate II

Re: All items from Datatable

Hi, @CarlosFigueira. Are there still any plans to make changes to the DataTable so that we can access the items through a reference such as DataTable.AllItems?

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,413)