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”

DataVerse Tip #5: Display Choices Column in Canvas App

Multi-Choice or Choices column in DataVerse is used so that you can select multiple options for a column in DataVerse, So for this example on the Sample Table I have a column of type choices and I want to display the Choices Column in a Gallery Control in Canvas App. It is simple and quickContinue reading “DataVerse Tip #5: Display Choices Column in Canvas App”

DataVerse Tip #4: To field on email can’t find my table

One of the common requirement is that you have a new custom table to be used in the Email To, BC and CC or even an existing table like contact table but you can’t find it in the list of tables in the To. Example: Here we can’t see the contacts table only we canContinue reading “DataVerse Tip #4: To field on email can’t find my table”

DataVerse Quick Tips#3: Enable/ Disable Plugin Steps all at once

In more than one situation where you are performing data updates for a large set of data you need to disable all plugin steps and then re-enable it. So using SQL CDS for XRMToolbox and use the below scripts to enable / disable the Plugin Steps: Install XrmToolBox (https://www.xrmtoolbox.com/)¬†and the SQL 4 CDS tool (markcarrington.dev/…/)Continue reading “DataVerse Quick Tips#3: Enable/ Disable Plugin Steps all at once”

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”

Dynamics 365 + DataVerse Insert Dynamic Email Template

Creating email templates helps you save time and increase productivity while sending the same email style by having some of the information prefilled , There is Out of the box shipped email templates with Dynamics 365 but it has a lot of limitations when it comes to the dynamics parameters in your template which makesContinue reading “Dynamics 365 + DataVerse Insert Dynamic Email Template”

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”

Create your website with WordPress.com
Get started