Rollup field is a great way to capture aggregated values computed over the records related to a specified record. Rollup fields are also part of the low code approach where in it reduce writing/maintaining codes to calculate those numbers. The rollups fields are calculated by scheduled system jobs that run asynchronously in the background. To … Continue reading Force rollup field calculation using Power Automate
Monitoring flows is always a challenging task. Once the environment grows the solution also grows along with flows too. There are few ways we can able to monitor flows. Option 1 : From the Admin Centre we can able to get Analytics on how the flow are the progressing. There are some useful insights available … Continue reading Monitoring Power Automate Flows
Environment variables have proven to be a valuable solution for creating custom configuration tables within the environment. One of the notable advantages is their seamless integration into solution packages, allowing for effortless movement between different environments without manual transportation. Initially, retrieving the default or current value of an Environment Variable in Power Automate Flow required … Continue reading Accessing Current Values of Environment Variables in Power Automate
Power Apps Modern advanced find turned on by default - Classic advanced find is slow and clunky, newer version definitely have improved look and feel.View only relevant activities in dropdown - This greatly helps in user experience perspective.Connect to external data from Dataverse - Virtual table with standard connector like SQL Server, Excel file, or … Continue reading My picks of 2022 release wave 2
Power Automate Send an Email connector is quick and effective way to send email if it is not meant to be tracked inside Dynamics CRM. This gives more flexibility in terms dynamic content that we need to embed inside the email body. The connector also have flexibility to set HTML content via the steps in … Continue reading Dynamic URL in the Power Automate email body
Scheduled flows in Power Automate is a awesome tool to schedule any light weight automation. Schedule flow always have a happy path when we are dealing with small amount of data and it runs only once per day or a monthly once. The deadly ones are the one that are running every hour or even … Continue reading Overlapping instances in scheduled flow
Connection reference (preview) is a great new addition to the Power Platform. We all know the horror stories of the Power Automate Flow's deployment between environments. The way how the flows connections are broken after the deployment and need to edit the flow one by one in order to get it fix. What is the … Continue reading Connection reference Power Automate ALM saviour
This time while I am writing this post, it is still a known issue with the Power Automate flow run history keep on stuck with the loading image. Many have already figured out a way to live with this issue. Here I am giving some tips on few ways that I am tackling it. Cheat … Continue reading Cheat code to open ever loading power automate run history
Dataverse SharePoint integration is a must in all the project nowadays. Online makes it more feasible and quick to enable the integration between these two applications. This being said when the integration is tuned on the folder naming convention is out of our control using the base configuration. The introduction of Power Automate really elevate … Continue reading Custom SharePoint folder creation using Power Automate in Dataverse/SharePoint Integration
There are situation when you need to go dynamic with the parameters, and with multiple instances to deploy making the power automate flow connectors to be dynamics is a challenge. Setting the SharePoint URL and folder path parameters in SharePoint connector is one example to make it dynamic. If we hardcode those parameters in the … Continue reading Making SharePoint site URL/folder path dynamic in Power Automate connector (D365/SharePoint Integration)
My Trial 