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

Default show all columns?

Hi Folks,

 

So I am having a problem. I have a dynamic SQL query which creates my datasource, and I had planned to show all columns by default in PowerApps as the columns will change based on various criteria. 

 

I have tried a few different approaches, but what I really need is to enable all columns from my collection by default in either a gallery or data table, has anyone come accross this before? Seems like it should be a simple one, but really has me stumpped 😞

1 ACCEPTED SOLUTION

Accepted Solutions
v-monli-msft
Community Support
Community Support

Hi @MMaver ,

 

You can add all the columns in gallery control by adding multiple controls inside the template part of the gallery. Add as many controls as you need in the first part of the gallery and set the related formulas in the proper property of the controls. 

 

For your reference of gallery control:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-gallery

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-monli-msft
Community Support
Community Support

Hi @MMaver ,

 

You can add all the columns in gallery control by adding multiple controls inside the template part of the gallery. Add as many controls as you need in the first part of the gallery and set the related formulas in the proper property of the controls. 

 

For your reference of gallery control:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-gallery

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,565)