Posts

Showing posts with the label Power Automate

Power Platform Trigger Condition(Run Flow 1st of every month)

     Trigger Condition  in Automatic Flow 1st Day of the Month   -- Testing to trigger today  ==> "@equals(formatDateTime(utcNow(),'yyyy-MM-dd'),addDays(startOfMonth(utcNow()),22,'yyyy-MM-dd'))" Last Day of the Month   -- Testing to trigger today ==>  "@equals(addDays(utcNow(),7,'yyyy-MM-dd'),formatDateTime(subtractFromTime(startOfMonth(addToTime(utcNow(),1,'month')),1,'day'),'yyyy-MM-dd'))" 1st Day of the Month ==>  "@equals(formatDateTime(utcNow(),'yyyy-MM-dd'),formatDateTime(startOfMonth(utcNow()),'yyyy-MM-dd'))" Last Day of the Month ==>   @equals(formatDateTime(utcNow(),'yyyy-MM-dd'),formatDateTime(subtractFromTime(startOfMonth(addToTime(utcNow(),1,'month')),1,'day'),'yyyy-MM-dd'))

Add or Update Rows in Excel from SharePoint with Microsoft Flow

Image
 

PowerAutomate - Get Column before & After value changes

Image
  1. Get previous item history and updated value using sharepoint rest api 2. Send email to SharePoint users Groups.