terhoantila

Displaying Entity Image in Power Apps portal with Table Permissions enforced

Recently, when working with a customer project with Power Apps portal, I bumped into a problem I was not able to solve without writing a custom plug-in. The business case was to list all contacts of the current user’s account in the portal with each contact’s Entity Image displayed. The simplest way to do this…More

Power Fx – Using the Sequence Function

Even though Power Fx Sequence function has been there for a while, I discovered it myself quite recently while implementing the Planner Gantt Chart app. Short intro to Sequence(…) function Basically the function – as the name suggests – generates a sequence of numbers. You must provide the number of elements to generate and optionally…More

Turn your Power BI reports into interactive dashboards with Power Apps and DirectQuery

Typically, when you create a Power BI report, you provide the end user a view to the present and past time. For decision makers this rarely is enough, since decisions should be also based on predictions of the future. In this blog post I’ll introduce a demo case where an interactive report is created to…More

Using the Add to Teams functionality to Teamify your Power Apps app

When I introduced two ways to surface Power Apps in Teams in my previous blog post, I missed one, which is the latest addition to the toolbox to get your Power Apps to Teams – although it’s been there for a while already. However, I’ve never used it before, so I thought I’d give it…More

Surfacing Power Apps in Teams and introducing yet another cool Planner Gantt Chart feature!

There are two easy ways you can use to bring your Power Apps canvas applications as tabs within your Team’s Channels. I’ll shortly introduce them both and discuss some pros and cons of each. Then I will show you how you can bring Planner Gantt Chart as a tab in your Teams channel and define…More

Microsoft Planner Gantt Chart with Power Apps – download your own!

[If you’re just looking for the download link, it’s at the end of this blog post] So far (May 15th, 2021) there has been 11957 votes on the Microsoft Planner UserVoice for a feature to get a Gantt chart view in Microsoft Planner. The latest reply from the Planner Team is, that people should start…More

Make your Power Apps less formal with Emojis 😀

Emojis are nice, they can be treated as text in many apps these days and you can easily copy-paste them around. And Power Apps canvas app is not an exception! I created an Emoji Picker component that can be used to allow the user to choose an emoji. The chosen emoji can then be used…More

Simple Power Apps month range selector

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

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