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
Power Apps Staff CarlosFigueira
Power Apps Staff

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
Power Apps Staff CarlosFigueira
Power Apps Staff

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))
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 ? 

Power Apps Staff CarlosFigueira
Power Apps Staff

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
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,797)