Power Platform Community Forum Thread Details

I have a couple drop down lists on a Sharepoint Excel File and I want to create a flow that will send an e-mail notification to the person when they are chosen under the 'Assigned to' column and send an e-mail to myself when the 'Status' column is updated.

For an Example:

So I do not have to show anyone's name I am using the Status column. When I set row 8 to Completed under the 'Status' column how do I trigger and e-mail to come my way stating that that the task is now Completed. I would use this Flow to trigger an e-mail to anybody who is chosen under the 'Assigned to' column.

Thanks in advance. Capture - Sharepoint Excel File.PNG