Hi All,
Quite new to power automate (my strength lies in Power Apps).
I have an workflow app for a team to manage requests from the business. There is an ability for the both team members, and users to leave notes for each other (this occurs via a simple append formula, adding the latest text to a multi-text field).
I have a workflow set up that triggers via:
- If the "Notes" field is updated, then:
1. Send an email to the team member IF not modified by the team member, or
2. Send an email to the user IF modified by the team member.
To date this works well, but I was hoping to optimise and move this into Teams to reduce email.
At first the flow below works fine, BUT two issues:
1. It triggers whenever the any part of the item is modified and not just the notes.
2. Is there a way to add only the most recent appended text into the body of the message and not the whole historical text?
For context my condition is:
- Has the notes column changed = true
- Has the item been modified by the team member = not true
If true, notify the team member
If false, notify the user
Any help would be appreciated.
DW
