Sequential Approval is a powerful feature in Microsoft Power Automate that allows organizations to ensure decisions are made in a structured, step-by-step manner. Whether it’s managing leave requests, budget approvals, or document sign-offs, sequential approvals enforce accountability and transparency by routing requests through a predefined sequence of approvers. Watch the video or scroll down to…
Read more
In this blog you will learn how to Generate Word Template Automatically from Dataverse Record in Power Automate and Send as an attachment in email outlook. Watch the video below or scroll down to read the steps. Problem Statement How to download Word Template automatically without manually downloading the template by user and send the…
Read more
In this blog you will learn how you can configure a power automate flow to keep waiting till a file attached or uploaded in file column in a dataverse record and proceed once the condition met otherwise keep waiting to the event. watch the video below or scroll to read. Step 1: Identify Trigger Design…
Read more
Model-driven apps in Dynamics 365 offer a robust way to build applications that rely on your data model. One powerful feature that can greatly enhance your app’s functionality is the ability to run a Power Automate flow directly on a selected record within the app. This is particularly useful for automating tasks or processes that…
Read more
In Power Automate, working with Dataverse often involves updating records with related data. A common scenario is setting a lookup field value, which creates a relationship between two records. In this blog post, we’ll walk through the steps to set a lookup field value in Power Automate using Dataverse. Sometimes also if you have not…
Read more
Follow the steps below to encode URI for strings and decode URI. Step 1 – Create a Flow Step 2 – Add parameter Step 3 – Add a compose step and use expression encodeUriComponent. Step 4 – Add another parameter as sample url Step 5 – Add a compose and use decode URI Now save…
Read more
Here is the list of all power automate expressions and formula. Hope it helps.
Here you will find some important best Practices you can folow while working with Power Paltform and Dynamics 365 Apps. All these Best Practices are recommended by Microsoft for better solution management and performance. Sl No. Description 1 Avoid duplicate Dataverse plug-in registrations.Duplicate plug-in step registration will cause the plug-in to fire multiple times on…
Read more
In this below blog, you will come to know how to use assign value to single lookup field and polymorphic lookup field while passing data in Xrm.WebAPI request in Javascript for Dataverse Power Apps Single Entity Lookup If you want to assign value of a lookup field which is associated with a single entity then…
Read more
As a solution architect/developer, its very important to find out THE BEST Solution for a business requirement in the era of AI and less-code no-code. Here is a table which explain how to decide when to use classic workflow and power automate. Features Classic Workflow Modern Flow (Power Automate) License Part of Dataverse Feature Power…
Read more
Here You can download Dynamics 365 Scenario Based Questions and Answers Part -1. Hope this helps.
Preferred solution will help you to automatically add your component changes to a specific solution selected as preferred. So that any solution or default solution you use to change component, those will be added in the preferred solution. Follow the process below to work with preferred solution Step 1 – Enable Preferred Solution option Feature…
Read more
You can use C# code in a custom connector and which can be called as a connector from power apps or power automate. Follow these steps. Step 1 – Create a Custom connector with Name and Host Step 2 – Add No Security for this Step 3 – Add Definition Request Add Request option using…
Read more
Microsoft newly introduced a Security feature for Request trigger by using which you can secure the WEB API Calls in Power Automate with HTTP Calls. Follow below Steps. Step 1 – Configure a Flow with Request Trigger Step 2 – Use below JSON to generate Schema Step 3 – Add Send Email step and connect…
Read more
In this example, you will come to know how to use Do until loop in Power Automate when you want to run LOOP for a specific condition met. Scenario: Need to Build a Flow which will get JSON response from a Third Party Web API request called as Currency Layer to get Live Exchange Rates…
Read more
Problem Statement When you retrieve a record from Dataverse or any data source by using filter condition using List Rows, it returns the matching records from the table which you can use loop for further action steps in Power Automate. But sometimes when you have no primary key value with you and you want to…
Read more
In this Post, you will see how you can use Array manipulation using Array Filters, Loops, Variables and SetProperty Scenario in Power Automate. Scenario: We have the below records in the table. There may be multiple records for a single doctor with patient count 1 for every row. The requirement is to send a consolidated…
Read more
Here is a list of operators you can use in condition step in Power Automate. Hope it helps.
If you want to know how to Work with Variables, Control Flow and Loops with Power Automate in Excel Sheet Data Source watch the below video. Hope this helps.
Here in this post you will know how to send an email with an adaptive card on email body and capture response with HTTP calls with Power Automate. Watch the video below. hope this helps.
When you are using LIST ROWS action in DataVerse connector and want to filter records using Lookup Field then use following way. If your lookup logical name is fbs_student then in filter use _fbs_student_value eq ‘<Dynamic value>’ Hope it helps.
Step1 – Create JSON Web Template to get Server Data First create a Web Template with JSON response type and get all required server data using Liquid code. Sample code given below. Step2 – Create a Page Template and call the Web Template Create a new Page Template and use the created Web Template without…
Read more
Learn how to handle time zone issues in date time fields with Power Automate.
Different in hours between two date time fields in Power Automate. Use below Expression. div(sub(ticks(body(‘Convert_time_zone_2’)),ticks(body(‘Convert_time_zone’))),36000000000)
To stop running power automate for unnecessary purpose, use Trigger Condition to save Quota. Watch the below video to learn. Hope this helps.
Get daily articles in your inbox for free.
Step:2 - Subscribe Softchief (Guru) Here and Press Bell icon then select All.
Step:3 - Subscribe Softchief (Xtreme) Here and Press Bell icon then select All.
Step:4 - subscribe SmarTechie channel here and Press Bell icon then select All.
After the above 4 steps. Give your email id below and get the answers document in your inbox.
Drop your contact information and our Experts will call you in les than a minute to discuss about your requirement.
