I'm fairly new at Nintex Workflow and I'm trying to solve a simple use-case scenario our business has. Basically, I need a workflow to kick off every time a record is added to a certain table in our database. To solve this issue I've created an external content type tied to the database table and I've created an external list which is tied to that content type. Now, every time a record is added to the table an item is created in SharePoint. Fantastic! Now I just need to tie a workflow to this external list... however, the Nintex workflow icon is greyed out. See image:
Is there a way to attach a workflow to an external list? Or, is there a different/better way I could accomplish what I'm after? I know I can query a BCS but I'd rather the workflow kick off when an item is added as opposed to me querying on a timer (poling).
Note: I'm a C# developer who's not very familiar with SharePoint or Nintex so please be descriptive. Thank you!
Solved! Go to Solution.
The workflow settings is disabled here because SharePoint doesn't support workflows on external lists. Here are some articles on the known issue from Microsoft.
Workflows cannot be associated with an external list. In SharePoint Server 2010, although workflows work with external lists, they cannot be associated directly with external lists. You can create a site workflow, or have a list workflow on a SharePoint list, such as a document library, and have it read or update from an external list. You can also use an external list item as a destination for a task process in SharePoint Designer; however, the link to the task will not display a title for the external list item.
The only work around I can think of is to use a native list and have external columns in that list, if that is on any help.