In many business scenarios, it's important to notify users differently when a SharePoint list item is created versus when it's modified. While SharePoint doesn't offer this distinction out of the box, Power Automate makes it easy to implement with a simple flow. SharePoint’s built-in trigger — “When an item is created or modified” — doesn’t differentiate between the two actions. This can lead to repeated notifications if the same email is sent for both events.
In Power Automate, you can check whether the item was newly created or just updated and send a customized email for each case.
-
Trigger the Flow
Use the SharePoint trigger:
“When an item is created or modified”
-
Add a ConditionCompare the Created
and Modified
timestamps:
- If they are equal, the item is new.
- If they are different, the item was updated.
-
Send Different Emails
- In the "If yes" branch (item created), send a welcome or creation email.
- In the "If no" branch (item modified), send an update notification.
![Condition]()
This approach is simple, effective, and doesn’t require any special connectors.