Unanswered

Flow didn't work as expected

Like (0) Share

Report

Posted on 29 Apr 2021 17:14:43 by sliu1

I have a flow to be triggered when a new item is added to a list to send out email. It worked fine last year. But it didn't this year. (it was used yearly). I loaded the data from excel file via Access to append the data to the list. Some rows were triggered twice, that is, two emails were sent out; some rows didn't trigger at all, that is , no email was sent for those. Why and how this happened?

Any idea is welcome!

Shiying

All responses (2)

Answers (0)

sliu1 33 on 06 May 2021 at 17:57:31

Like (0)

Report

Re: Flow didn't work as expected

I did have the list open while loading the excel file via Access.

37 out of 1110 didn't trigger the email. 18 out of 1110 had duplicate emails. All others worked fine. Where to look for these exceptions?
rrovira Microsoft Employee on 29 Apr 2021 at 21:11:15

Like (0)

Report

Re: Flow didn't work as expected

Hello, @sliu1!

For what I read, your flow is still running (meaning you haven't got any email saying that your flow was going to be disable if left unused), right?

I have some theories as to why is not working properly. Something that has personally happened to me, is that I add data to an specific source (e.g. Sharepoint) and because I have it opened when the flow is running, it doesn't work properly and duplicates emails or it doesn't detect some new data.

I would also recommend you double checking the connection to make sure everything is running correctly, although if you are getting some of the emails, that should mean everything is well connected. I'm not sure if someone has another idea of why this could be happening, but let me know if that piece of advice helped you!

Cheers,
Rodrigo