I have a requirement to trigger a power automate workflow after 14 days from when a specific field gets updated in a SharePoint list.
Please guide me on this.
Thanks
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityYou can take a look into the following options below:
A) Trigger - [When an item is created or modified]
Set a trigger condition so that Power Automate is triggered only when the [Specified] field has a specific value like @equals(triggerBody()?['SpecifiedField']?['Value'], 'Pending')
Within the body of the Power Automate, wrap business logic by adding a [Delay] action and set it to delay for 14 days.
Power Automate will starts in this case, but business logic will be not be processed until after 14 days has passed.
B) Use Scheduled/Recurrence Power Automate
SharePoint List Update
Add a calculated column, say [ChangedDate], with expression like =IF(Title="ABC",TODAY(),DATE(2050,12,20))
. In the example, [Title] is the specified field. When updated to a specified value, capture and store the current date and time. Also, add another column of type Choice, named it like [FlowStatus] with default being Pending that gets updated to Completed from Power Automate once it completes.
In Power Automate - schedule to run daily
Using [Get items] action with a filter like Title eq 'ABC' and FlowStatus eq 'Pending'
, retrieve all items from the list
Add a [Filter] action to further filter out items that were updated 14 days earlier. Since [Get items] does not allow filtering on a Calculated column, this additional filter is required.
Here is an example of the Filter expressions: [ChangedDate] is less than addDays(utcNow(), -14, 'yyyy-MM-ddTHH:mm:ssK')
.
Add [Apply to each] to process each item in the filtered out items list
Within, [Apply to each], update each items [FlowStatus] to Completed