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.
Please post a screen shot of your Flow and I'll try to assist.
Thanks for the help. It's just very basic. The email is collected from the answer to a forms question, but it works.
I just need to make it so that once the flow has actioned the email once, it doesn't repeat.
Thanks again for any help
Sorry for the late response - on vacation (at the beach) this week.
You need to filter the data that you are retrieving from Excel. Here is a link to a Blog post that explains how.
Post here please if you have additional questions.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.