AnsweredAssumed Answered

Query List and Send Notification...too many?

Question asked by hejones50 on Jul 31, 2018
Latest reply on Sep 11, 2018 by hejones50



I've got c550 employees working within my organisation, however only approximately 50 of us use our network with access to SharePoint. I wanted to find a way that enables us to be able to quickly email all staff (even on external networks).


After conducting some research, I managed to do this by having a list of every employees name, department and email address. I created a new workflow on an 'Announcements' app that used 'Query List' to get all those email addresses into a variable and then a 'Send Notification' that takes the title and body of the announcement, puts it into an email and sends it to that variable.


This initially worked (even with an attachment) but after doing them a second and third time I started getting the 'workflow failed to start' error causing me to end the workflow. This happened several times - with and without attachments.


Originally I thought the amount of email address were too large for the workflow to handle so I broke it down via departments and had a separate 'Query List' and 'Send Notification' for each department. Tried the workflow again but got an error at the a random department - I had a look in depth at this and nothing obvious was causing any issue. I played around a bit with it by disabling and enabling the workflow items, when I had it so just that department was enabled it worked fine...however another department then stopped working (with very different amounts of emails). There doesn't seem to be any continuity in this error.


Has anyone had any experience in something similar to this that can make any recommendations?


Thank you