My SharePoint administrator granted permissions to services, sp app pool, sp farm adim, and secure store in BCS for me to use but was only able create/delete but not update. I use SharePoint designer 2013 list workflow to create/delete external list item on SQL DB but not update. Got permission message on System Account when delete:

The workflow could not update the item in the external data source. Make sure the user has permissions to access the external data source and update items.

We reviewed the Posting and double checked our steps but still no avail. Anyone have similar issues or ideas on how to troubleshoot and fix?

  • I'm sorry, I can't understand clearly what the problem is. Is the account unable to update items or unable to delete items or both? Mar 18, 2014 at 17:59

1 Answer 1


Firstly, please check the account which starts the workflow has enough permission on the external list. (If the workflow starts automatically when new item created, please check the account that created the item. If workflow starts when item is changed, then check the account that modified the item.)

Read more details here. Also check this blog to narrow down it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.