cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hotely
Frequent Visitor

ClearCollect only few columns from Azure SQL Table

Hello,

 

I want to create a Collection of only few columns from a SQL Azure Table, how can i accomplish this?

 

Thanks

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Meneghino Community Champion
Community Champion

Re: ClearCollect only few columns from Azure SQL Table

Hi @hotely, use the ShowColumns function.

 

 

ClearCollect(MyCollection, ShowColumns(MyAzureTable, "ColumnA", etc. etc. ))

View solution in original post

5 REPLIES 5
Meneghino Community Champion
Community Champion

Re: ClearCollect only few columns from Azure SQL Table

Hi @hotely, use the ShowColumns function.

 

 

ClearCollect(MyCollection, ShowColumns(MyAzureTable, "ColumnA", etc. etc. ))

View solution in original post

Highlighted
hotely
Frequent Visitor

Re: ClearCollect only few columns from Azure SQL Table

Hi @Meneghino,

 

thank you so much for your prompt reply!

 

Does this mean that I save some memory since i create a collection with less column that the complete table?

 

thanks

Meneghino Community Champion
Community Champion

Re: ClearCollect only few columns from Azure SQL Table

Hi @hotely, frankly I have never run into problems with memory since I always make apps for desktops, but possibly yes.

peter_not Advocate I
Advocate I

Re: ClearCollect only few columns from Azure SQL Table

you are awesome!!

sidacra Advocate II
Advocate II

Re: ClearCollect only few columns from Azure SQL Table

Thank you Meneghino! 

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,145)