Posts

Data Migration Toolbox

Image
Data Migration Tool is an app to migrate Dynamics CRM/Power Platform data between environments, using fetch XML queries.  What can you expect when you use this tool? It keeps Guid records. You can turn off the plugins to migrate data. You can apply a fetch filter per table. It's another way to deploy a portal. It executes an Upsert. It doesn't delete existing records. You can have a data backup. Other tools like Data Transporter on XRMToolbox also help you to copy data between environments respecting the record Guids and select the CRUD actions you want to apply. Both apps XRMTool and DMT run only on Windows. This post will explain How to use the Data Migration tool; during my years of experience, I have done this knowledge transfer for different reasons, so I considered it helpful to have these directions immortalized on the internet. I used this tool for different purposes such as a catalog table, some old Portal deployments (known as Power Pages today) To download the data m

Using external Fonts in Power Pages

Image
Power platform has some specific font-family to customize your website... but as developers, we always try to figure out how far we can get to apply customizations. In this post, I will show you how to use an external font family in Power Pages to match the site with your client's brand. First, you will need a font-family file; I'll use one from Google Fonts ( Sedgwick Ave Display - Google Fonts ). Create a Web file record to attach the “*.ttf” file on the notes. I suggest leaving the Home Page as Parent if you use this font across all the pages.     To apply this font for H1 labels, download the existing CSS called "portalbasictheme.css" and edit this, replacing it with the new font-family properties.       Update the portalbasictheme.css by attaching this to web file record.     Finally, sync the portal configuration to apply these changes; note that this action synchronizes the changes done on the portal management app.       Then click on Preview> Desktop to vi

Power Automate Flow that return numbers on a text

Image
Hi Folks, Have you had this kind of requirement? Where you have to get all the numbers that exist on a text. I recently created a child flow with Power Automate that does this in 11 seconds. First, you must create a variable to append all numbers in this string. The next step is to split your text by space, but first, you need to remove possible characters that can be next to the numbers f.e. "$" or "," split(replace(replace(triggerBody()['text'],',',''),'$',''),' ') Next, per each record, you will validate if it is an int or float number, and if yes, it will be appended to the variable. if(or(isFloat(item()),isInt(item())),concat(item(),'|'),'') Finally, remove the last string that concatenates each number "|" and return it as the flow result. substring(variables('numbers'),0,sub(length(variables('numbers')),1)) The expected result of the following input is: "4|4.59|2&quo

Versioning your Portal with ADO

Image
Hi folks, In this post, I will guide you step by step on how you can version your Portal with Azure DevOps.  Before starting... To do this practice, we will use the following: Azure DevOps A Power Portal 👀 Visual Studio Code Git installed on your computer Let's get Started! Step 1 Create your Project in Azure DevOps  Step 2 Initialize your repository.  Step 3  Clone your repository with VS Code. Step 4  Select the directory where the project will be saved and Sign In.  Step 5  Install Power Platform tools on Visual Studio Code. Step 6  Open a new terminal in Visual Studio Code Step 7  To download the Portal data on your VS Project, you must first authenticate on the environment. Execute the following command line to establish on your VS terminal. pac auth create -u [CRM URL] Step 8  A pop-up window will display; sign in with your environment credentials.   Step 9  Execute the following command to see all websites available in your environment and then copy the GUID of the site you

Customizing your Portal from VS Code using OSX

Image
STEP 1 Go to extensions and Install Power Platform tools on your Visual Studio C ode STEP 2  Install .NET SDK STEP 3   On VS Code, open a new terminal STEP 4   Write the following line on the terminal to authenticate your environment sudo pac auth create -u [Dataverse URL] STEP 5   Identify your website record with the following command: sudo pac paportal list STEP 6   Download website content: sudo pac paportal download - -path / -id [WebSiteId-GUID] Once the website is downloaded, you will see a successful message on the terminal and all the Portal data display on your VS project.             STEP 7   You can edit the files directly here and update them on the portal from the Terminal, for example, I will update a Content Snippet to change the size of the logo image STEP 8 So I will do an update on my Content Snippet file to change the company icon size. If you have issues writing files on your visual studio code project, execute the next line on the terminal sudo chmod -R 777 <