@BenBennett321 No worries. Tip: Remember to rename your actions to keep your flow organized!
Trigger Condition (Optional)
If you'd like to only trigger your flow when an item is modified—you can add a trigger condition to your flow. When a New Item is Created the Version is 1.0.
You can use that to differentiate between when an item is created or when it's modified.
To only trigger an item when it's modified, you'll need to compose an expression. First, add a Compose action to your flow and insert the Version number dynamic content from your flow trigger.
Click on the three dots and select Peek Code.
Copy the expression after the @ symbol and before the closing double quotes to your clipboard.
Click on the three dots of the trigger conditions and select Settings.
Scroll down to the Trigger Conditions. You'll need to include an @ symbol at the start of a trigger condition expression.
First insert the not() function.
In between the not() function insert the equals() function.
In between the equals() function paste the expression from your clipboard.
Add a comma, then insert a 1.0 between single quotes. This expression will only trigger the flow if the version is not equal to 1.0 (aka the item was not just created).
Run a test. First, create a new item in your SP list. The flow should not trigger. Then modify an existing item. The flow should trigger.
Get Changes for the SP Item
Add a Get changes for an item or a file (properties only) action to your flow. In the ID field, insert the ID dynamic content from the flow trigger. In the Since field, insert the Trigger Window Start Token dynamic content from the flow trigger.
You've indicated in your original post that you only want to send a notification a specific column has changed. To do this you'll need to check if the column has changed before continuing on with your flow.
For testing purposes while building the flow, add a Compose action to your flow. Insert the Has Column Changed: [Your Account Number Column] dynamic content. For my SP List, it's the Has Column Changed: Custom ID dynamic content.
Run a test. Make a change to the Account Number Column. Review the output of the Compose action. The Compose action should output true.
Condition Check
Add a Condition action to your flow. Insert the output from the Compose action above into the first value field. This is why naming your actions is important. Especially when you have multiple instances of the same action. It makes it easy to identify which dynamic content belongs to which action.
Leave the operator to is equal to. Enter true into the second value field.
Add the rest of your actions into the YES branch. The flow will only perform those actions if the Account Number column has changed. If not, then nothing will happen.
Send an Email (V2)
Whenever you are building a flow that sends an Email or Teams message, always use your email address in the recipient field until you've confirmed your flow is working as expected. Once your flow is ready to go you can replace your email address with the email address of the actual recipient.
Personally, I like to insert the email address of the actual recipient into the Subject line or Email/Message Body while I'm building and testing my flow.
Compose your subject line and insert any dynamic content from your flow trigger if that suits your requirements.
Add any static text and dynamic content into the email body.
Run a test. Review the outputs of your email and ensure it's what your expecting. Adjust your email format until you are happy with it. Once you've confirmed everything looks good and your flow has been tested a few times. You can replace the recipient with the appropriate recipient.
If you are looking for a way to send multiple SharePoint List items that have been assigned to a user in an email—check out this YT Tutorial: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow
In this tutorial I cover:
✅ How to send multiple list items in a single email with a Power Automate Flow
✅ How to create a dynamic date range
✅ How to use the Convert Time Zone action
✅ How to use a Filter Query in the Get Items action
✅ How to count number of items in an array
✅ How to use the Select action to extract a users display name and email address
✅ How to create a unique list of email addresses
✅ How to use the Create HTML Table action
✅ How to customize the HTML Table with CSS styles
✅ How to use the Send an email (V2) action
✅ How to use the Append to String Variable action
✅ How to create a custom list of items for an email
✅ How to use the Send an email (V2) action
✅ How to display singular or plural text based on the number of items returned
Hope this helps!
