Automatically send an email to a user when 'assigned to' column is modified? (SharePoint Online)
We have a list that contains items which go through an approval process. When a list item is first created, a name is put into the 'assigned to' column, indicating the first approver. When that user approves the item, they will modify the name to the next approver, etc. We need a system where each time this 'assigned to' name is changed, the name of the new approver added to the column is notified via email. I can't for the life of me figure this out. Some people said elsewhere on Google to use SharePoint Designer, but this software gives me all sorts of errors when trying to connect with any SharePoint Online site. SharePoint Online's inbuilt flows feature doesn't seem to be great either. Any suggestions?