While working on a Power Apps canvas app for another blog post, I implemented a simple easy-to-use year and month selector component that can be used to select desired year and month range for that year. Without further ado, here is how the component behaves in action: On the screen I have two horizontal galleries…More
Author Archives: terhoantila
Collect information from external stakeholders using Adaptive Cards and Power Automate flows
It is not uncommon that you need to get input from external parties as a step within your various business processes. You might need to collect approvals from stakeholders, for example. Or you need to contact your customer to get more information regarding a service order they created earlier. In a very, very, very simple…More
Using Desktop flows to UI test your Power Apps
The challenge Let’s face it: unit testing Power Apps is not possible. Surely, you can add some custom Power Fx code here and there to validate that elements are where they are supposed to be and to check that galleries contain correct data. But by doing this, you will make your solution much more complex,…More
Apply some DevOps to your Power Platform solutions!
Recently I’ve been working with a Dynamics 365 Sales Pro project. In addition to some Azure artifacts (e.g. Logic Apps) for integration and migration purposes, our delivery contained plenty of customizations in a Power Platform solution package. In the project we are using three Power Platform Environments: one for development, one for testing and one…More
Open an HTML file from Power Apps and host it within your solution
Recently there was a need to open an HTML file from Power Apps canvas app and to even pass URL parameters to it. It sure is easy to open a desired URL from canvas app simply by using the Launch function. However, the problem in the project was where to host the static HTML file???…More
RPA with Power Automate Desktop – setup and test drive
My colleague is currently working on a project where he needs to report working hours into two different systems. So, basically he needs to enter hours into our company’s own project management system, as well as into customer’s hour reporting system. At Cloudriven, we are using custom solution that basically consists of Azure SQL Database…More
Using Environment variables in your Power Apps solution
Quite often you need to have your app look and behave a bit differently depending on the current Environment context. I recently had to implement simple functionality where the user is directed to a Power BI report page on a click of a button. That’s simple enough using the Launch function in Power Apps, but…More
Power Platform DevOps: automating deployments
Power Platform is great! You can easily create compelling apps and automation flows to supercharge your daily routines and you can even share the apps with your co-workers. But what happens when some applications get more and more popular, and eventually employees start getting dependent on them to accomplish their tasks smoothly? Well, that depends…More
Exam PL-900: Microsoft Power Platform Fundamentals
It’d been years since my previous Microsoft exam so now I thought it’d be a good time to take a shot for it! Without hesitation, I scheduled a Pearson Vue online proctored exam for PL-900. Let’s just say that it didn’t go as expected at the very beginning. See, I got mixed up by the 12-hour…More
Reporting field validation errors to the user in Power Apps
Typically in every Power Apps solution we implement we need to provide feedback to the user if he or she has entered invalid information in one of the fields on the form or skipped filling in a required field altogether. I have used various ways to acchieve this throughout dozens of apps I’ve implemented in…More
