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
PowerApps Staff CarlosFigueira
PowerApps 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.

3 REPLIES 3
PowerApps Staff CarlosFigueira
PowerApps 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 ? 

PowerApps Staff CarlosFigueira
PowerApps 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.

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 432 members 5,311 guests
Please welcome our newest community members: