Build a Reusable Nested Gallery in Minutes with YAML in PowerApps

Nested galleries (sometimes called accordion galleries) are a great way to group related data into a hierarchical view. In this post I'll explain the logic behind a nested gallery and give you YAML you can paste straight into PowerApps Studio to get your own nested gallery structure in seconds. PowerApps nested gallery in action! What We're Building My example data is a list of clients who each have many bookings. In SharePoint you would have two lists: one for Clients and one for Bookings, with a lookup column on Bookings that points back to its client. The parent…

Comments Off on Build a Reusable Nested Gallery in Minutes with YAML in PowerApps

Power Automate Excel Pagination: Get More Than 256 Rows

This guide shows how to get more than 256 rows out of an Excel table in Power Automate by using the pagination setting and its threshold, and how a Do Until loop with Top Count and Skip Count can do the same job. I'll also cover the limits you should know about before you build a flow on top of a large workbook. If you've built a flow with the Excel Online (Business) connector, you've probably run into this one: the List rows present in a table action doesn't return everything. By default it returns up to 256…

Comments Off on Power Automate Excel Pagination: Get More Than 256 Rows

Managing Pending Approval Requests in Power Automate

Who still hasn't approved?! A simple question that's not so easy to answer when it comes to using Power Automate Approvals. If you have pending approvals — especially those with multiple approvers where all must approve — there's really no good out-of-the-box way to obtain this information. Sure, there are workarounds, such as tracking approvals in a custom list and syncing it with Power Automate, but this carries the risk of the data becoming out of sync with the "source of truth" in the Dataverse Approvals table. Therefore I wanted to come up with a solution that will:…

Comments Off on Managing Pending Approval Requests in Power Automate

The Dataverse Batch API: A Practical Guide for Power Automate

If you're a seasoned Power Automate user, no doubt you've encountered performance bottlenecks with bulk CRUD operations against a data source. Using Apply to Each loops can be slow and consume precious API calls per action. This is compounded when the operation involves a large volume of data. This post will discuss how to make use of the Batch API requests with Dataverse to significantly speed up these operations — often down to just one API call! It's a more advanced but extremely powerful technique of interacting with Dataverse. In my fictitious examples, I will be working with…

Comments Off on The Dataverse Batch API: A Practical Guide for Power Automate

Application Showcase: A Pokémon Pokédex App built on PowerApps

Gotta catch em’ all! Of course, that’s the legendary tag line from the Pokémon series I fondly grew up with. As a Power Platform developer, I thought: why not combine these by building a Pokédex app! A Pokédex is like an encyclopedia about Pokémon. It tracks all kinds of data points about the over 1000 Pokemon in the Pokémon universe. This dataset's rich detail and hierarchical structure make it fantastic for learning to build on in PowerApps. App Goals Use a 3rd party API (PokeAPI) to cache Pokémon information into SharePoint Build a fully responsive Canvas App that…

Comments Off on Application Showcase: A Pokémon Pokédex App built on PowerApps

Fetch SharePoint List Item Version History in PowerApps

This article will walk you through two different options for retrieving SharePoint Item Version History in Power Apps using Power Automate. Both solutions are designed to be ALM-friendly and avoid using Premium Connectors. If you’re not familiar with SharePoint Item Version History, you can access it by selecting the context menu for a list item and choosing Version History. Context Menu to access SharePoint item version history The modern modal dialog of a item's version history For this example, I have a simple SharePoint list consisting of Financial Validation events. These events are managed out of a Canvas…

Comments Off on Fetch SharePoint List Item Version History in PowerApps

Force Sync Users to a Dataverse Environment

Unlike a default environment in your tenant, which includes all valid users in Entra, other Dataverse environments that use security groups to control access do not automatically sync those users. In order for a user to obtain access to an environment, they need the following: A valid Power Apps license Access to the environment’s security group A security role within the environment If any of those three conditions aren’t met, then nope—no access. Even then, however, the user still won’t automatically show up! The reason is because Dataverse uses just-in-time (JIT) user provisioning, meaning qualified users are only…

Comments Off on Force Sync Users to a Dataverse Environment