cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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

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

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 ? 

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

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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (54,115)