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