Hello,
I managed to muddle through a flow where a form response is submitted it will send an email to a specific email address captured as a question in the form.
However, because it is triggered each time a new response is submitted it performs the same action for all of the previous responses too.
I am assuming that there is a way to add an id to a column when the flow reads the data from excel after it performs the action of emailing. Then there must be a condition where my email flow only works if the cell where the ID will go is blank. Therefore, it will only ever send one email to a person.
Is this possible? Or is there a better way to avoid the duplication of an email each time a response is submitted?
Thank you very much in advance.
