See triggered data values in run history view #powerautomate

This morning out of blue, I saw this new option Edit columns peeks in the flow run history view. This is a much needed enhancement to the view in order to see the triggered data without opening the run history instance. If you navigate to All runs page, it is shown as Add columns. Click … Continue reading See triggered data values in run history view #powerautomate

Build Filter expression for Power Automate Dataverse Connector

Querying Dataverse table using Power Automate is easy with Dataverse connectors. Filtering the data is also more convenient using these connectors, we can use query expression or use FetchXML to filter the data based on our needs. There are three premium connector to facilitate querying Dataverse tables. Get a row by ID List rows Search … Continue reading Build Filter expression for Power Automate Dataverse Connector

Force rollup field calculation using Power Automate

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

Accessing Current Values of Environment Variables in Power Automate

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

My picks of 2022 release wave 2

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

Dynamic URL in the Power Automate email body

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

Overlapping instances in scheduled flow

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 Power Automate ALM saviour

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