Power Automate: 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: 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”

Save and Retrieve DataVerse Email Attachments in a Canvas App and Power automate -(Prepare Attachments List) Part 1

In this article I will be providing a step by step instructions where the user can create DataVerse email activity with attachments on a PowerApps Canvas app using power automate. So we start by a creating a new Canvas App through make.powerapps.com and we are going to Start with a Blank App and Call itContinue reading “Save and Retrieve DataVerse Email Attachments in a Canvas App and Power automate -(Prepare Attachments List) Part 1”

Invite External Guest to Teams Using Graph API and Power Automate

In this article I will be explaining how to do an external guest invite through Graph API and power automate , this power automate flow can be invoked from a Microsoft form or from a sharepoint list or whatever you find applicable and the same procedures applies if you want to share your PowerApps canvasContinue reading “Invite External Guest to Teams Using Graph API and Power Automate”

Power Automate: Get Attachment from a File Field Type in CDS and send as Email

The new field in CDS is a very nice feature and looks really cool! Here is how it created in CDS entity: On your CDS entity click on Add Field 2. Add the Field Name and Select Data Type File and then add the field to your form This is how it looks on yourContinue reading “Power Automate: Get Attachment from a File Field Type in CDS and send as Email”

CDS (Current Environment) – Get Option set Label

I run into an issue where i needed to get the optionset value label , Property was available through the old CDS connector and the Dynamics 365 Connector. So to get it from a List Records action you can use a compose data operation with the expression below: Replace fieldschemaname with your fieldName and Apply_to_eachContinue reading “CDS (Current Environment) – Get Option set Label”

Create your website with WordPress.com
Get started