0

I have been using Power Automate to create some workflows for a SharePoint list. There are a series of emails which get sent to different users as the Status column is changed - this is triggered when an item is created or modified it checks the status and sends an email as appropriate.

This works fine since it is a linear process where a user does their task and then changes the status.

However there is one field that will be activated at some point through the process and will stay constant through a number of the different statuses.

Is there some way we can have a field that just triggers the workflow the first time that value is selected. Otherwise it will be sending duplicate emails every time the item is modified and that field remains selected.

2 Answers 2

2

Flow has a newish action called "get changes for an item or a file", which allows you to determine which column changed. Here is the blog post introducing the action, and there is also a video showing usage.

1

I agree with Mike2500, you can use "Get changes on an item or a file (property only)" actionn to achieve your needs. You can rely on this action to determine which column is changed.

Here is a good case for your reference:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.