There are lots of different places to store files in Microsoft 365, and this can become confusing for end users. This video looks at the similarities and differences between these storage tools, and in what circumstances you might want to use each of them.

There is a frustrating missing feature in Microsoft Forms (and a lot of its competitors) in that you can only analyze your responses on a form-by-form basis, and not easily group common types of questions across multiple forms. In this video we explore how to address this using the Microsoft Forms API.

Dataverse table relationships offer a lot of powerful features that extend beyond many other data sources you may use with Power Automate, but they can also make accessing and manipulating data more complex. In this video, I look at a couple of these added complexities to get data out of related tables more easily and to add data into rows where there is a lookup column present.

For certain actions in Power Automate you might need to know your Microsoft 365 Tenant ID. It's really easy to find this using publicly available websites, the MS Graph API, the Azure Portal, or even the creator portal for Power Automate or Power Apps. But what if you want to know the Tenant ID as a dynamic piece of data that changes based on the context of the user running the flow? This is harder, particularly if you only have access to Standard Connectors. This video shows you one approach that seems like it should work and doesn't, and another approach that solves this challenge.

Sometimes you want to use SharePoint as a data source but want to enter the data elsewhere using Power Automate. In this case, if you have Choices columns you might need to get a list of the possible options to use inside your flow. You can do this using the SharePoint HTTP action.

With the holidays quickly approaching in a lot of offices once-a-year or very infrequent activities are in full swing. Power Platform is a great tool to help with those time-consuming processes that come up occasionally, even the ones that are just supposed to be for fun.

One of the biggest benefits of low-code maker-led business application development is the agility it offers versus more traditional approaches. However, often the examples that are highlighted in videos like mine don't do enough to surface these quick and easy minimum-viable-product approaches that are designed to boost individual productivity rather than being tools entire teams rely on.

With minimal effort in learning new skills you can quickly flex to short-term changes in your process needs or the specific requirements of this week's project, creating tools to help you work efficiently but without the concerns that might be associated with building something for the longer term that is deeply critical to your business.

If you want to get started with exploring Power Platform or new features in Microsoft 365, it normally doesn't make sense to do so immediately in your production environment business account. Luckily Microsoft provides some great free programs to get started with developing solutions and testing with these tools without any impact on your normal business account.