While developing ‘PowerApp Components’ and traditional ‘Web Resources’, a common challenge is that testing is not straight forward. To test a change in HTML or JS code, one needs to deploy files, which is time-consuming. There are commercial tools available for model-driven apps to make it simpler but still using Fiddler have advantages. This first post of this series will explain how it works and how to get started with it. What is Fiddler ? Fiddler is a web proxy debugging tool often used by web developers. Basic version which we need is free forever and can be downloaded from here. How ..read more

Learn how to configure Azure Key Vault for Power Automate using a service account. In cloud flow we read secret from Key Vault ..read more

A common requirement is to update the record row in Dataverse table after a file has been uploaded to SharePoint. This small post documents the steps and expressions for it. For demonstration, I m using “Account” table and have created “URL” a custom column in it. After file uploads, I will update the row and safe URL in this field. Summary This post do not cover the steps required to configure SharePoint for document storage with Model-Driven App. Follow this link for integration details). Cloud flow triggers when a file is uploaded from Model Driven App and created in the SharePoi ..read more

Did you ever receive a requirement that a Word file uploaded through a model-driven app in SharePoint should be converted and saved as Pdf? I had this requirement in multiple projects. Recently I have used cloud flow to achieve this. It was a model-driven app that has integration with SharePoint for document storage. In this post, I m documenting steps. Summary The app has SharePoint integration enabled for the “Account” table (this post does not cover how to integrate SharePoint with Model Driven Apps, follow this link for integration details). Flow triggers when a file is uploaded ..read more

Audit history is a great out of box feature in model-driven apps. However, querying audit history is a bit tricky. Unfortunately commonly used querying mechanisms like Power Automate CDS connectors, LinQ, or simply FetchXml doesn’t support it. This post will discuss options we have and sample code for it. Options Using SDK messages, RetrieveRecordChangeHistoryRequest & RetrieveRecordChangeHistoryResponse, covered in this post  Using Kingswaysoft’s Integration Toolkit for D365 (not covering in this post) Scenario I will query audit history for contact entity records and read ..read more

Suppose you need to create a new globally unique identifier (GUID). In that case, Power Automate provides guid() function which generates and returns a new GUID as string. It is a useful function, but it doesn’t create a GUID based on string we provide, the way it works in C#. This post will explain how to convert a string into GUID format with dashes (with or without curly braces). I m making this cloud flow manually triggerable for the sake of post, initializing a variable with the GUID string. Next, I m converting this string to GUID (with dashes) using expression and storing in ..read more

Audit history is a great out of box feature in model-driven apps. However, querying audit history is a bit tricky. Unfortunately commonly used querying mechanisms like Power Automate CDS connectors, LinQ, or simply FetchXml doesn’t support it. This post will discuss options we have and sample code for it. Options Using SDK messages, RetrieveRecordChangeHistoryRequest & RetrieveRecordChangeHistoryResponse, covered in this post  Using Kingswaysoft’s Integration Toolkit for D365 (not covering in this post) Scenario I will query audit history for contact entity records and read ..read more

While developing ‘PowerApp Components’ and traditional ‘Web Resources’, a common challenge is that testing is not straight forward. To test a change in HTML or JS code, one needs to deploy files, which is time-consuming. There are commercial tools available for model-driven apps to make it simpler but still using Fiddler have advantages. This first post of this series will explain how it works and how to get started with it. What is Fiddler ? Fiddler is a web proxy debugging tool often used by web developers. Basic version which we need is free forever and can be downloaded from here. How ..read more

Adding this post for someone who needs it and for my own reference. In Java Script lookup can be populated in one of three ways depending on requirements: Query lookup data to set in form Get lookup details from data available in form (from other fields) Hard code lookup values This is example using second option. It uses logged in user’s id and name to populate lookup. A lookup can be populated by providing its id (GUID) , name and entity type. var approver = new Array(); approver[0] = new Object(); approver[0].id = Xrm.Page.context.getUserId(); // Guid as "{a004b16f-4bae-4445-9b15-438449a ..read more

Accessibility is an essential consideration for a public sector or enterprise implementation. Last week I presented “Accessibility in PowerApp Projects” at Washington DC – User Group. Thanks to lovely organizers and supporters of UG Kylie Kiser, Aiden Kaskela, Nelson Johnson, Mike Ochs and others. As usual, it was a lovely chat and sessions. I covered things like what accessibility is, why it is important and how to make a PowerApp project accessibility compliance. With your projects and teams are you considering accessibility ? Please let me know what you think a ..read more