I need to create a trigger when a field(eg: Review DRI) in any item of Sharepoint List changed

Question

I am trying to create a trigger in my Sharepoint List to fire when the field "Review DRI" of any item in the list is updated. I want to use Power Automate as the trigger mechanism, but I am not sure how to start. My ultimate goal is to send an an email to the updated Review DRI.

Answer 1

Hi @Huang, Shiyi [MDDCN NON-J&J] ,

As the Q&A forum is an open platform, please pay attention to protecting your privacy information. When posting a question, cover or code your private information. Thanks.

You can try flow:

1. Select "When an item is created or modified" as the trigger.
2. Add a condition to check item is modified. If modified is equal to created, the item is new.

3. If the condition is false, use the "Get changes for an item or a file (properties only)" action to get the previous and current values of the field, and then compare them using a condition.

Fill in the following expression in the Since field:

add(int(triggerOutputs()?['body/{VersionNumber}']),-1)

4. If the condition is true, add an action to send an email to the updated Review DRI. You can use the "Send an email" action and select the Review DRI field as the recipient.

This is the list for test:

This is the full flow:

This is the email:

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.