Hello, we are using Microsoft Forms to capture some information. What we would like to do is have an automatic flow so that when we enter 'Yes' into a column on the spreadsheet it sends an email.
The excel sheet we are using is where responses to a Microsoft Form are being dropped (Columns A-I) so sits on our sharepoint (I think - i'm not an expert at this!)
We have added column J into the excel sheet. So when a response to the form is submitted we jump into the excel, we complete a task in another application, then add 'Yes' to column J. This is when we want the email to send, so the flow should watch for a row in column J to turn to Yes, then send email to the details in that row. The email action i am fine with, but cant find the right trigger to automate this.
My searching has let me to some 'When a file is modified (properties only)' triggers, but I cannot access the excel file location from these triggers. I can access the file from some excel triggers as below, but not sure i can use these to automate the process, only to manually run each time.
Any assistance on this really apprecaited.
Thank you
