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

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: Quick Tips # 1: Date Difference Function

A frequent requirement is to calculate the difference between 2 dates in power automate, This can be achieved easily in power automate with the help of the Ticks function. Definition :- ticks(timestamp: string) – Returns the number of ticks (100 nanoseconds interval) since 1 Jan 1601  00:00:00 UT To get the difference in days between 2Continue reading “Power Automate: Quick Tips # 1: Date Difference Function”

Adding Conditions on a SharePoint List Choice Fields in Power Automate

I have a choice Column in a sharepoint list with Status Active/ Closed. I want to execute an action but only when an item is created/ Modified in the list on condition that it is only has status = Closed. So i added a trigger action when an item is created or Modified, Set theContinue reading “Adding Conditions on a SharePoint List Choice Fields in Power Automate”

Create your website with WordPress.com
Get started