Posts

Showing posts from 2022

Power Automate – Send email with embeded image

  Power Automate – Send email with embeded image | Knowledge Share (spknowledge.com)

Filter Query on GetItems based on a date value in Power automate

Create Intialize variable for Future date Value:    addDays(utcNow(),1,'yyyy-MM-dd') Add Get items actions Filter Query :     Modified gt 'formatDateTime(utcNow(),'yyyy-MM-dd')' and Modified lt 'FutureDate' Note: Single quotes around the expression and the reference to the variable.

Cancel bulk running flows in Powerautomate

1)  When we are in the All runs view, we need to open the developer console in the browser. The developer console can be opened by clicking F12 (or holding fn and F12) on Windows 2)  In the developer console, navigate to the  Console  pane. To clear the console window click CTRL + L. The console pane is where we are going to add the JavaScript code that will cancel the running flows.  3)  Copy the first part and run this first, you will get and an error the first time and the second time it works //Include jquery (you may need to paste this following twice) var jq = document.createElement('script'); jq.src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"; document.getElementsByTagName('head')[0].appendChild(jq); jQuery.noConflict() 4)  Then copy the other part, this will start to cancel the flow that is running // Cancel all running flows ( This part you only paste once) confirm = function () {return true;}; setInterval(function () { $("

Execute workflow based on Modified item - Power automate

Image
  if you want to trigger the flow only when an existing item is modified in your SharePoint list, you could consider add the "When an item is created or modified" as the trigger of your flow and add a Condition to check if the existing item is modified trigger yur flow. please take a try with the following workaround: Add a "When an item is created or modified" trigger in Power automate Go to settings using ... In the Trigger Conditions Add the below code @not(equals(triggerBody()['Created'], triggerBody()['Modified'])) OR  if you want to execute the workflow based on field value then use the below code @not(equals(triggerBody()?['Current_x0020_Stage'],null)) ----------------- https://www.c-sharpcorner.com/article/flow-trigger-conditions-for-sharepoint-run-flow-when-needed/