I have an external list in Sharepoint Online that is connected to SQL server (Azure) via BCS and secure store. I can manually add/edit items and it they immediately show up in the DB.
I built and published a 2010 workflow in SP Designer that copies certain portions of a custom list and creates a new item in the external list (Can't do this with an external list using 2013 workflows). I have several other 2013 workflows that do this exact process but they are creating items in another custom list, not an external list, and they all work fine.
However, the 2010 workflow that is supposed to create an item in the external list always fails and gives me the message:
The workflow could not create the item in the external data source. Make sure the user has permissions to access the external data source and create items.
I am the owner/admin on both Sharepoint and SQL DB with full owner permissions. Obviously sharepoint isn't giving the workflow permission to create the item but I have no idea how to fix that. I followed this 9-step answer and got my site to 'trust' the workflow app but that had no effect - the workflow still fails.
Please help. I'm not very advanced so please talk down to me - I will not be offended!