[Quick Tip] Set Option set field value blank using Power Automate

Here is the quick tip if we want to set option set field as blank. Here for the demo purpose, on Account record we have field called Ownership which is option set field. Now it is set as public and we want to update it as blank. Create a flow – I am using btn

Send Email Messages in D365 CE using Cloud flows

Let say you want to send an email using OOB email message table. Step 1 – add action add a new row and select table name “Email Message” After selecting a table, add your activity party attribute as per your requirement. As you can see status reason in below image, Email will not be sent

Create Email attachment in D365 CE using Cloud flows

Introduction – In this blog we will understand and see how we can send email messages with attachments in D365 CE using power automate/Cloud flows. Use case – our requirement is to create draft email message with attachment in CE. We added a custom button send email on custom entity. On click of send email

Create Folder in SharePoint when record is created in Dataverse using Cloud Flows

Use Case – Create Folder in SharePoint when new account record is created in Dataverse. Step 1- Trigger action Flow will trigger when an account is created in dataverse. Search and select “When a row is added, modified or deleted” trigger of dataverse. Step 2 – Initialize a variable of type string. Search and select

Last and First Expression in Cloud Flows – Part II

We have already seen how to extract first and last character from string in Cloud flows. Click here to check out part I. Let see how we can get first and last value in array. I have array of list of records (account records), want to get first value from array. Array – Add a

Last and First expression in Cloud Flows – Part I

Let’s see how we can use last and first expression in Cloud Flows. Below is the use case for using the First and Last Expression in the Cloud Flows: 1. To get First & Last item in array variable 2. To get First & Last char of string variable 3. To get First and Last

Create HTML table & CSS using Cloud flows

Introduction: In this blog, we will see how to create html table and CSS using Cloud Flow Use case : Our Project requirement is to have Invoice details in tabular form. Solution: Create HTML table : Step 1 : Select a “Select” Step in Ms flow and add the fields in the table In our

Ms flows in Power Automate not triggering ?

Introduction: In this blog, we will see, Why the Ms Flows are not getting triggered after Completion full copy of the environment. Use Case: It was requirement of our Project to Copy UAT environment To Dev but after Completion of full copy, None of the Flows in Power Automate were getting triggered. We tried the

How to use Fetch XML Query in Power Automate

In this blog we will see how to use Fetch XML query in Power Automate Steps to be followed: Use Common Data Service (Current Environment) Connector Add List Query step in flow 2. After adding List Record, Download your Fetch XML Query. Here I wanted to retrieve only Contact’s full name. Output of the above

Conversion of Time and Date

Introduction We had a requirement where we wanted to create a price list with current date time with respect to current country. In this blog we will use the OOB date conversion functionality. Use Case : We created a flow where we had used UTC now functionality but this was returning the value time value