Using a workflow to delete from two calendar lists

Question

I am new to SharePoint so please be gentle...

I am trying to create a calendar for a school which has multiple overlays...the reason is each overlay list will have the permission for the intended audience, be it staff or pupils etc...

I am also making a submit entry point so staff can view the fact they have submitted a request which then is copied to another list named pending, this pending list has a few more fields for the approver to edit then once finished modifying the item is then copied to the right calendar list for the overlays...

So here is the fun part...if the approver rejects the event I use the workflow to email the event creator, delete the item from the submit list and then delete the item from pending list...this worked when I used custom lists but now I am using built in calendar list and have as strange result...

My onchange pending list workflow does the following

if Status eqauls reject
  email creator (DOES NOT WORK)
  delete from submit list where submitid equals currentitem submitid (WORKS)
  delete from current list (DOES NOT WORK)

Oh and the submitid value is unique, I create that on the submit list with an oncreate workflow that copies ID to sumbmitid column

The above workflow worked if using custom list but not since I used calendar list...also if I remove actions and try each one on its own then they all work...for some reason when combined only the one deletion works

one more thing, If I am approaching this whole idea in the wrong way then I am happy to be told...will post any more info that is needed to have this moving forward

any pointers appreciated...thanks

Answer 1

I can only suppose that you cannot delete the item on which you workflow is running from the workflow itself. But I have another note for you - if you using a workflow only for automatic action where there's no long running operation like interaction with users than it's more appropriate to create an event receiver (here's the another example) for the list - it's designed to make such a short operations. You need to create an event receiver, handle ItemEdited event and do execute your delete logic there.