I have 2 flows that I have working but, am receiving multiple emails on each run. The first flow copies data from a SharePoint list to an Excel file that is stored on the SharePoint site. Once this flow runs, I have another flow that sends an email and attaches this Excel file, when it is updated. The problem is, when the flows run, 2 emails are sent. The attachment in the first email only contains 1 record, the second email attachment contains all the records. Has anyone else experienced this issue? How can I stop the first email from being sent and just have the second email sent that has all the records?
If you could send screenshots of the flows it might help. It seems like you have a loop somewhere.
That doesn't quite give enough insight. What is the initial trigger in the first flow? It's possibly triggering twice. You could check your run history and see if it is running multiple times with each trigger or if it's sending the email multiple times. If it's just the email then you have the send email in an apply to each that is getting called more than once. If the flow is running multiple times then your trigger is the issue and whatever is calling it may be the issue. It could also be that the trigger of the second flow is being called more than once (the file is created and then it is modified calling itself again). You may want to add a boolean in the list itself called mailSent or something and use it to tell whether or not your email has been sent.
User | Count |
---|---|
6 | |
6 | |
4 | |
4 | |
2 |
User | Count |
---|---|
8 | |
8 | |
4 | |
4 | |
4 |