Trigger condition - detect changes in a specific date column

(0) Share

Report

Posted on by Flow-Fiesta

Hi everyone,
I’m looking for a way to set up a flow in Power Automate that triggers only when the value of a specific date-type column, called StartDate, is modified in a SharePoint list.

The goal is to detect when a user changes the date in this column, regardless of whether the new date is earlier or later than the existing one. The flow should not trigger for any other changes made to the item.

Does anyone know how I can achieve this? Are there specific configurations or a way to filter this type of modification in the trigger?

Thank you in advance for any suggestions or help you can provide.

Regards

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Garima_PowerPlatform 170 on at

Like (1)

Report
To set up a Power Automate flow that triggers only when the value of a specific date-type column, like StartDate, is modified in a SharePoint list, follow these steps:

Step 1: Use the "When an item is created or modified" Trigger

In Power Automate, create a new flow using the "When an item is created or modified" trigger.

Connect the flow to the SharePoint list containing the StartDate column.

Step 2: Add a "Get changes for an item or a file (properties only)" Action

After the trigger, add the "Get changes for an item or a file (properties only)" action.

Configure it as follows:

Site Address: Your SharePoint site URL.

Library Name: The name of your list.

Id: ID (from the trigger).

Since: Trigger Window Start Token.

Step 3: Compare Changes for the StartDate Column

Add a Condition to check if the StartDate column has been modified:

In the Condition, use the Output of the "Get changes for an item or a file (properties only)" action.

Format:
body('Get_changes_for_an_item_or_a_file_(properties_only)?['ColumnName/HasChanged']
Replace ColumnName with your actual column's internal name (e.g., StartDate).

Example Expression for the condition:

body('Get_changes_for_an_item_or_a_file_(properties_only)')?['StartDate/HasChanged']

Set the condition to proceed only if the HasChanged value for the StartDate column is true.

Step 4: Perform the Required Actions

In the If Yes branch of the condition (indicating that the StartDate column was modified):

Add the actions you want to perform when the date changes (e.g., send an email, update another list, etc.).

Leave the If No branch empty to prevent the flow from running for other changes.

Step 5: Test and Deploy

Test the flow by modifying the StartDate column in the SharePoint list.

Ensure that the flow does not trigger for other column changes.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Was this reply helpful? Yes No
Flow-Fiesta 16 on at

Like (1)

Report

Hi Garima_PowerPlatform

Thank you so much for your detailed response! I really appreciate the time and effort you put into explaining the steps.

Unfortunately, this approach doesn’t fully meet my needs. My main concern is that the flow would still trigger every time any change is made to the item, regardless of the column modified. While the condition you described helps filter out unnecessary actions within the flow, it still means the flow executes on every modification, which I’m trying to avoid.

What I need is a way to configure the trigger condition itself so that the flow only fires if the StartDate column is the one that was modified. Is there a way to add a specific condition or syntax directly in the trigger condition to achieve this?

Thank you again for your help, and I’d love to hear any additional suggestions you might have!

Was this reply helpful? Yes No