Showing results for 
Search instead for 
Did you mean: 
Not applicable

Store Filtered Records/Table to a Variable

Hi everyone,

So I have a this table that I use as a data source in my power app.




And I want to filter this table based on the BaggageId. The BaggageId will be selected from a DropDown. So I performed following formula 


Filter('[dbo].[vBaggageHistory]',BaggageId=Dropdown_baggagetracking.Selected.Result && Status=1)


Since this table will be used in multiple points on one screen, I was thinking to store this filter result in a varible, so my app doesnt have to perform filtering every single time. And so I executed this formula


UpdateContext{ varFilteredResult : Filter('[dbo].[vBaggageHistory]',BaggageId=Dropdown_baggagetracking.Selected.Result && Status=1)}


However, in this variable only the value from BaggageId and Status are stored. For other attributes (Id, Message, UTCTimeStamp) the values are not stored (blank). It looks like only the values from the attributes used in filter function conditional expression are stored. Does anyone know how I can store all values from filtered table/record?




 Many Thanks in advance!



Accepted Solutions
Super User
Super User

Do you have explicit column selection turned on in the app's settings?

View solution in original post

Super User
Super User

Do you have explicit column selection turned on in the app's settings?

View solution in original post

Super User III
Super User III

On visible of the screen:
Then filter:
Filter('[dbo].[vBaggageHistory]',BaggageId=Varbaggagetracking&& Status=1)

Not applicable

Indeed this does the trick. Now all attributes values are stored. When I turned this setting off, what kind of effects does it bring for my app?

Explicit column selection speeds up data processing by only including columns that are used in the app. So if a column in your data source is not referenced anywhere, it will ignore it. By turning this option off, all of your data sources will pull down all column values in your app.

Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (5,559)