Power Automate Quick Tips #4: Error Loading Control

Below is one of the common issues that has been reported recently on the Power Automate Community; After clicking on any form variable or trying to create one/create an expression, the component collapses with this error message. So the easy fix to it is to Turn off Experimental Features, To do so please follow theContinue reading “Power Automate Quick Tips #4: Error Loading Control”

Power Automate: Quick Tips #3: Adding Multiple Conditions to Filter Array

#PowerAutomate #QuickTips Adding Multiple Conditions to Filter Array: if you need to filter a JSON array where Job Title Does not Contain Either Director and does not contain Manager. JSON Sample: Output: References: https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference

Building Flows #4: Send Multiple Attachments from OneDrive to Outlook

This blog article describes in a few lines how to send multiple attachments from a one drive folder to outlook in less than 5 minutes. List the files in a folder and select the folder from which you wan to send the attachments, and Initialize and array variable called Attachments Array as below: 2. ThenContinue reading “Building Flows #4: Send Multiple Attachments from OneDrive to Outlook”

Building Flows # 3: Grouping in a Power Automate

One of the common business scenarios that we see in everyday and I have seen many questions on the community forums about this one which is how to do grouping in Power Automate, So a common example you have a sharepoint list, Excel Sheet, DataVerse table and you need to send a consolidated email ofContinue reading “Building Flows # 3: Grouping in a Power Automate”

Power Automate: Quick Tips #2: Useful Date Expressions

Power automate is provide a cool function which is StartOfMonth which gets the first day of a month and it is a very cool function but they did not provide the Last Day of Month. To get the Last day of the previous month use the below expression: To get Last day of current MonthContinue reading “Power Automate: Quick Tips #2: Useful Date Expressions”

Power Automate and SharePoint ODATA Filters

One of the common issues being faced is dealing with ODATA filtration in sharepoint lists so I will be listing here common issues and how to sort them out: Filtering by Lookup: Example: You have a List called Tickets with a Lookup Column to another List called Ticket Types, Column Name TicketTypes to do theContinue reading “Power Automate and SharePoint ODATA Filters”

Environment Variables in Flows as Parameters

#powerautomate #environmentvariables I have written a blog post earlier about the using of environment variables to store global environment settings and while I was looking to use it the same way I have described in my blog Post. GUESS What I HAVE found! They are directly Exposed as Parameters in my flow and can beContinue reading “Environment Variables in Flows as Parameters”

Custom Connectors- Get Flow Runs History

This is my first attempt to work on custom connectors and on this first attempt , I will be using OpenAPI definition to create the custom connector. Step 1: App registration Login to Portal.azure.com Click on Azure Active Directory on the Home Page 3. Click on App Registration-> New App Registration 4. Enter App NameContinue reading “Custom Connectors- Get Flow Runs History”

Invoke D365 OTB word templates from Power Automate

One of the nice features available out of the box is the ability to generate Word Templates in an easy way while using customer engagement apps (Dynamics 365 Sales, Dynamics 365 Customer Service, Dynamics 365 Field Service, Dynamics 365 Marketing, and Dynamics 365 Project Service Automation). But not usually you need to generate or useContinue reading “Invoke D365 OTB word templates from Power Automate”

Save and Retrieve DataVerse Email Attachments in a Canvas App and Power automate -(Saving attachments) Part 2

On part 1 of this article , I have explained how to pass the attachments from the canvas app to power automate; In this part will be explaining in details how to save an attachments to an Email DataVerse record. We have explained in part 1 that we are passing attachments collection as first parameterContinue reading “Save and Retrieve DataVerse Email Attachments in a Canvas App and Power automate -(Saving attachments) Part 2”

Create your website with WordPress.com
Get started