Let’s dive in and build a working gallery app in minutes. Follow these steps, and reference the labeled screenshots to ensure success!
Step 1: Open Power Apps Studio
- Go to Power Apps in your web browser and sign in.
- Click the plus (+) button on the left.
- Select “Blank canvas app” to start from scratch.
Step 2: Start with a Gallery
- In the pop-up dialog, choose Gallery.
This option is perfect for displaying data in a list or grid view.
Step 3: Connect to Your Data Source
- Select your data source. In this example, choose SQL Server.
- (Tip: If you prefer a simpler setup, Microsoft’s Dataverse is available too.)
- Navigate the connection screens until you can select your desired table.
Step 4: Review Your Populated Gallery
- Power Apps will auto-fill your gallery with records—but it may look basic.
- Don’t worry, you’ll customize what’s displayed in the next steps.
Step 5: Customize Gallery Fields and Appearance
- Click Gallery1 in the tree view (left panel).
- In the right pane under “Properties,” click Edit next to “Fields.”
- In the data fields pane, set the Title to the field you want most prominent (e.g., ArticleName).
Set the Subtitle to a supporting field (e.g., CF_Code).
Step 6: Sort Gallery Items (Newest First, for Example)
- Use the formula bar at the top (like Excel’s), entering:
Sort([YourDataSource], DateTurnedIn, Descending) - Adjust as needed for your own data and preferred sort order.
Step 7: Add More Fields (Labels) to the Gallery
- Select a field in your gallery.
- Go to the Insert tab in the ribbon, choose Text label.
- To change the data displayed, select the data card > click the Edit link in Properties > choose the new field from the dropdown.
Step 8: Adjust Display Formats (Date and Time)
- If your time field is in 24-hour format (e.g., 16:30:00), use a formula in the formula bar to change it to a 12-hour display:
- Copy code
Text(ThisItem.TimeTurnedIn, “[$-en-US]hh:mm:ss AM/PM”)
Step 9: Add an Edit Form for Easy Data Management
- Select Screen1 in the left tree view.
- Go to Insert > Edit form.
- Drag the form to the side of your gallery and resize as needed.
- With the form selected, use the formula bar to set the Item property to:
Gallery1.Selected - Now, when you select an item in the gallery, the edit form will load that record for updates, additions, or deletion.
What Can You Do Next?
- Add, Edit, or Delete Records: Manage your business data from anywhere, instantly updating your SQL, SharePoint, or Dataverse source.
- Make It Mobile: Power Apps are automatically responsive across desktop, tablet, and smartphones.
- Automate Workflows: Link actions in your app to automated flows using Power Automate.
Get Expert Help to Build Your Power Apps
At eSoftware Associates, our Power Platform and no-code app experts help companies unlock the power of automation—rapidly and painlessly. Whether you need a custom business app, in-depth training, or ongoing support, we’re here to help you every step of the way.
Ready to turn your ideas into reality? Contact eSoftware Associates to build your own gallery or model-driven Power App—customized for your processes and business goals.
Thousands of businesses trust ESW for Power Apps development, training, and digital transformation—start building smarter workflows today!