Recently, I was working on creating a custom connector that has got one action which is a GET request and accepts parameters. The purpose was to use this custom connector in Power Automate which could then have been executed on demand or create/update of record. Below is the definition of custom connector: And here's the … Continue reading [Limitation]PowerAutomate: Unable to use Custom Connector with actions having parameterized GET requests. Error: “Fix Invalid expression(s) for the input parameter(s) of operation ‘ActionName'”.
Category: Power Automate
D365: Why my Power Automates are not being triggered
Recently, we copied a production environment to sandbox environment. Then, I was working on a requirement on the sandbox environment for which I created a power automate. The trigger was on create of a record. After creating the power automate, when I tested the functionality, for some reason the power automate was not getting triggered … Continue reading D365: Why my Power Automates are not being triggered
Power Automate: “Set Variable” Action fails inside “Switch” Action
Recently, we were working on Power Automate where we were supposed to set a variable for further use based on the value of an option set field in an entity. We used Switch action and inside Case block we were trying to set the variable as shown below: While executing the Power Automate, unfortunately, we … Continue reading Power Automate: “Set Variable” Action fails inside “Switch” Action
PowerAutomate: Perform “Group By” operation on Data
In this post, we'll see how we can perform aggregate function on data such as Sum or Count using PowerAutomate. Unlike LINQ in C# or SQL, it's not very straight forward to do using PowerAutomate for which I thought of sharing the approach we had taken. Recently, we got a requirement to calculate the sum … Continue reading PowerAutomate: Perform “Group By” operation on Data
PowerAutomate: Self-reference is not supported when updating the value of variable
We often come across requirements in which we want to add certain value to the same variable e.g. for integer variable, x=x+5 or for string variable, test=test+"additional". We were trying to achieve the same thing using PowerAutomate. However, while doing this using Set Variable action, we got an error saying "Self-reference is not supported when … Continue reading PowerAutomate: Self-reference is not supported when updating the value of variable
D365: Implement Try…Catch…Finally in PowerAutomate
Recently, we were working on a requirement to send PDF as an attachment in email on click of a custom ribbon button on Lead record. More details here:D365: Generate Word Document using Content Control, save to SharePoint and convert to pdf using PowerAutomateD365: Download SharePoint document, attach to Email using PowerAutomate and Azure FunctionD365: Execute PowerAutomate from … Continue reading D365: Implement Try…Catch…Finally in PowerAutomate
D365: Execute PowerAutomate from Ribbon button using JS
Recently, we had a requirement to execute PowerAutomate on click of a button on Lead record. In this post, we'll see how to do that. While creating the PowerAutomate, select the trigger as "When an HTTP request is received" as shown below: We can pass parameter to the PowerAutomate in JSON format. In this example, … Continue reading D365: Execute PowerAutomate from Ribbon button using JS
D365: Download SharePoint document, attach to Email using PowerAutomate and Azure Function
In this post, we had discussed how to upload document to SharePoint using PowerAutomate. Here, we'll discuss how to download that document and attach it to an email activity. We'll extend the same PowerAutomate we were using in the previous post and will also see how to execute HTTP Triggered Azure Function from PowerAutomate. So, … Continue reading D365: Download SharePoint document, attach to Email using PowerAutomate and Azure Function
D365: Generate Word Document using Content Control, save to SharePoint and convert to pdf using PowerAutomate
In this post, we'll see how we can generate word document using content controls and PowerAutomate. We'll save the generated document in appropriate folder in Sharepoint so that it shows up on the appropriate Lead record. Then, we'll convert the word document to pdf document and store at the same location. To proceed, let's create … Continue reading D365: Generate Word Document using Content Control, save to SharePoint and convert to pdf using PowerAutomate
Power Automate: The template validation failed: ‘The repetition action(s) referenced by ‘inputs’ in action are not defined in the template.’
Recently, while working on Power Automate(formerly known as Flow), we got an issue saying "The template validation failed: 'The repetition action(s) referenced by 'inputs' in action are not defined in the template." We were trying to use Set Variable action at 2 places inside a loop based on certain condition as shown below: To save … Continue reading Power Automate: The template validation failed: ‘The repetition action(s) referenced by ‘inputs’ in action are not defined in the template.’
Microsoft Flow: Using data returned from N:N relationship for further action
In the previous blog, we saw how to retrieve N:N records i.e. we retrieved the related "Rate" records of a particular "Revenue Schedule Line". In this blog, we'll see how to process the data returned for further action. From our previous example, we wanted to loop through each related "Rate" record of "Revenue Schedule Line" … Continue reading Microsoft Flow: Using data returned from N:N relationship for further action
Microsoft Flow: Retrieve N:N records in D365
In this blog, we'll see how we can retrieve N:N records using Microsoft Flow. Below are the steps: Go to https://flow.microsoft.com and login. After successful login select CDS connector. For demo purpose, let's select "When record is updated" as the trigger point. Select Organisation, Entity Name and Scope as shown and click New Step. Search … Continue reading Microsoft Flow: Retrieve N:N records in D365