Power Apps Gallery Control Examples Download [20 Various Real Scenarios]

This Power Apps tutorial explains everything related to Power Apps Gallery Control with, most important, 20 real scenarios.

Power Apps Gallery Control

The Microsoft Power Apps platform includes a “Power Apps Gallery Control” functionality that enables users to visually display a group (or list) of items, such as a set of records from a data source.

It can display data from sources like SharePoint, SQL, or other data connectors, similar to a dynamic list or grid.

The following are a few benefits of Power Apps Gallery Control:

  • What it Displays: The Gallery Control can display several items from a data source, including lists of individuals or items, images, and other objects.
  • Layouts: The control offers some layout options (including Vertical, Horizontal, and Flexible height), allowing you to customize how your items appear and are arranged.
  • Customizable: You may modify the look of each gallery item, alter its size, alter how text or images are displayed, and more.
  • Interactive: Gallery items may be made clickable so visitors may pick, edit, or do other actions.
  • Bind to Data: You can show data directly from databases, cloud platforms, or other services by connecting Gallery Control to different data sources.

Set up SharePoint Lists

To work with this Power Apps Gallery Control, I have used two Custom SharePoint Lists i.e.

  1. Car Rental Services
  2. Car Gears

Car Rental Services

This SharePoint List contains the many below columns with various data types. Such as:

See also  Dataverse Create Table [With Examples]
ColumnsData types
Car NameSingle line of text (By default, its Title Column)
Car TypeChoice (Automatic Transmission, Manual Transmission, Semi-Automatic Transmission, Continuously Variable Transmission)
SeatsNumber
ColorChoice (White, Black, Grey, Silver, Blue, Maroon)
Daily PriceSingle line of text
Rent DateDate and time
LocationChoice (Maui Hawaii, Nashville, Yosemite National Park, Bend Oregon, Las Vegas Nevada, Austin Texas, Orlando Florida)
Person NameSingle line of text
Person EmailSingle line of text
Mobile NumberNumber
Car ImageImage
Confirmation StatusChoice (Confirmed, Not Confirmed, Pending, Cancelled)

Refer to the image below:

Power Apps Gallery From SharePoint List

Car Gears

This SharePoint List Contains only three columns i.e.

ColumnsData types
Car IDSingle line of text (By default, it’s a Title Column)
Car NameLookup Column
Car Gear TypeChoice (Automatic Transmission, Manual Transmission, Semi-Automatic Transmission, Continuously Variable Transmission)

Refer to the image below:

Power Apps Gallery From Collection

The above SharePoint List is only used for the 6th example, i.e., Power Apps Gallery Filter By another gallery, and for the 9th example, i.e., Power Apps Gallery Group By Lookup column. [Refer to the below table]

Power Apps Gallery Control Examples

In this Power Apps article and the solution package, a user will learn about 20 actual use cases of Power Apps Gallery Control, such as:

Power Apps Gallery ExamplesDescriptionsImages
Power Apps Gallery Display Items from the CollectionThis example will show how to use a Gallery control to display every record from the Power Apps Collection.Power Apps Gallery Display Items from Collection
Power Apps Gallery Display Items from SharePoint ListThis example will show how to use Power Apps Gallery control to display all the records from a SharePoint List.Power Apps Gallery Display Items from SharePoint List
Delete Power Apps Item(s) from Power Apps GalleryThis example defines how to delete or remove an item(s) from the Power Apps Gallery Control. Delete items from Power Apps Gallery
Power Apps Gallery Count RowsThis example will help you to know how to count all the records from a Power Apps gallery control and display the result in a label control.Power Apps Gallery Count Rows
Power Apps Gallery with Conditional FormattingsHere, we will get to know some of the important conditional formattings of a Power Apps Gallery Control, like,
-> Gallery Formatting Text Values
-> Gallery Formatting Number Values
-> Gallery Formatting Date Values
-> Gallery Formatting with SharePoint Choice Values
-> Gallery Selected Item Color
-> Gallery Formatting with Icons
-> Gallery Formatting with Emojis, and so on.
Power Apps Gallery Conditional Formattings
Power Apps Gallery Filter By another galleryThere will be two Power Apps Gallery Controls in this example. When a user chooses a specific item from the first gallery, the second gallery filters according to the value chosen in the first gallery.Power Apps Gallery Filter By another gallery
Power Apps Filter Gallery for top 5 valuesThe Power Apps Gallery filters the top 5 values based on the SharePoint daily price column.Power Apps filter gallery by top n values
Power Apps Gallery Order ByHere, we will sort the Power Apps gallery in ascending or descending order based on the SharePoint Date Column and the Choice Column.Power Apps Gallery Order By
Power Apps Gallery Group ByHere, we will sort the Power Apps gallery in ascending or descending order based on the SharePoint Date and Choice Column.Power Apps Gallery Group By
Power Apps Gallery ValidationsA huge amount of data that we can’t display in a single view is divided into equal-sized pages using the notion of paging so that it will load quickly and be easy for the user to utilize.Power Apps Gallery Validations
Power Apps Gallery PaginationA huge amount of data that we can’t display in a single view is divided into equal-sized pages using the notion of paging so that it will load quickly and be easy for the user to utilize. This is called Power Apps Pagination concept.Power Apps Gallery Pagination
Power Apps Gallery FilterHere, we will sort the Power Apps gallery in ascending or descending order based on the SharePoint Date and Choice Column.Power Apps Gallery Filter By Name
Power Apps Gallery Filter by Current UserIn this scenario, the Power Apps Gallery will filter based on the current logged-in user and display all the items of that specific current user.Power Apps Filter Gallery by Current User
Power Apps Gallery Filter by Single DropdownThe Power Apps Gallery Control will filter based on a single Dropdown control.
For example, if the Confirmation Status = Confirmed, the gallery will filter and display all the confirmed items.
Power Apps Gallery By Dropdown
Power Apps Gallery Filter by Multiple DropdownThe Power Apps Gallery Control will filter based on the multiple Dropdown controls.
For example, if the Selected Car = Audi, Seats = 4, and Confirmation Status = Cancelled, then the gallery will filter and display all the records based on these dropdown selected values.
Power Apps Filter Gallery By Multiple Dropdown
Power Apps Gallery Filter by Text InputIn this scenario, there will be a Power Apps Text input control. When a user searches items (by Car name, Gear, Daily Price, and Location) in the text box, the gallery will filter and show the records based on the text box value.Power Apps Filter Gallery by Text input
Power Apps Gallery Filter by Last N DaysHere, the Power Apps gallery will filter by Last N Days records like:
-> Filter Gallery By Last 5 Days
-> Filter Gallery By Last Week
-> Filter Gallery By Last Month
Power Apps Gallery Filter By N Days
Power Apps Gallery Filter by Date rangeThis example defines how to filter Power Apps Gallery based on a Date range. There will be two Power Apps Date Pickers (Start Date & End Date). When a user selects a date range, the gallery will filter and display the result according to those selected date values.Power Apps Gallery Filter By Date Range
Power Apps Gallery Filter by CheckboxThe Power Apps Gallery will filter by the Check box values in this scenario. When a user will select any of the check box values, based upon that, the gallery will filter and display the records.Power Apps Gallery Filter By Combo box
Power Apps Gallery NavigationThere will be a list of items in a Power Apps Gallery Control. When a user selects any specific item from the gallery, all the item details will appear (in a Display form) on the right side of the gallery control. Power Apps Gallery Navigation

Conclusion

With the help of 20 actual cases, this Power Apps course covers every aspect of Power Apps Gallery Control.

See also  Power Apps Employee Directory - How to Create

Furthermore, you may like some more Power Apps tutorials:

>