Today, we’re going to look at some of the geospatial features offered by Power Apps. In particular, we will implement a radius-based location search. In other words, we will implement a filter that returns records that are around a location according to a given distance. To make the learning experience less boring, we will implement an application that will display Vinyl’s sellers in Detroit (#detroittechno) The app features 3 functionalities: Display all vinyl sellers in a map Display a circle with a given radius and center Filter the records so that their location must be within the search ..read more

I recently had the opportunity to work on a project where I needed to send an adaptive card to a Teams chat using Power Automate. After spending a few hours on building the adaptive card I was convinced that I had finished the job and that I just needed to use Power Automate to send the card to a Teams chat. Unfortunately, Cloud Flow did not save by returning the following error: Request to XRM API failed with error: 'Message: Flow client error returned with status code "BadRequest" and details "{"error":{"code":"InvalidOpenApiFlow","message":"Flow save failed with code 'DynamicOperationReque ..read more

In this blog, we will discover a new addition to the Client API. This event is the “OnOutputChange” that allows triggering a handler after a PCF control has notified the change of its outputs. This event is valid for controls that live in model-driven app forms. The use of this event creates communication between PCF controls and the Client API. Using this event enables us to solve several problems, such as: Avoid using unsupported code by the power apps component framework. Decouple the form business rules from the component implementation. Implement more generic controls that can be used in ..read more

You will see in this blog how we can initiate a Ms Teams call or a Whastapp chat from a Canvas app. Also, we will use the new concept “Named Formulas” to implement this scenario. Of course, we don’t have to use named formulas to implement this use case, this will give a first overview and the different possibilities and limitations regarding Named Formulas. Scenario: For the demonstration. I have a table that contains 3 rows. Each row is defined by the email and phone number columns. This table is displayed as a gallery, it contains two buttons. The first button will be used to initiate a MS T ..read more

Have you ever needed to open a form with a focus on a tab or a section dynamically from a url ? This blog explains in detail an approach to implement this functionality. You’ll need a few lines of JS code, don’t worry the API client will do all the work for us. Scenario: We will use the Account table and the standard Account form. The goal is to automatically navigate to an “X” tab by passing his name as a parameter to our URL. For example, the following URL will open an account with a focus on a tab named “DETAILS_TAB”: https://yourorg.dynamics.com/main.aspx?appid=08d0868e-b4e4-eb11-bacb-000 ..read more

Microsoft has recently introduced a virtual table called AAD User. This table allows to retrieve any user in an organization’s Azure Active Directory. This feature is available on all environments, no action is required to use it. One possibility is to create lookup columns of type AAD User. This will allow to create relationships between a Dataverse record and a user that is part of the organization’s AAD. This works very well, except for the search part in the lookup control. Indeed, the control lookup does not filter the records according to the search applied by the user. After some inve ..read more

As you know, Model-driven apps can be used on different clients, like Android smartphones and tablets or iOS iPads and iPhones. Recently, I had the opportunity to test Custom pages with the Native player from Microsoft on Android and iOS. This worked perfectly on Android, but not on iOS. Indeed, an error message is displayed while loading the Custom Page. In the following demo, I have a Custom Page called “NavigationApi4CP Examples”. When trying to open it, the error message “[NotLoggedInError] User is not logged in. Error: (…)” is displayed: After reading some Microsoft docs, I understood th ..read more

In-app notifications for model-driven apps is a feature that has historically been highly requested by the Dynamics 365 community for the past few years. To meet this long awaited need, Microsoft has introduced this feature for Dynamics 365 CE but not only, also for model driven applications, a Power Apps license is enough to take advantage of this feature. According to this blog by Adrian Orth, Principal Program Manager. In-app notifications are now in GA. We will no longer need to send emails to notify users! But don’t go too fast, you need to modify users’ security roles so that they can en ..read more

According to the roadmap published by Microsoft, Power Fx commands for model-driven apps will go into general availability from May 2022. This blog will discuss an example using modern commands, and I hope it will encourage you to adopt this new way to customize the command bar and buttons. As mentioned in the blog title, let’s see how it is possible to create a new button that will open multiple records in different tabs. Before going further, keep in mind that classically realizing this functionality requires JavaScript code. Demo: How does it work? Button creation is done on the app designe ..read more

Dataverse list rows connector allows to retrieve rows from a Dataverse table. This connector can filter rows using OData expressions or fetchXml queries. Unfortunately, the connector does not support all fetchXml requests. This blog will discuss an approach to execute this kind of unsupported queries. Let’s look at what the documentation says: The distinct operator and aggregation queries are not currently supported in FetchXML queries from the List rows connector. Let’s try a fetchXml query with the option distinct=”true” !! <fetch distinct="true" > <entity name="conta ..read more