Blog Posts

How Gartner defines Artificial Intelligence (AI)? Gartner defines Artificial Intelligence (AI) as “a technology that appears to emulate human performance typically by learning from data, and at times mimicking human-like tasks such as perception, cognitive reasoning, decision-making and natural language processing.” Artificial Intelligence (AI) has been a buzzword in the tech industry for years, and…

I explained in a previous blog post about getting more out of your monitoring of the Power Platform canvas app with custom logging. What if these custom measures have thresholds? How do we get notified? How do we get notified? From the previous blog, we learned how to define custom logging via the trace function…

I explained in a previous blog post about monitoring your Power Platform canvas application with Azure Application Insights. It is possible to quickly and easily connect the low-code application with Application Insights and get standard insights. What is next? Often, an application has a lot of logic behind the scenes. Sometimes the impact is logical,…

How does Gartner define application monitoring? Gartner defines application performance monitoring as monitoring software application’s performance, availability and use. It includes tracking critical performance metrics, recognising and diagnosing performance issues, and taking proactive steps to solve problems before they affect end users. Why is it important to monitor? There are several reasons why it is…

What is Power Platform Dataflows? Power Platform Dataflows are a powerful feature that allows users to extract, transform, and load data (ETL) from various sources into central data storage. Just a type of central data storage can be Dataverse or Data lake. This central data storage can power business intelligence and analytics tools, such as…

In dataverse, a custom multi-table (polymorphic) lookup allows you to create a relationship between multiple tables with a common field. This is similar to a regular multi-table lookup or joins but with the added flexibility of relating to multiple tables using the same field. Users can create and modify custom multi-table lookups at this time…

In some cases, we use Dataverse teams in environments of solutions to provide an easy way to share business objects and let them collaborate with other people across business units. Different teams like owner, access and Azure AD group teams exist. More information about them can be found here. Question?How can we use Dataverse teams…

When creating Dataverse environment variables in your solution, we can use them seamlessly in Power Automate. More information about Environment variables. Question?How can we use Dataverse environment variables in a canvas app? Solution SetupDataverse Environmental variableIn Dataverse, we have created an environment variable. In this example, we create an environment variable to store the environment…

When creating a table in Dataverse, we can add columns with specific data types. Like the date, text, multi lines of text, etc. Idem for a file data type. File data type columns are a primary data type intended to store a single image, note or attachment. However, keeping other forms of binary data is…

Question? Can we sort gallery filtered values on data located in a table connected to the gallery source?ERD table example: Issue. When using the gallery control to display and filter information based on a selection could be sometimes tricky. One gallery will display the information of the table “Room Class.” The second table needs to…

When building applications on the Power Platform, using development, test, user acceptance testing, and production environment is best practice. Therefore configuration settings or parameters or needed to move the application between those environments. Environment variables store particular application objects’ parameters and values and can be adjusted when moving a solution to another Power Platform environment.…

Photo by Thierry Lemaitre on Unsplash

The following question was posted last week on LinkedIn: Is it possible to authorise by item-level security in the SharePoint list?Each row contains three or four email ids in different columns (Text type). Only the people of those email ids should be able to edit or view the record when they come to SharePoint list…

Citizen Developers, Power users and champions often using SharePoint lists to store their data. They can use Power Apps, and Power Automate within their Office 365 Business Basic, Standard, E1 and E3 license. Because without restriction, when sharing the canvas app, they have permissions to the list and can change the data in the SharePoint…

Issue Using a Forms control to collect information from the end-user in a canvas app is a best practice. However, it is not often straightforward to display the data in a combo box, and this is because of certain limitations of the combo box – control itself. Let us explain the issue. Overview of the resources used…

Many of you have questions about giving access to a Power Apps application from Azure Active Directory groups. How do we manage access to a model app in Power Apps from AAD? How can we assign a role in Dataverse to a user? Without doing it for each active user. Where can I find the…

Often I get this question if a “shared mailbox” can be used in Power Automate to send emails and below concurs: What are the advantages and disadvantages? Do we need a Microsoft 365 license? Is it secure to use a shared mailbox? Do we need an account and password in the Power Automate flow? In…

I get following question very often “what’s the behaviour of a flow that has been imported as a new flow or have been updated, with a recurrence – trigger”. A scheduled cloud flow, with trigger “Recurrence”, more information. Listed up some test scenarios and created a very simple flow “Hello World”, that is sending an…

Building a canvas app in teams (earlier code name project Oakdale) gives you the possibility to create a canvas app in Teams for Teams. More information here A lot of citizen developers, taken their first steps in developing apps in Teams and they are using also know tools, like SharePoint. But indeed, there is a…

Within Azure, we have a free service called Azure Blueprints. Azure Blueprints helps us in simplify largescale Azure deployments by packaging key environment artifacts, such as Azure Resource Manager templates, role-based access controls, and policies, in a single blueprint definition. Easily apply the blueprint to new subscriptions and environments, and fine-tune control and management through…

I want to talk about this experimental feature, that enables you to understand the result of your formula or/and have the possibility to debug a formula. Sharing my experience with this feature and let you see where it help me to define my formulas and debugging. Where to enable the feature? Open a power app…

Azure Log Analytics is a service that can collect logs from any resource, within Azure. Having the possibility to send custom logs, leads us seamlessly to the next point. Sometimes there’s that need to check what’s happening during a process, logging to a text file or keeping historical logs in a SQL database is mostly…

Lately I was wondering how I can connect from a PowerShell script to a MS flow? Is this possible and how I can transfer variable(s) information from the script towards the Flow and use these values. In the simple blog example I will transfer variable values towards a MS Flow. What is needed? Type Name…

Losing a lot of time by checking everyone’s timesheet if the work week has been completely registered in the PSA timesheet portal. In Belgium, most of the employees have 40 hours working week. In this MS Flow, a check will be performed every Friday evening around 8 PM.  Defining some variables that later will be…

Intro Power Platform of Microsoft (Power Apps, Microsoft Flow and Power BI) are tools that will help you, with your digital transformation 4.0. In the coming years, we will look at digital transformation 4.0 to optimize are business processes, production environments, healthcare, … Currently I hear a lot of customers that are really have the…

Intro Buttons, Excel, Approvals and notification in Power Automate. Tracking a starting and end point into Excel, by triggering a button. This is a flow that I will talk about today! The solution will have two Flow’s that could be triggered by a button. The values will be added to an excel file that is…

Intro Getting into planner for managing the work of your teams, but you are lost in the total overview! Centralize the planning of your teams by creating them in an automated way toward a plan that will contain all teams. Need more information about Microsoft Planner: LINK Take the chaos out of teamwork and get…

Intro In the coming days I have a meeting with technical people about PowerShell and would like to start with a survey to get an idea of the knowledge about PowerShell of the people in the room. Putting hands in the air is old school … No? “Work Less, Do More” How-To? Creating a Microsoft…

Intro What is the definition of Compose action with Microsoft Flow? Use the Data Operations – Compose action to save yourself from entering identical data multiple times when you’re designing a flow. What does this mean in practice? You can shape the data that has been generated by an above action, by using an expression…

I would like to share this Microsoft Flow template with you all. I was used of creating manually to-do items (from an email out of MS Outlook) in a list on the Microsoft To-Do application. But this was really monkey work (Copy/Paste monkey work). “Work Less, Do More” So, I have created my own Microsoft…