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.
You can send emails using Email Templates with Power Automate. Follow the below steps to use email templates with Power Automate. Step 1 – Configure the Email Template Navigate to Advanced Settings in Power Apps and choose Templates -> Email Templates. Create New Email Template with Template Type as Contact and Specify Subject and Body…
Read more
When you want to call a custom Action (which are created specifically as Global/None) from power automate then you can use Perform unbound action step of Dataverse connector in Power Automate. If you want to call an entity specific custom action you can read this blog. To Call global action from Power Automate follow below…
Read more
For some business needs if you want to call a Custom Action process from power automate, you can use Perform Bound Action or Perform Unbound action of Dataverse connector. Read the below post steps to know how to call a custom action from power automate. NOTE You can call Entity Specific Custom Actions from Power…
Read more
You can use filter criteria to narrow down the set of rows that Dataverse returns using List Rows action using Power automate. Business Scenario: There is a requirement that you only want to retrieve the Loan records where createdon is greater than equal to Aug 1,2022. Solution For the solution, you can leverage the Filter…
Read more
You can use the List rows action to retrieve multiple rows/records at once from Microsoft Dataverse with a structured query either using Fetch XML or OData queries. In the List Rows by default all columns are retrieved if you do not mention the columns you want to retrieve explicitly. if the flow returns all the columns then…
Read more
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.
