
Hello all,
Hope you are doing well. I have a few issues with Flows I am making in Power Automate that I would greatly appreciate your help on as I've been stuck on them for a little while now. One of my problems is that I want to create a specific email that sends to the email in the SubmittedBy column of a SharePoint item (whose contents were already read into the list by a Flow I created that is triggered by a Microsoft Forms submission) when a specific status column value is changed. The Status value is set to a default value when the SharePoint item is created, but it will be manually changed to another choice in the column (there are multiple choices in this status column). I want to be able to send an email to different people each time this Status column is changed to a different value on the list of choices for this column (except for the Default value).
You need a separate flow for this. Use a trigger that fires when the item in SharePoint changes. Depending on the type of column where the status is stored you should add a trigger condition so it only fires when the value changes in that column. Then get the email of the person you want to send it to and send the email.