Gallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (2024)

Are you interested in learning about Power Apps Gallery Control and its functionalities?

Well, this Power Apps tutorial explains everything related to Gallery Control in Power Apps, its types, and key properties of Power Apps Gallery Control.

I’ll also use a simple scenario to demonstrate how to add a Power Apps Gallery control and display SharePoint List items in the Power Apps Gallery.

Moreover, we will see the limitations of Gallery Control in Power Apps.

Table of Contents

Gallery Control in Power Apps

Power Apps Gallery is a type of control that can display a set of records from a data source. In the gallery, each record holds multiple types of data. Also, it can contain other input controls.

Suppose you use a gallery control to display multiple sales, with each item showing the Product Name, Product Price, and Product Quantity.

Within the Gallery control, every data field appears in a separate control. You can configure the Power Apps controls in its template. Inside the gallery, the template appears as the first item.

  • On the left edge of a Gallery control in horizontal/landscape orientation.
  • And at the top of a Gallery control in vertical/portrait orientation.

Any changes you make to the template will be reflected throughout the gallery.

Power Apps Gallery Control Properties

The table below represents all the key properties of the Power Apps Gallery Control.

PropertyDescription
ItemsSpecifies the source of data that appears in a control like a list, a gallery, or a chart.
DefaultWhen the app starts, it specifies the record from the data source to be selected in the gallery.
SelectedDefines the selected item.
AllItemsDefines all items in a gallery, including the additional control values that are a part of the gallery’s template.
AllItemsCountCount of items that are loaded in the gallery. This may be less than the actual number ofItemsfrom the data source. More items may be loaded when the gallery is scrolled.
BorderColorProvides the color of a control’s border.
DelayItemLoadingSpecifies the delay loading of items (rows) until after the screen loads.
DisplayModeDefines whether the control allows user input (Edit), only displays data (View), or is disabled (Disabled).
FillSpecifies the background color of a control.
ItemAccessibleLabelDefines the label of each gallery item for screen readers. It should describe what each item is.
LoadingSpinner (None, Controls or Data)When it is None, then the spinner will not be shown. When it is Controls or Data, the spinner will be shown when a render pass occurs, resulting in visible empty rows.
LoadingSpinnerColorSpecifies the fill color of the loading spinner. The default is set to BorderColor.
NavigationStepIf you set the value as true, the gallery scrolls so far, and the user selects a navigation arrow at either end of that gallery.
SelectableIt defines whether the gallery items can be selected. When the user is set to true, screen readers identify the gallery as a selectable list. You select an item by selecting it.
When a user sets it to false, screen readers identify the gallery as a regular list, and selecting an item doesn’t select it.
ShowNavigationDefines whether an arrow appears at each end of a gallery so that a user can scroll through the items in the gallery by selecting an arrow.
ShowScrollbarSpecifies whether a scrollbar appears when the user hovers over a gallery.
TemplateFillProvides the background color of a gallery.
TemplateSizeDefines the template height for a gallery in vertical/portrait orientation. Or the template’s width for a gallery in horizontal/landscape orientation.
TransitionRepresents the visual effect (Pop, Push, or None) when the user hovers over an item in a gallery.
VisibleDefines whether the control displays or is hidden.
WrapCountRepresents the number of items shown per row or column based on horizontal or vertical layout.

These are the Power Apps Gallery control properties.

Power Apps Gallery Types

There are six different types of gallery control in Power Apps. Such as:

TypeImage
Vertical galleryGallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (2)
Horizontal galleryGallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (3)
Flexible height galleryGallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (4)
Blank vertical galleryGallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (5)
Blank horizontal galleryGallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (6)
Blank flexible height galleryGallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (7)

To insert any gallery in PowerApps, go to+ Inserttab -> SearchGallery in the search box-> then you can choose your desired gallery from the gallery section as shown below.

Gallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (8)

These are all about Power Apps Gallery Types.

How to Display SharePoint List Items in Power Apps Gallery

Here, we will see how to display SharePoint list items in a Power Apps gallery control.

Example:

1. I have a SharePoint List named Employee Onboarding. This list has these many fields below:

ColumnDatatype
Employee IDNumber
Employee NameTitle field with Single line of text
DepartmentChoice [IT, HR, FINANCE, MARKETING]
PictureImage
LocationChoice [Australia, America, France, Canada, Cuba, London]

Also, this list has some records below.

Gallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (9)

I want to display all these SharePoint records in the Power Apps gallery control. To work with it, follow the instructions below:

2. Sign in to Power Apps with your valid Microsoft 365 Credentials and then create a Power Apps blank canvas app [with tablet layout].

3. Next, connect the SharePoint List data source to the app. To do so, go to the Data tab -> Add data -> Search SharePoint in the search bar -> Select SharePoint.

4. Add a new or existing SharePoint connection.

Gallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (10)

5. Connect the specific SharePoint site and choose the SharePoint list [Employee Onboarding].

Gallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (11)

6. Then, the SharePoint list has been connected to the app.

Gallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (12)

7. insert a Power Apps Vertical Gallery control [+ Insert -> Vertical gallery] into the screen.

Gallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (13)

8. To display all the SharePoint records in the Power Apps gallery, we can use the gallery’s Items property or the Data source property from the right Properties pane.

Items = 'Employee Onboarding'

Refer to the image below.

Gallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (14)

9. Also, you can customize the Power Apps gallery by using various properties like Layout, Color, Border, Wrap count, Text font, etc.

Gallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (15)

10. Finally, save, publish, and preview the app.

Gallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (16)

This is how to display SharePoint list items in a Power Apps Gallery Control.

Power Apps Gallery Limitations

Refer to the table below to learn about the Power Apps gallery limitations.

Limitation CategoryDescription
Item DisplayGallery control displays items in a single column (for vertical galleries) or a single row (for horizontal galleries), so layouts with multiple columns/rows need workarounds.
Data SourceWhile the gallery can connect to many data sources, performance may vary, especially with large data sets. Fetching and rendering thousands of items can be slow.
Item LimitThere’s a limit to the number of items a gallery can display, driven by the “Data row limit” for non-delegable queries (500, by default, can be increased to 2,000).
DelegationCertain functions and formulas might not be delegable depending on the data source. This impacts how much data is pulled and processed locally.
Not Supported ControlsWithin a gallery, the following controls are not supported:
– Display form
– Edit form
– PDF viewer
– Power BI tile
– Rich text editor
– Scrollable screen (Fluid grid)
One Gallery can be addedOnly one gallery can be added inside of another gallery.
TemplateSizeTemplateSize must be at least one. If you don’t consider the template size, controls in the Gallery may deviate from their intended X or Y values.
Flexible Height GalleryBefore all items load, if a user scrolls the Flexible height gallery control, the currently visible item may be pushed down and out of view.
Use the standard Gallery control insteadof the Flexible height option to get around this problem.

The above table represents all the restrictions or limitations of the Power Apps gallery control.

Conclusion

I hope you got an overview of the gallery in Power Apps. This Power Apps article covers what gallery control is in Power Apps, its important properties, and its all types.

Also, we saw how to insert a Power Apps Gallery control and display SharePoint list items in the gallery. Furthermore, we discussed all the limitations of Gallery control in Power Apps.

Additionally, you may like some more Power Apps tutorials:

  • Add New Row in Power Apps Gallery Control
  • Select Multiple Items in Power Apps Gallery Control
  • Power Apps Gallery Conditional Formatting
  • Power Apps Gallery Pagination
  • Power Apps Filter Gallery By Year
  • Power Apps Filter Gallery By Last Month
  • How to Sort Power Apps Gallery By ID
  • Sort Gallery by Person Column in Power Apps
  • How to Sort Power Apps Gallery By Month
  • Customize a Power Apps Gallery Layout
  • How to Display SharePoint List Items in PowerApps Gallery?
  • How to Sort Power Apps Gallery by Choice Column?
  • Power Apps Sort Gallery By Calculated Field
  • Count Rows in Power Apps Gallery Control
  • How to Add Hyperlink in Power Apps Gallery?
  • How to Use Power Apps Gallery OnSelect?

Gallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (17)

Bijay Kumar

I am Bijay a Microsoft MVP (10 times – My MVP Profile) in SharePoint and have more than 17 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com

Gallery Control in Power Apps [How to use with examples] - SharePoint & Microsoft Power Platform Tutorials - SPGuides (2024)
Top Articles
Thor Majestic 23A Floor Plan
Purdue Pharma: Wie ein Konzern die Opioidkrise in den USA auslöste
Craigslist Free Stuff Merced Ca
RS3 Mining Training Guide - 1-99/120 | Gaming Elephant
Jobs Hiring Start Tomorrow
The KT extinction
Tyson Employee Paperless
Madden 23 Playbooks Database
Jocelyne Mirando
19 Dollar Fortnite Card Copypasta
Mets Game Highlights
Craislist Vt
Spacebar Counter - Space Bar Clicker Test
Wat is 7x7? De gouden regel voor uw PowerPoint-presentatie
Franklin City School District - Ohio
Thomas the Tank Engine
1977 Elo Hit Wsj Crossword
Short Swords Resource Pack (1.21.1, 1.20.1) - Texture Pack
Pachuvum Athbutha Vilakkum Movie Download Telegram Link
Food King El Paso Ads
Cocaine Bear Showtimes Near Amc Braintree 10
FREE Printable Pets Animal Playdough Mats
BCLC Launches PROLINE Sportsbook at B.C. Retail Locations
Thermal Pants Mens Walmart
Edenmodelsva
Frontline Education Absence Management Login
Pdinfoweb
Appraisalport Com Dashboard /# Orders
Amex Platinum Cardholders: Get Up to 10¢ Off Each Gallon of Gas via Walmart Plus Gas Discount
Tv Guide Visalia
Dayinew
Perry County Mugshots Busted
How To Pause Tamagotchi Gen 2
Maurice hat ein echtes Aggressionsproblem
Craigslist Lubbick
Mike Temara
Meaty Sugar Lump
Panty Note Manga Online
Www.publicsurplus.com Motor Pool
Labcorp.leavepro.com
Arsenal’s Auston Trusty: Inspired by Ronaldinho, World Cup dreams and Birmingham loan
Brian Lizer Life Below Zero Next Generation
Netdania.com Gold
Lildeadjanet
Famous Church Sermons
O'reilly's In Mathis Texas
Alylynn
Joe Aloi Beaver Pa
DIRECT. France-Côte d'Ivoire U23: après Barcola, deux nouveaux forfaits pour les Espoirs
Mybrownhanky Com
Directions To Lubbock
Good Number To Shoot For
Latest Posts
Article information

Author: Fredrick Kertzmann

Last Updated:

Views: 6211

Rating: 4.6 / 5 (46 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Fredrick Kertzmann

Birthday: 2000-04-29

Address: Apt. 203 613 Huels Gateway, Ralphtown, LA 40204

Phone: +2135150832870

Job: Regional Design Producer

Hobby: Nordic skating, Lacemaking, Mountain biking, Rowing, Gardening, Water sports, role-playing games

Introduction: My name is Fredrick Kertzmann, I am a gleaming, encouraging, inexpensive, thankful, tender, quaint, precious person who loves writing and wants to share my knowledge and understanding with you.