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

3 REPLIES 3
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

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (9,263)